In this tip you will learn what you need to know about aged trial balance, aged trial balance with options, aged historical trial balance, reconcile to GL for AP, and printing a month-end check register.

Accounts Payable Month End Process Checklist

  1. Aged Trial Balance

Purchasing Reports>>Aged Trial Balances

(This is the report your auditors will want where nothing is excluded)

Normally only used for auditors.

  1. Aged Trial Balance with Options

Purchasing>>Reports>>Aged Trial Balance with Options

  1. Aged Historical Trial Balance with Options

Purchasing>>Reports>>Aged Historical Trial Balance with Options

  1. Reconcile to GL

Financials>>Routines>>Reconcile to GL

  1. Check Register Print out of all Checks for month

Purchasing>>Reports>>Check Information>>Checks by Vendor by Mon

1.    Aged Trial Balance

Purchasing>>Reports>.Aged Trial Balance

Cheat Sheet AP 1

Cheat Sheet AP 2

When you print this report you have no options, it is going to go by the GL date and will include all vendors that you have in your system whether they are a zero balance or have had any activity or not.

This is normally only used for your auditor for year-end.

2.   Aged Trial Balance with Options

Go to Purchasing>>Reports>>Aged Trial Balance with Options

Month End Dynamics GP - Cheat Sheet AP 3

Then go to New

Cheat Sheet AP 4

Put in a name for the option

You want to Print/Age as of the end of the month (for reconciling to your GL balance for A/P)

Exclude:

  • Zero Balance
  • No Activity
  • Unposted Applied credit Documents (these are not posted, won’t be part of your GL)
  • Multicurrency Info

If you leave the range blank will bring up all vendors and can be printed.

3.     Historical Aged Historical Trial Balance

Purchasing>>Reports>>Historical Aged Trial Balance

This report can be printed at any time and give you exactly were A/P stood at the end of the month before checks or credits were being applied and issued in the system.

You do not have to remember on the first of the month to run in and print the Aged Trial Balance with Options to reconcile.  If you forget and it is the 3rd or 4th of the month you can print this report and it will show you exactly where you stood at the end of the month.

Month End Dynamics GP - Cheat Sheet AP 5

This report can be printed in summary or detail by changed the checkbox in red above.

You can print this report for one vendor or all.  By using the range and inserting into the restrictions.

This is like the Aged Trial Balance with Options for excluding detail.

4.     Reconcile to GL for A/P

Financial:  Routines>>Reconcile to GL

Cheat Sheet AP 6

  • Next Reconciliation Number comes up automatically
  • Put in the date to reconcile (end of the month)
  • Put in a Date Range for the reconciliation (Beg of month to end of month)
  • Make sure to mark Module: Payables Management
  • In accounts enter in your A/P account
  • Enter in the Output file (this will save the excel file that is produced for you)

Process Report:

Cheat Sheet AP 7

Report will show all the GL detail on the right and the payables transaction on the left as well as the beginning balances in the GL and A/P

This is doing all the matching for you and will show you potential areas where your A/P to GL account is off.

5.    Printing a Month End Check Register

Reports>>Purchasing>>Check Information>>Vendor Check Register

Month End Dynamics GP-Cheat Sheet AP 8

Name the Option

Use the Dropdown Range to enter your date range.

You can exclude or include voids.

Print Register:

Cheat Sheet AP 9

Will show every check Vendor ID, Vendor Name date, and the amount.

If you are interested in Dynamics GP training or support contact 860-485-0910 x4 or sales@calszone.com

Get more Dynamics GP Tips and Tricks www.calszone.com/tips

By Susan M. Conrod, Senior Implementation Consultant, CAL Business Solutions, www.calszone.com

Compare Acumatica versus Dynamics GP