/
Checking Customer Balances
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.
, multiple selections available,
Related content
Financial Reports
Financial Reports
More like this
Cards
Cards
More like this
Card SalePerson (Primary Sales Person)
Card SalePerson (Primary Sales Person)
More like this
Setup of a Deposit to handle Order Payments/Eway and Lay-Bys
Setup of a Deposit to handle Order Payments/Eway and Lay-Bys
More like this
Stock Quantity Adjustments
Stock Quantity Adjustments
More like this
Xero Integrations
Xero Integrations
More like this