Link Credit card bank reconciliation in Business central

(0) Share

Report

Posted on by amy

Hello Experts,

One of my customer wanted to link their Credit card with Bank Reconciliation. Can anyone please help me to link Credit card bank reconciliation item to job so that expanse can be tracked by job.

Any help will be highly appreciated.

Thanks much.

Amy.

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

Amy,

I have created a Bank Account that is linked to the Credit Card Account to pull in the Statement. I use the YODLEE Bank Statement Service. It pulls the Statement into the Bank Reconciliation and then you can Transfer to General Journal all the Bank Statement entries not posted in the Bank Ledger. Do you know if the Credit Card Bank appears on YODLEE?

You can see a list from after entering the YODLEE - Link Bank Statement Service. If the Bank is listed and you can download the statement you can create the General Journals.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (1)

Report

Yodlee only works with US version now. The credit card as a bank account with statement import is not too tricky. It’s the second part which is harder to do. Job expenses need recoding as purchases which can then use the payment method of the credit card. On a payment method you can setup a balancing account. This means the entries get applied/posted. You will then have data in the bank account to match with the statement. The difficulty is the order of play and knowing what expenses from the statement are for a specific job. If you can get the user to file the expense claim as a purchase you might have a satisfactory process

Was this reply helpful? Yes No
amy on at

Like (0)

Report

Thanks Steve. i will definitely try your suggestions and let you know if it works.

Was this reply helpful? Yes No
amy on at

Like (0)

Report

Thanks Josh for your suggestion. I didn't understand the second part. Could you explain with few screens shot so i can try the same at my end. I understand its tricky one.

Thanks

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

Mostly answer via phone so screenshots will be lacking. “Purchase” from my original answer would need to be a PO or a PI. Logging this will post the expense costs to the job. If the PO or PI uses a special payment method of credit card that relates to the bank account then you have the makings of related data.

There are expense solutions available that tackle this and they have links to jobs and credit cards. Continia being one of them. Process flow in that solution is import the credit card statement and then send the data to the user to add the receipts and related job information.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Amy,

One note to add, as Josh noted YODLEE is a US version, AMC Banking also links to Banks to download statements but there you will need to check if your Bank is on there list.

Thanks,

Steve

Was this reply helpful? Yes No