Checking Supplier Balances

There are ways to easily check supplier 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 "supplier balances" as at the current date.
  • 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 supplier 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-019 Supplier 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 suppliers blank if you wish to report on all suppliers or select a supplier cardid
  • Click on OK
  • Report will appear to screen.
  • The total on the report must line up to the General Ledger Trade creditors account as at the same date.

Opem Items List View:

  • Click on Relationships>Open Items
  • From the top filter select 'All supplier 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 column of 'Value'

General Ledger

  • Log onto Financials>General Ledger>Accounts>List View
  • Click on and highlight the general ledger account for trade creditors eg 31005
  • 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 supplier trial balance summary report and/or list view of the supplier open items.