Automatically creating a bill using the credit card transaction feed

Hi ​@kstrobel, I have not seen anyone before do this, so not sure if it is possible. I am sure a 3rd party AP Processor, like a Traild, might be able to handle this though.

-RJ

​@kstrobel 

Currently, functionality does not exist to automatically create AP bills from credit card transactions.

You will need to look into customization to accommodate this.

Hope this helps.

Ed

Ed's right, there's no button that turns a card transaction into a Bill. There's still a native path that doesn't need customization, but two things decide which one you want.

First, you said file. A downloaded statement file and a live bank feed are different things in Acumatica, and only one of them creates expense receipts. The Plaid or MX connection you set up in Bank Feeds (CA205500) is what pulls transactions in and creates receipts automatically. A file off the card portal goes in through Import Bank Transactions (CA306500), which reads OFX/QFX/QBO out of the box. That gets the lines in for matching on Process Bank Transactions (CA306000), but it won't create receipts for you.

Second, who owes the card issuer.

If the company is liable, you don't want a Bill, you want a cash purchase. Set the card up in Corporate Cards (CA202500) over a liability cash account. Receipts come in as Paid With = Corporate Card, Company Expense, you claim them on EP301000 and release. Each posts as a cash purchase in AP304000, debiting the expense account and crediting the card liability. CA306000 also gives you a Match to Expense Receipts tab for corporate card accounts, so the statement still reconciles against them.

If the employee is liable and the company reimburses them, you get a real Bill. Don't assign that employee an active corporate card. Their receipts default to Paid With = Personal Account, and releasing the claim generates an AP bill to reimburse them. That's the only Paid With value that produces a Bill. Watch the screen names here: EP501000 Release Expense Claims creates it, EP502000 Bill Expense Claims is customer billing.

And if your client just wants one bill per statement from the card issuer, skip all of it. Import scenario into AP301000, vendor is the issuer, one line per charge. Key it on something the whole statement shares so the rows collect onto one bill, and set <Line Number> to =New so each row adds a line instead of replacing the last one. If they're working from a file rather than a feed, this is probably the shortest path anyway.