Checking Customer Balances
There are ways to easily check customer balances.
Usually if you run a report or list view as at the end of a month or a start and end period you will be able to balance it back to the general ledger quite easily.
Easy Method : Use the cards view
Select relationships from the navigation menu
- Select cards
- On the tool bar above the cards list view select the view "customer balances".
- On the tool bar above the cards list view select the arrow below the "Export" button and click xlsx. You will have an excel spreadsheet showing all customer balances.
Run a report :
Select reports from the navigation menu
- Select "Form Reports"
- On the Form reports list there are category headings. Find the category heading "Relationships" or just search for the report in the name description
- Click on the report "F-017 Customer Trial Balance Summary"
- On the detail view to the right of the report list click on "Show Report Using Parameters"
- Enter the Date
- Leave the start and end customers blank if you wish to report on all customers or select a customer cardid
- Click on OK
- Report will appear to screen.
- The total on the report must line up to the General Ledger Trade Debtors Account as at the same date.
Opem Items List View:
- Click on Relationships>Open Items
- From the top filter select 'All customer Open Items'
- Filter and select the criteria of the date range
- Right click at the top heading and select 'Show Report Footer'
- Then sum the columns of 'Value'
General Ledger
- Log onto Financials>General Ledger>Accounts>List View
- Click on and highlight the general ledger account for trade debtors eg 12005
- In the top ribbon is a action button called 'Set Period Range'
- Set the period range to be the same period as the end date of either the report or list view
- In the detail area on the tab of Status, the Actual closing balance should equal the total on the report and/or list view of the customer open items.