User Tools

Site Tools


faq:accounts_receivable_starting_balance_accounts_payable_start_balances

Accounts Receivable and Accounts Payable Starting Balances, How to clean them up

Some information about the data load method

It is possible to data load your customer and supplier starting balances into System Five. Data loading allows you to import the 30, 60, and 90+ day totals for each customer, but it does not set up your customer balances on their accounts. What it does it loads it to the grid in the setup wizard. Then you can modify the grid and make sure the numbers are correct. There are tools in the starting balances that then allow you to create the actual customer balances. This tool actually creates starting invoices. These are invoices that represent the aged balances the customer owes, and do not contain historical details like what the customers purchased.

The Manual Clean-Up

To clean up any incorrect numbers manually you simply change the numbers to $0. You are not able to remove a record, so if the list is prohibitively large or unwieldy you may consider getting a support technician to help you perform the cleanup.

Information: If you have already created starting invoices or bills the only way to clear out those balances is to delete or void those invoices. There are other ways to adjust balances, the easiest being to reload from the backup that you made before creating starting invoices or bills.

Technician Instructions: Backup and clear out the AcctBal database

WARNING: Do not try this on other files, it can really mess things up irreparably. For regular users, do not attempt this unless you do a full backup with everyone out of System Five.

The easiest way to backup and clear out the AcctBal.btr file is to rename it to _AcctBal.btr. When you log out and log back in, System Five will re-create the file with a blank version.

Information: If you have already created starting invoices or bills the only way to clear out those balances is to delete or void those invoices. There are other ways to adjust balances, the easiest being to reload from the backup that you made before creating starting invoices or bills.

faq/accounts_receivable_starting_balance_accounts_payable_start_balances.txt · Last modified: 2011/12/08 10:53 (12 years ago) by cliff