Importing Credit Card Transactions in Dynamics GP

Posted on: May 4, 2021 | By: Guy Logan | Microsoft Dynamics GP

Although Microsoft continues to invest in both Dynamics GP and Dynamics 365 Business Central, the leaning of these investments toward Business Central has prompted a number of questions from companies with Dynamics GP. We frequently receive questions about the future of GP; particularly, many clients ask whether there are there any new features coming with the most recent versions of Dynamics GP.

The short answer: Yes. In this blog post, we will walk through a new and noteworthy GP feature that premiered in October 2020: importing credit card transactions.

Previously, GP users had to manually key in statements and transactions. In addition to being time-consuming and burdensome, manual input increases the chance of data entry errors, which can further reduce business efficiency. Fortunately, GP users can now import a credit card statement to a vendor account as payable invoices or manual payments in Dynamics GP. For instance, a company can download their credit card statement electronically and import this information directly into their Dynamics GP. Then, the GP system generates invoices for the credit card, which is set up as a vendor in the GP system.

It is important to note that this functionality is geared toward debit-type transactions; credit-type transactions still require manual entry. In order for this process to run smoothly, imported transactions need to be saved as a batch, and users must create appropriate distributions for each transaction. Additionally, users will need to complete Vendor Mapping and Transaction Type mapping prior to using the import functionality.

Next Steps

Logan Consulting has helped many clients with Dynamics GP. If you are interested in a walk-through for importing credit card transactions, please do not hesitate to let us know — contact our team of experts to see how we can help optimize your business!