In this tip y'all will acquire what y'all need to know most aged trial residuum, aged trial remainder with options, aged historical trial balance, reconcile to GL for AP, and printing a month-end bank check register.

Accounts Payable Month End Procedure Checklist

  1. Aged Trial Remainder

Purchasing Reports>>Aged Trial Balances

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

Ordinarily merely used for auditors.

  1. Aged Trial Rest with Options

Purchasing>>Reports>>Anile Trial Residue with Options

  1. Anile Historical Trial Balance with Options

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

  1. Reconcile to GL

Financials>>Routines>>Reconcile to GL

  1. Check Annals Impress out of all Checks for month

Purchasing>>Reports>>Check Information>>Checks by Vendor past Monday

1.    Aged Trial Residual

Purchasing>>Reports>.Aged Trial Balance

Cheat Sheet AP 1

Cheat Sheet AP 2

When you print this report you take no options, information technology is going to get by the GL date and volition include all vendors that you lot accept in your organisation whether they are a zero residuum or accept had whatsoever activity or non.

This is normally just used for your auditor for twelvemonth-stop.

2.   Anile Trial Balance with Options

Go to Purchasing>>Reports>>Anile Trial Residue with Options

Month End Dynamics GP - Cheat Sheet AP 3

So go to New

Cheat Sheet AP 4

Put in a name for the option

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

Exclude:

  • Zilch Balance
  • No Action
  • Unposted Applied credit Documents (these are not posted, won't be role of your GL)
  • Multicurrency Info

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

3.     Historical Aged Historical Trial Residual

Purchasing>>Reports>>Historical Aged Trial Residue

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

You practice non have to call up 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 calendar month you can print this report and it will evidence y'all exactly where you stood at the terminate of the month.

Month End Dynamics GP - Cheat Sheet AP 5

This study can exist printed in summary or detail by changed the checkbox in crimson to a higher place.

Y'all tin print this report for one vendor or all.  By using the range and inserting into the restrictions.

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

iv.     Reconcile to GL for A/P

Financial:  Routines>>Reconcile to GL

Cheat Sheet AP 6

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

Process Report:

Cheat Sheet AP 7

Report will show all the GL particular 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 volition prove you lot potential areas where your A/P to GL account is off.

five.    Press a Calendar month Stop Bank check Annals

Reports>>Purchasing>>Cheque Information>>Vendor Check Annals

Month End Dynamics GP-Cheat Sheet AP 8

Proper noun the Option

Use the Dropdown Range to enter your appointment range.

Yous tin exclude or include voids.

Print Register:

Cheat Sheet AP 9

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

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

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

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

Compare Acumatica versus Dynamics GP