Dynamics Community Forum Thread Details

Credit Card Expense Processing

Hi,

I'm using Business Central Version: GB Business Central 16.1, if this helps?

I have 13 individuals credit card statements to process each month (thats 100's of transactions), when using Sage I uploaded via csv file, and could handle all transactions, match to Vendor invoice or post directly to the relevant overhead nominal ledger account (which also allowed for VAT element to be registered).

I am fearful I am going to have to spend hours processing each line as "Vendor Invoice" before I can upload the statement, this in itself will take hours, moving to BC was in the hope of reducing manual input.

Hopefully you have a wonderful answer to help me out?

Thanks

Linda

Hi Linda

Potentially a couple of things to address from what's been described.

1 Effective way to log these statements as invoices.

2. Effective way to match payments against the invoices.

For importing in a journal you do have "Edit in Excel" which could loosely work with csv. The one I typically go for here is using the "Payroll Import" button. Doesn't seem too logical but in essence that button uses a "Data Exchange Definition". Which can be most csv file formats, and it's configurable by a user. All you have to do is tweak the "General Ledger Setup" to know what payroll import it should use i.e. your "Data Exchange Definition". The field in question is probably hidden so use the personalise feature to reveal it.

The above will help you import a csv to create the invoices. Worth noting you could bypass the invoices with this method and do the payments instead. No auto match though to invoices.

Once you have the invoices you need to post and assign the payments. Can be done using the payment reconciliation journal, where you can import a statement as CSV. Note that this only works with bank account records, so each credit card could be a bank. You then have a matching logic that can run to settle invoices or post to a specific nominal. Details on this process:

docs.microsoft.com/.../receivables-how-reconcile-payments-auto-application

There are add-ons that handle company card scenarios too. Continia expense mgt. being one.

Quick Links