Reconciling Customer Accounts

Check the ‘Balance’

Use the navigation panel to go to Customer/Customer. 

Check the customer balance in the ‘balance’ column as shown in the screenshot below.

(Click on the screenshot to enlarge).

Create a filter

Go to General Ledger/Reports/Transactions. 

Right click in any column heading and select ‘Advanced filter’ and enter the filter as shown in the screenshot below.

(Click on the screenshot to enlarge).

Within the advanced filter, the ‘Reference’ should be ‘Customer’.

The ‘Text’ should ‘contain’ the ‘Balance’.

The ‘Date’ should be the first day in the accounting year.

The ‘Account’ should be the main Customer account. This can be found under Customers/Maintenance/Customer groups.

Check the ‘Amount’

Check the balance in the ‘Amount’ column of the ‘Transactions’ tab.

If the ‘Amount’ column is not visible it can be added to the Layout by right clicking on any column heading and clicking ‘Select fields’.

These filters can be saved as Layouts.

Reconcile the two amounts

The two amounts found should be the same.

Other entries on the account could be manual.

Another example of the above process is shown on a Danish account below, where the two amounts found are reconciled at the bottom of each screen as 77,412.21.

(More English screenshots coming soon).

(Click on the screenshot to enlarge).