I've been trying for two days to get bank statements and corporate credit card statements/transactions imported. There seems to be several ways to do it. While having a bank feed would be ideal, we are waiting on an update from our bank to help us get connected. But in the meantime I wanted to train our accounting team to log into our online banking, download an QBX or OFX (or whatever) and import the transactions. Same for our credit card provider (log in, download transactions, import). This includes employees who use corporate cards for travel so they can import their transactions and add them to expense reports.
For banking, I think I've got it covered (Transactions → Bank → Banking Import History → Upload File) and then Match Bank Data.
Corporate credit cards haven't been as easy. I see where to select the account and match the bank data, but importing the transactions, whether its a CSV, QBX or OFX, doesn't seem as straight forward. I thought about creating a CSV Import map for corporate card users to upload their transactions, but when I test this, my transactions do not show up when I try to create an expense report from the imported transactions.
It just occurred to me that Match Bank Data also reconciles corp credit cards if the right account is selected. But getting the transactions in an expense report (without manually entering each transaction) has given me headaches. I do an import (Import Type is Transactions and Record Type is Credit Card Charge) and it is successful, but the credit card charges don't appear in imported transactions when creating an expense report.
Am I missing something blatantly obvious here? Thank you so much, community! :)