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.
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
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.
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
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
#1
André Arnaud de Cal...
292,961
Super User 2025 Season 1
#2
Martin Dráb
231,801
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
