How I use the new GL Account Review functionality in Dynamics 365 Business Central

The purpose of this blog is to discuss how I use the Review Entries feature in Microsoft Dynamics 365 Business Central to reconcile my business credit card. This feature is great for reconciling balance sheet accounts because you can match debits and credits together to track what the remaining account balance is made up of. 

Process and Setup

As vendor invoices are received and entered into Business Central, I follow the workflow below. I will go through two scenarios in this blog. 

  1. Invoice is received and already paid via credit card.
  2. Invoice is received and will be paid via credit card at a later date.

Let's take a moment to review my setup in the system. In order for this to work as expected I set up a payment method named AMEX and add a balance G/L account of 20108.  


Account 20108 is my liability account for AMEX Payable. 


Make sure the Review Policy is set to 'Allow Review and match Balance' on the G/L Account Card.


Examples of entering vendor invoices

Now that setup has been completed let's continue with two scenarios.
  1. Invoice received and paid via AMEX credit card already. Enter invoice into system as a Purchase Invoice and make sure to select AMEX as the Payment Method.



    Posting Preview shows the G/L entry as follows and will close the invoice out as paid already.




  2. Invoice received and will be paid via AMEX credit card at a later date. Enter invoice into system as a Purchase Invoice and leave the Payment Method blank.


    Posting Preview shows the G/L entry as follows and will show the invoice as outstanding in the subledger.




    Let's now pay this invoice at a later date. When adding the vendor payment to the payment journal update the balance account type to G/L account and use account 20108 as the balance account number. You won't need to add a bank payment type in this example because we are recording this entry as a credit card payment at this time.


AMEX monthly statement is received and entered into Business Central

Now that the AMEX monthly statement is received, I'll show you how to reconcile against the liability account. 

  1. Open the Chart of Accounts page and search for account 20108. 
  2. Click on the balance amount to open the general ledger entries window. 
  3. Select Review Entries on the action bar. 





  4. From here I would hide reviewed entries so I can focus on entries that haven't been reviewed yet.



  5. The next step is to review the transactions on the AMEX statement against the entries showing in the Review G/L Entries window. I'm showing two transactions for Ingram for $840 each, which shows on my credit card statement. I highlight them on the statement to show that they've already been entered into the system. Once you complete the review it's time to enter the AMEX statement into the system. 
  6. I enter the statement into the system through a Purchase Invoice. The important thing is that the transactions that have already hit G/L account 20108 you would enter as a G/L Account transaction to that account. That will create the debit we need to offset the payment (credit) we entered earlier with the payment method and payment journal.

    If you have other charges on the statement that haven't been entered into the system, yet you can add those to the purchase invoice as well. Example of this is lines 3 and 4 below for office supplies and meals expense. 


    TIP: export your statement transactions to Excel and then copy/paste them into the system to streamline the process. To learn about copy/paste check this blog out: Copy/Paste A Journal Entry Into Dynamics 365 Business Central (kristenhosman.com)
  7. The vendor invoice is paid through the payment journal as normal.

Review G/L Entries

Now that the purchase invoice is completed for the monthly AMEX statement lets open the Review G/L Entries window back up. While navigating to this window you see the G/L balance is $0, which is what is expected at this time.


Now it's time to set G/L entries as reviewed. To do this select the two transactions that go together (debit and credit) and then click on Set selected as reviewed on the action bar. Continue this process for all transactions that have hit and cleared the account.

What you're left with in the account are transactions that were not on the credit card statement. You can expect those to be on the next month's statement and will then clear. For example, I just added an invoice to Ingram that was paid via credit card for $60.99. You can see the Review By and Reviewed Date is blank in this case. That invoice should show on next months statement.



Written by: Kristen Hosman, Microsoft MVP

Comments

Popular posts from this blog

Applying posted credit memos to posted invoices in Microsoft Dynamics 365 Business Central

Dimension Corrections in Microsoft Dynamics 365 Business Central

Add field to page: all fields (Preview) Dynamics 365 Business Central v23