How to Reconcile Payments from a Bank Statement to Microsoft Dynamics GP

By Brett Albrecht | October 19, 2018

How to reconcile payments from a bank statement to microsoft dynamics gp

The question of “What is the correct way to reconcile items from my bank statement?” is common. In Dynamics GP, there are multiple ways to add lines to the bank reconciliation, and they are all correct from an accounting standpoint. The questions that you must ask are:

  • What am I trying to accomplish?
  • How much time do I want to spend on this?
  • What level of traceability do I want to have?”

1. The easiest way to reconcile is to simply use the bank transactions increase/decrease adjustment (Financial -> Transactions -> Bank Transactions).

Reconcile payments

  • Pros: Fast and easy
  • Cons: Cannot search who/what will not show up at year-end for tax reporting, not directly associated with any customer/vendor, not reported on the subledger

2. Creating Manual Payments/Receipts takes a little bit longer, but is probably the most effective (Purchasing -> Transactions -> Manual Payments or Sales -> Transactions -> Cash Receipts).

Reconcile Payments

Reconcile Payments

  • Pros: Transactions are linked to a vendor/customer and can be applied directly to open items or enter Distribution accounts is no open items exist, can increase search capabilities, is attached to vendor/customer accounts
  • Cons: Takes more time than a simple adjustment

3. Enter in customer/vendor invoices to recreate the invoicing/payment or invoicing/cash receipt process (Purchasing -> Transactions or Sales -> Transactions)

Reconcile Payments

  • Pros: Meets all internal controls/company practices, creates traceability for searching and year-end reporting
  • Cons: Time consuming and possibly “extra/unnecessary” work

All three methods will show you how to reconcile payments from a bank statement to Microsoft Dynamics GP.  However, in order to be able to track and run reports, reconciling at levels 2 or 3 is necessary.

Related Posts

Recommended Reading:

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article
5.5.22 Dynamics GP

The Real Story about the Long-Term Future of Dynamics GP Support

I’ve seen a number of people put forward comment that Dynamics GP is going away and you have to get […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Financial Enhancements

The Dynamics 365 Businses Central 2022 Wave 1 Release has a lot of new and exciting features to help your […]

Read the Article
4.29.22 Dynamics GP

Dynamics GP Transaction Removals: Bank Reconciliation

  This is part 2 of a 3 part series on Dynamics GP Transaction Removals. These quick tips will hopefully […]

Read the Article
4.28.22 Dynamics GP

Uncommonly Used Features – Integrate Purchasing and Payables to Fixed Assets in Dynamics GP

Being able to integrate Purchasing and Payables to Fixed Assets in Dynamics GP will help you create visibility for your […]

Read the Article

New Features in the Dynamics 365 Business Central 2022 Wave 1 Release – Ease-of-Use Features

  There are many new features in the Dynamics 365 Business Central 2022 Wave 1 Release to get excited about! […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X