Financial Ledger Links for TAS

► Download the Manual
► Price List
► Software Downloads
► TAS Data Transfer File Specifications
► Success Stories

Introduction

Use Financial Ledger Links if you need to:

• Automate the transfer of data between your Front Office business system and TAS Books.
• Update the TAS Customer/Supplier database with lots of customers'/suppliers' information (new or existing TAS customers) from your Front Office system.
• Post large volumes of Journal transactions into TAS, such as Invoices, Credit Notes, Payments, Receipts etc from your Front Office system.
• Get your TAS Financial Ledgers up to date quickly at daily, weekly or other periodic intervals.
• Avoid duplication and errors caused by re-keying your Front Office system's transactions into TAS.
• Save valuable staff time - and save your staff from tedious data entry - using a range of labour-saving tools.

This software actually consists of four separate modules. Each module links to a different TAS Ledger and they can be purchased individually and independently of each other, to suit your exact needs:

Ledger Module

Sales Ledger Link

Purchase Ledger Link

Cash Book Link

Nominal Ledger Link

Each module is available in a variety of combinations to match your requirements:

Number of Companies	Single Company or
	Multi Company
Number of Users	Single User or
	Multi User
Optional Features	Where applicable

So, you only pay for what you need.

Key Features & Benefits

The following two tables give you quick summaries of the main features and benefits. You can “drill-down” to get more detailed information by clicking the » buttons, from where screenshots are available by clicking the buttons.

Key Features		Ledger Module
		SL	PL	CB	NL
TAS and Sage CSV formats supported	»
High speed Import and Update of Customers/Suppliers	»
Import/Post journal Transactions – all main types supported	»
Import/Post Customer/Supplier Opening Balances	»
Auto-allocate Receipts and Credits	»
Import Allocations from File	»
Import and Update Financial Budgets	»
Bulk change Customer/Supplier account Codes	»
Report/Export Customer/Supplier details	»
Report/Export Debtors’/Creditors’ Open Items	»
Crystal Reports ™	»

 

Key Benefits		Ledger Module
		SL	PL	CB	NL
Rapid integration and setup without compromising security	»
Streamline your business processes	»
Achieve reduced costs & Increased Profits	»
Integrate with your other business software	»
Get advanced functionality	»
Eliminate re-keying errors	»
Reduce delays and bottlenecks	»
Improve financial control	»
Avoid changes to your front office software	»

 

Full Details

Detailed Features		Ledger Module
		SL	PL	CB	NL
High Speed Processing
•  Sage & TAS Import File formats handled
•   Imports data from CSV export files created by existing ‘front office’ systems for both Sage and TAS specification formats – no need to change your existing software programs:
•  Sage Line 50 standard
•  TAS traditional ('.DAT' files)
•  Customers/Suppliers
•  Imports new customers’/suppliers’ information to the TAS database, including Notes
•   Optionally, updates existing TAS customers’/suppliers’ addresses, contact details etc
•   Automates data entry in TAS functions 211/311 – process 100’s of customers/suppliers in seconds
•   Almost 100 columns/fields of customer/supplier information are handled
•   Option to switch off customer/supplier update - only import new customers from file
•   Detailed text Log is produced for each import run
•   Transactions
•   Auto-post all types of SL/PL/CB Journals – 100’s of transactions in seconds:
•   Invoices
•   Credit Notes
•   Receipts
•   Payments
•   Debit Journals
•   Credit Journals
•   Refunds
•   General Journals
•   Automates data entry for the 8 main Sales & Purchase Ledger TAS transaction functions:
•   220/320, 221/321, 222/322 and 251/351
•   Automates data entry for the 3 main Cash Book TAS transaction functions:
•   420, 421 and 422
•   Updates TAS Nominal Ledger records, including Nominal Group Summaries, plus the (standard) VAT Register
•   Updates TAS Customer/Supplier records, including Group Summaries, plus the Top Customers/Suppliers Dashboard (TAS v5+ only)
•   Multiple Nominal Account analysis lines handled to maximise financial control
•   Sage to TAS VAT Rate code mapping (‘T1’ = ‘1’, ‘T0’ = ‘3’ etc)
•   Update of TAS System Audit Log helps prevent import of duplicate invoices etc
•   Comprehensive text Log of import/posting results, including errors and warnings
•   Budgets
•   Imports new and revised budgets to the relevant TAS Chart of Accounts
•   Supports different types of budget: Original, Revised and Future
•   Comprehensive text Log of import results, including errors and warnings
•   Auto-Allocate Receipts and Credits
•   Auto-allocate from 100’s of Cash Receipts/Credits to target Invoices/Debits in seconds
•   Allocations are based on user-defined Business Rules for matching transactions and including customers:
•   Match exact (oldest first)
•   Oldest outstanding
•   Over/under Credit Limits
•   Ability to skip pre-selected customers whose accounts need manual intervention
•   Full text Log is produced showing details of allocations made
•   Import Allocations from File
•   Imports Allocation instructions for existing Cash Receipts/Credits against existing Invoices/Debits
•   Lets you preview the Allocation instructions and apply them in seconds
•   Opening Balances
•   Auto-post all types of SL & PL Opening Balances as Debit or Credit Journals – 100’s of postings in seconds:
•   Outstanding Invoices
•   Outstanding Credit Notes
•   Outstanding Receipts
•   Outstanding Payments
•   Outstanding Debit Journals
•   Outstanding Credit Journals
•   Outstanding Refunds
•   Automates data entry for the 4 main Sales & Purchase Ledger TAS transaction functions:
•   221/321 and 222/322
•   Updates TAS Nominal Ledger records, including Nominal Group Summaries
•   Updates TAS Customer/Supplier records
•   Update of TAS System Audit Log helps prevent import of duplicate invoices etc
•   Comprehensive text Log of import/posting results, including errors and warnings
•   Change Customer Codes
•   Setup or import and preview multiple Customer Code Change instructions for existing Customers
•   Preview and edit the instructions before applying them
•   Apply all the Customer Code Change instructions “in bulk” as a single batch process, updating all TAS history associated with each Customer
•   Full text Log is produced showing details of changes made
Report/Export
•  Customer/Supplier data
•  Multiple selection criteria are available for filtering to exact needs, all code fields giving the option of ‘All’, ‘Range’ or ‘Single’ selection; choose from up to 11 criteria:
•  Customer/Supplier & Customer/Supplier Group codes
•  Salesperson code
•  Marketing code
•  Postcode & Name
•  Start Date – all, range or single
•  Active, Inactive or both
•  Credit Stop On, Off or both
•  Price Type – any combination of ‘Retail’, ‘Trade’, ‘Wholesale’, Qty Break or all
•  ‘Also Supplier/Customer’ status – Customer/Supplier only, Customer & Supplier only or both
•   Debtors’/Creditors’ Open Items
•   Multiple selection criteria are available for filtering to exact needs, all code fields giving the option of ‘All’, ‘Range’ or ‘Single’ selection; choose from up to 13 criteria:
•   Customer/Supplier & Customer/Supplier Group codes
•   Salesperson
•   Marketing code
•   Postcode
•   Customer/Supplier Name
•   Customer/Supplier Start Date
•   Active Customer/Supplier - Active/Inactive/Both
•   Customers on Credit Stop – On/Off/Both
•   Customer's/Supplier's Net Balance Amount - any of Credit/Debit/Zero
•   Supplier/Customer Status - One Only/Both
•   Transaction Type - Any combination of 5 main types
•   Posting Date
•   Crystal Reports ™
•   Standard Crystal ‘.RPT’ type templates
150 Customer/Supplier fields available for use in reports Customer/Supplier reporting templates
Easy Setup & Administration
•   User security
•   System Integration Manager (“SIM”) lets you control all User access rights centrally
•   Single Log-in lets user(s) access this and other modules – but only as authorised
•   Controls individual user access rights to functions within each TAS company’s data
•   Discontinue/Reinstatate users globally and per Module/Company as required
•   System Defaults
•   For specifying folder Locations of Import Files and Logs
•   To set up Import file types (Sage or TAS) and VAT Rate code mappings for Sage
•   Configuration of Business Rules for Auto-Allocation of Receipts and Credits
•   Upgrades
•   Simple registration and application of upgrades

 

