Enter all bank related entries in the same batch and the necessary entries for Sage 300 ERP General Ledger, Accounts Receivable, Accounts Payable and Project and Job Costing will automatically be generated. Cashbook provides one audit trail on all cash movement for easier analysis. The Cashbook posting process will generate the following batches in Sage 300 ERP from the Cashbook batch entered:

Allocate Payments and Receipts directly against invoices entered in Sage 300 ERP Accounts Receivable and Accounts Payable. The outstanding documents can be sorted by different sequences. When posting these transactions Cashbook will create the necessary Accounts Receivable Receipt and Refund and Accounts Payable Payment batches.

Print your cheques for vendors and customer refunds/receipts and deposit slips on-line or by batch. On-line cheques and advices as well as receipts and deposit slips are produced using the batch entry window. After each entry is saved you have the option to print the information immediately. Multiple cheques/advices, receipts and deposit slips can be printed in one operation by using the Cashbook Print Forms function. Cashbook’s automatic numbering facility allows you to have up to 20 different numbering sequences for your cheques and receipts.

Archive batches of transactions that re-occur on a regular basis then recall the batches by retrieving. On retrieval you have the option to assign a new transaction date, fiscal period and bank code to the transactions.

Tax Tracking You are able to enter tax amounts for receipts and payments that are made directly into the Cashbook. When entering transactions the Cashbook will keep track of the tax amount and percentage for that reference. During the posting of a batch the tax transactions are posted to a separate file. You are able to create unlimited tax groups in Cashbook. Each tax group can have up to twenty codes to classify taxes for reporting purposes. Cashbook will calculate tax based on the tax percentage you enter for the tax codes. When entering transactions into a batch, each entry can have a different tax group. Each line detail for the entry can have a different tax code. The amount calculated by Cashbook can either be inclusive, exclusive or just a tax amount. A detailed tax tracking report for audit purposes is available in Cashbook.

Cashbook allows for the import of data from external systems as well as the export of Cashbook data to other systems. The batch import facility does not only allow for the import of transaction header and detail information, but also the allocations against outstanding documents in Accounts Receivable and Accounts Payable. Entries in the Cashbook transaction files can be exported via the Bank Reconciliation Export facility.

The Cashbook Bank Transfer feature allows for the transfer of funds between different banks. When posting a bank transfer batch, a batch will automatically be created in the receiving bank. Full currency information can also be entered if multicurrency is activated. If the transferring bank is in yen and the receiving bank in dollars, you are able to enter the exchange rate between these two currencies.

When creating a batch you are able to create deposit slips from all entries entered into one batch. This feature is used if you wish to reconcile only one amount with one reference number when entering multiple receipts into Cashbook. When posting a deposit batch the bank reconciliation is updated with one reference number and one amount (total of the batch) whilst the individual receipt details are retained for reversal and reference purposes.