Aged Trial Balance
The Aged Trial Balance function can be accessed from:
Customer Center- Reports
Dates. Under Aging, enter or select from the drop-down box the date that you want to use for the aging of the invoices. Under Closing, enter or select from the drop-down box the date that you want to use as the statement date. The Closing Date is usually the same as the Aging Date.
Sort By. Select what you want the system to sort your information by, Number or Name.
Customer. Enter the lowest customer number to be included in the finance charge calculation in the From box. Enter the highest calculated number to be included in the finance charge calculation in the Thru box.
Select Invoice Types. Select whether you want to search for “Open Invoices” or “History Invoices” and any date specifications you wish to search for. You can select a Range of invoices to search for using the Range drop-down box or by entering the earliest date you want to search through in the From box and the latest date you want to search through in the To box. You can use the drop-down box for the From and To boxes as well.
Check the corresponding boxes of the selections you want to include.
Age Customers. Update customer information in terms of current, 30, 60 and 90+ days.
Exclude Fiance Charges. Do not display finance charges.
Include Salesman #. Displays salesman number. Select if you wish to track salesman.
Exclude Paid Invoices. Only show open invoices, do not display paid invoices.
Summarize Invoices. Do not show detailed list of invoices. Only display a summary of invoices.
Include Job #. Display the job number.
Include Last Purchase Date. Display the date of the most recent purchase.
Include Last Payment Date. Display the date of the most recent payment.
Minimum Invoice Balance. Enter a dollar amount. The system will not display invoices worth less than your specified minimum.
Minimum Account Balance. Enter a dollar amount. The system will not display accounts with a lower account balance than your specified minimum.
Select Refresh at the footer of the page to Age Trial Balance based on your specifications. You can print your list if you wish to do so by selecting the Print button at the footer of the page.