cancel
Showing results for 
Search instead for 
Did you mean: 
usermichael-lamb
Level 3

What's best way to upload credit card receipts from external provider for AR/invoices? What file type will work as CSV with 9 columns did not?

 
3 Comments 3
AlexV
QuickBooks Team

What's best way to upload credit card receipts from external provider for AR/invoices? What file type will work as CSV with 9 columns did not?

Let me assist you with the credit card transactions, usermichael-lamb.

 

We only need either a 3-column or 4-column format for the CSV file. The 3 column format should include the Date, Description, and Amount column while the 4 column format must have the Credit, and Debit column instead of the Amount. For the detailed steps, please check these links: 

 

Another way is to link your credit card account so that the transactions will be downloaded automatically. Once the transactions are imported successfully, you'll see them on the Banking page where you can match and categorize them.

 

If what you meant by "credit card receipts" are attachments, we can only manually add them to the invoices. 

 

Do you need help reconciling your accounts? Check this link: Reconcile an account in QuickBooks Online.

 

Leave a comment below if you have more questions. Have a great day!

usermichael-lamb
Level 3

What's best way to upload credit card receipts from external provider for AR/invoices? What file type will work as CSV with 9 columns did not?

Hi, it's taken me a while and we did not get to do this for our 2020 accounts, but wish to do it for 2021. How the business works is we "auto charge" our customer's credit cards each month or quarter for their invoiced amount and we can extract a World Pay CSV file with that data.

 

What I was hoping to do is auto-match the payments against the invoices raised which sit in AR and the gross daily deposit would then be matched to the banking transaction (deposit). This would be a very simplified and productive way to complete this task versus individually matching off each invoice and credit card payment.

 

Is that possible in QBO?

 

Appreciate your insights and how-to on this item.

 

Thanks

Michael Lamb

GlinetteC
Moderator

What's best way to upload credit card receipts from external provider for AR/invoices? What file type will work as CSV with 9 columns did not?

Hello there, usermichael-lamb.

 

I appreciate your thoughts to simplify your banking transactions.

 

We're unable to do this since you're using a third-party payment provider, and I assume only your bank account that accepts the daily deposits is connected to QuickBooks. Therefore, it's transmitting the combined payments in a day to the Banking page.

 

What you can do, is combine all invoice payments on a given day via bank deposit. That deposit can be matched to the downloaded deposit for that particular day. Then, do the same thing every day. 

 

Here's how:

 

  1. Go to + New and select Bank Deposit.
  2. From the Account ▼ dropdown, choose the account you want to put the money into.
  3. Select the checkbox for each transaction you want to combine.
  4. Make sure the total of the selected transactions matches your deposit slip. Use your deposit slip as a reference.
  5. Select Save and close or Save and new.
     

You can refer to this article for more details: Record and make bank deposits in QuickBooks Online

 

Also, you can check these links for future guidance while doing a task in QBO:

 

If you need anything else please reply below or post new questions, and we'll be glad to answer them for you. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us