top of page
Micro Force

Enhancing Financial Management with Dynamics GP: A Guide to Importing Credit Card Transactions

Updated: Feb 21

In the world of business, managing financial transactions with precision and efficiency is crucial. Microsoft Dynamics GP offers a powerful feature that significantly simplifies this task for your credit card purchases. The ability to  import credit card transactions directly into GP to create AP vouchers for each vendor purchase. This functionality will permit you visibility on what you are spending with your credit card vendors. This is not possible if you only enter the AP voucher for Amex or whomever your create card vendor is. We have learned that certain industries require this visibility for their compliance reporting. create Let's dive into how this feature can be setup in your Dynamics GP business software system.


Streamlined Transaction Import:

Imagine the ease of converting your electronic credit card statements directly into payable invoices or manual payments within Dynamics GP. This process consolidates transactions into a batch, streamlining invoice management and ensuring accuracy.


Importing a credit card statement to a vendor account in Dynamics GP makes it fast and easy to enter invoice transactions. Users can import the credit card transactions as payable invoices or manual payments. Using the import functionality helps reduce the chances of data entry errors and brings invoices for a vendor into a batch.


The imported transactions must be saved as a batch and appropriate distributions must be created for each transaction.


Once the transactions import process is completed, a report will print with a list of transactions and status of the transactions.


An example of how this will work is a company gets their credit statement electronically or they can download the transactions to a qbo/qfo/qfx file locally. This allows the user to bring that data into Microsoft Dynamics GP and generate invoices for the credit card that is setup as a vendor within the Dynamics GP system.


Vendor Mapping and Transaction Type mapping setup needs to be completed before the functionality will work.


Table Changes:


There are two new tables:

  • PMVendorMapCreditCardSetup - PM40107 with two fields OriginText and VENDORID

  • PMCreditCardAccountSetup - PM40108 – 3 fields CreditCardTrxType, ACTINDX, ACTNUMBR


In the Payable Management Setup page, under the Purchasing Home page, choose Setup, click Payables. Two buttons have been added: Vendor Map and Trx Type Map.



The Vendor Mapping window is used to map the Credit Card (Org) field in the file format .qbo, .qfo, .qfx, to the corresponding Vendor ID you have setup in Microsoft Dynamics GP.

This mapping will determine which Vendor ID is used when the invoices are created from the

import. Without this information populated in Microsoft Dynamics GP the system will not know what Vendor ID should be used to create the invoices for the credit card statement being imported. This setup is required.


To find the Credit Card Org, open the qbo/qfo/qfx file using a text file program and search for<ORG>AMEX</ORG>. This will be the Credit Card (Org) field. Map that name to the Vendor ID being used for the Credit Card in Dynamics GP.


In the example below you will see AMEX as the Credit Card Org, as an American Express Credit Card QBO file. It has been mapped to Vendor ID AMEX0001 which is the

vendor that has been created to track invoices and payments for the American Express Credit Card the Fabrikam, Inc. company uses. The 'Credit Card (Org) field is freeform and is 10 characters in length.



Transaction Type Account Mapping will give the user the ability to map the transaction type from the qbo file to the Account Number in Dynamics GP. This information isn’t required but will allow a different purchases account to be posted other than the default “purchases account” on the vendor card.


  • To pull the account number from this window, the transaction type string will need to match. If there are multiple “matches” the GP will not pull the account number into the invoice.

  • The “transaction type” field in the window will be a freeform field. This field will have a max length of 50.

  • The Account field will be a lookup field that will give the user the ability to look up the Account Numbers and select an existing Account to be used when the invoices are created during the import.




Additional Notes:

The name of transaction type can be mapped to an Account. That account will then be used

for the Purchases Account type on the Invoice transaction distributions. The Transaction Type

will be compared to the <NAME>DELTA AIR LINES</NAME> within the import file. The entire name in the .qbo file needs to be entered into the Transaction Type field to match and use the account setup. If this is not setup with any account mappings or there are no matchesbetween the import file and the transaction type account mapping the Purchases account on the vendor card is used by default.


Importing Credit Card Transactions:

To import the credit card transactions from the Payables Home page click Transactions choose Payables and Import Payables Invoices. Use the yellow folder icon to map to your saved import file.




The process button will give the user the ability to import from the file location. If the user wants to modify the information on the transactions, they will need to do that after the import when the transactions are in the batch.


Once the import is completed you will get a message below:



(Note: Transactions will be entered into the system using the functional currency.)


Once the import process has run, a batch is created and needs to be posted by the user. Creating the batch and not posting gives the user the ability to verify the batch before it posts.


This would also allow the user to change the distributions if needed before they post the batch. If you click Transactions and then choose Purchasing, click Batches. You should see your imported batch.





Conclusion:


The ability to import credit card transactions into Dynamics GP not only saves time but also enhances the accuracy and efficiency of financial operations. By following the steps outlined above, businesses can streamline their invoice processing and enjoy better financial management. Remember, a little setup goes a long way in achieving seamless integration and financial clarity.


If you are interested in implementing these credit card transactions in your GP software and would like some help setting everything up, we're always only a phone call or email away. Make sure to contact us and we can schedule a time to go over everything!

8 views0 comments

Comments


bottom of page