Contact Us


Contact Us


Contact Us


ERP Software Blog | SAP Blogs | MS Dynamics 365 Blogs

Reconciling Accounts Receivable and Accounts Payable GL Accounts to an Aging schedule for a prior period

By D1 Technologies, LLC

SAP Business One allows users to easily provide a schedule from Aging Reports that supports the GL account balance(s) on the Balance Sheet for prior posting periods.

Example – run the Balance Sheet for a prior month end date, example 5/31/2012.

In Financials > Finiancial Reports > Financial > Balance Sheet.


Note:  click on the Expanded button and tick “Clear Sel” to ensure all entries are included.  The system saves your Expanded Selections that may have been selected during the last run of the report.

Click OK to run the report.  In the Level 4 drop down box, select level 4 (or in 9.2 select the most detailed level of the chart of accounts, which could be 10).  Then scroll down to the Accounts Receivable account(s).


To generate the supporting schedule, navigate to Business Partners > Business Partner Reports > Aging > Customer Receivables Aging.  Select all customers by leaving the BP Code From/To fields blank.  Enter the same period end date as on the Balance Sheet.  Click on the ellipsis button beside “Control Accounts” to select the appropriate Account to check – this is only necessary if your company uses multiple control accounts.

MOST important tick is “Display Customers with Zero Balance”.   This is important because  if this box is not ticked B1 deducts any payment made after the aging date that  a customer makes from the BP’s balance, therefore the Aging would not match the Balance Sheet.


Run the aging, select “Collapse All” button to display one row per business partner.  Compare the Balance Due total to the Balance Sheet.


The aging report provides a supporting schedule for the Balance Sheet.


Repeat the process for any other AR control accounts.

Use the same process for the Vendors Liability Aging report.

For more information, contact Mark Burt at D1 Technologies, Cayce, SC at (803) 740-5008.

Topics: SAP Business One

Recent Posts

How Alternative Items Can Save The Day in SAP Business One!

Oct 8, 2019 11:24:59 AM

How to Check Addresses on the Map in SAP Business One!

Sep 30, 2019 3:42:54 PM

How to Set Gross Profit Rate for Service Docs in SAP Business One!

Sep 24, 2019 2:17:19 PM

Don't Receive Same Batch Twice in SAP Business One!

Sep 9, 2019 12:04:20 PM

Don't Navigate. Look Up Menus in SAP Business One!

Aug 26, 2019 10:09:48 AM

Posts by Topic

see all