/
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.

 

 

 

Related content

Checking Supplier Balances
Checking Supplier Balances
More like this
General Ledger Trial Balance
General Ledger Trial Balance
More like this
Customers End Of Month Procedure
Customers End Of Month Procedure
More like this
General Ledger Trial Balance By Date Range
General Ledger Trial Balance By Date Range
More like this
Report Groups
Report Groups
More like this
Reports from Readysell for External Financials
Reports from Readysell for External Financials
More like this