Detailed Benefits	Ledger Module
	SL	PL	CB	NL
Streamline your Business Processes
•   Eliminate Time consuming work
•   Automatic data transfer streamlines your business by eliminating time consuming processes and simplifying the steps involved in rapidly and regularly transferring data from front office business systems to TAS.
•   The steps are quick and easy to implement and processing time is negligible compared to manual data entry.
•   Improve Customer Service
•   With up-to-date information available in TAS you can service your customers more efficiently
•   Increase productivity and remove dull and repetitive clerical functions, thus freeing up staff for more productive tasks
•   Achieved Reduced Costs and Increased Productivity & Profits
•   Reduce Expensive Manual Processing
•   The modules drastically reduce processing time and cost by allowing automatic imports from existing front office software programs
•   The ability to process around 600 records per minute represents substantial cost savings compared to re-keying data manually into TAS
•   Minimise Debtors - Maximise Cashflow
•   With an up-to-date Sales Ledger you can issue accurate Statements promptly, get the cash in faster, reduce borrowings/increase deposits and improve your profits
•   Integrate with your other Business Software
•   Leverage your software investments
•   By linking up your software you can increase the overall benefits
•   Make 1 + 1 + ½ = 3+…!
•   Get Advanced Functionality
•   …without paying a fortune
•   Infoplex modules give you features that are only available in other accounting software which can not only cost you £’000’s to implement, but £’000’s more each year to maintain and get support cover
•   The modular design lets you focus on the functions you need, without paying for and being lumbered with unnecessary and confusing features
•   Eliminate re-keying errors
•   Improved data quality
•   Because data transfer is automatic, you avoid poor quality data as a result of human error during re-keying.
•   This results in excellent data consistency between TAS and front office systems.
•   Reduce delays and bottlenecks
•   Faster decision making
•   Because so much data can be transferred so quickly the information is available almost instantaneously in TAS reports and enquiries
•   This speeded up processing helps faster decision making
•   …with reduced stress
•   With smaller delays and bottlenecks, frustration and stress among staff, customers and suppliers are minimised
•   Improve Financial Control
•   Effective Financial Management
•   Instantaneous updating of the Ledgers lets you:
•   Understand the exact financial position
•   Actively monitor income and expenditure against your budget
•   Be accountable and transparent
•   Give regular up to date reports to all those to whom you are accountable
•   So you can plan financially, making informed decisions about budgets and spending
•   Better Financial Security
•   Avoid losing money because of mismanagement, corruption or theft
•   Have documentary proof of all money receipts and payments
•   Avoid changes to your front office software
•   Use standard TAS and Sage CSV formats
•   Most leading “front office” business systems can already export in traditional TAS “.DAT” and/or Sage CSV format standards
•   Eliminate the cost and hassle of having to make bespoke changes to your “front office” business system
•   Rapid Integration and Setup without comprising security
•   With System Integration Manager (“SIM”)
•   Quick installations/upgrades, TAS Company integration and User setups save time
•   Central User administration across Modules and Companies enhances security control