Client trial balance

Client trial balance

This prints a report showing outstanding balances on particular Client or all Clients. This assists you in checking which Client trips are out of balance. The Client Trial Balance should be run in Summary once a week and the Grand total should agree to the General Ledger Client Control account for the same date. If this does not agree then reconciliation between the two accounts needs to be done to find the discrepancy. One reason may be due to a mis-posting from a list/update. At the end of the month a Detailed Client Trial Balance should be run so you have a record of the Client transactions at that time.

Click on Accounting | Client Ledger | Client Trial Balance.

• Select the Report date.
• Select the Report on Client Balances option by clicking the relevant button green.
• Select Summary to get initial totals, Detailed if needing to see individual transactions associated with each trip. The Reconciliation option is run for a particular period in time to reconcile to the General Ledger Client Control account for the same period in time.
• The TICK on All Transaction Dates and All Departure Dates will print everything unless Reconciliation has been selected in which case it will only print transactions up to the month end of the Report Date.

To print the ledger for a certain date range, the TICK will need to be removed and the dates selected.

• Select the Sort Criteria. You can select up to 4 levels of Sort Criteria. For Example: click on Client and the range of All.
• The New Page Button is used to start a new page for each change of code on the first Sort Codes option.
• The option to Print Note Remarks is only displayed when the detailed version of the report is selected.
• Click on Start to print the report.
• Print Preview allows you to print the report to the screen.
• The Clear option is to clear the selections in order to enter a new selection.

OPTION TO SORT BY CONSULTANT.

• Click on Consultant for 1st sort order. Select the sequence required, Client Code or Description You could print individual consultant outstanding balances by clicking on Consultant and Range. Put the first consultant name in Start Code and the same name in Finishing Code. Selecting new page will also print out individual consultant balances on separate pages.

Selecting new page will also print out individual consultant balances on separate pages.