Question

File Upload Accounts Receivable

Forum|Forum|4 years ago
July 27, 2022
7 replies
60 views

I wanted to reach out to see if anyone knows of a way to take a remittance excel or csv file and upload it to QuickBooks to apply to a customer account and open invoices. We currently manually match each line item in excel to an invoice. We receive payments on one check or ACH for multiple stores. The file would need to match the store number and invoice number to what is in QuickBooks. The stores don't always pay the exact amount, so we would need the ability to review exceptions before making the deposit to the bank account. We work on the cloud.

QuickBooks Online

L

LeizylM

QuickBooks Team

I appreciate you for reaching out to us here on the Community page, AmberT13.

I know a way how you can upload CSV files in QuickBooks to apply to a customer account and open invoices.

Uploading a CSV file is an easy-peasy step in QuickBooks. Let me guide you on how:

From the Transactions tab, select Banking.
In the Link account drop-down, select Upload from the file.
Click the Drag and drop or select files button.
Select the CSV file and then Open.
In the QuickBooks account dropdown, select the account you want to upload the transactions into.
Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks.
Select the transactions
Select Yes.
Click Let's go.

Then, we can now match the payment to the existing invoice. If there are fees deducted from the payment or any differences, we can select the option Resolve difference.

Go to Banking, then For Review tab.
Select the transaction.
Click the option Find a match.
Put a checkmark for the check you recorded in QuickBooks.
Scroll down, then toggle the option Resolve difference.
Enter the Date, Payee, Category, and the Amount.
Once done, hit Save.

When everything is all set, you'll want to check out these articles for guidance. These can walk you through the steps on how to reconcile your account flawlessly: Reconcile an account in QuickBooks Online.

Keep me posted if you have other questions about uploading your CSV files or if you ran into a different situation by adding a reply below so I can look further into this. Have a great day!

A

AmberT13Author

I appreciate your response! Do I have to have the transaction pro to be able to do this? I logged in, and we have Premier Manufacturing and Wholesale edition 2021 of QB. I don't see a Transactions tab on the left hand side. At the top, I have Banking as an option, but it does not have the drop down option where I would select upload from the file. Thoughts?

C

Carneil_C

Level 6

I appreciate your response and providing an update, @AmberT13. I'm here to ensure that you'll be able to upload your transactions.

Beforehand, the steps given by my colleague above are for QuickBooks Online. If you're using QuickBooks Desktop, importing bank transactions to QBDT using the CSV file is unavailable. Otherwise, you'll want to import your bank transactions using the .QBO format.

Then, you're now ready to upload your files. Here's how:

Go to the File menu, select Utilities, and select Import.
Click Web Connect Files then choose the .QBO file you saved.
Select Open, and choose your bank account.
Click Continue.
From there, you can see a dialogue box telling you that the data has been successfully read into QuickBooks and select OK.
Go to the Bank Feeds Center to review your transactions.

I've added a screenshot here for your visual reference:

For more details on managing your transactions, please refer to these articles:

Once everything is all set, feel free to review this handy resource for your guide in reconciling your accounts seamlessly: Reconcile an account in QuickBooks Desktop.

Stay in touch if you have any other questions or follow-up banking inquiries in QuickBooks Desktop. I’ll be right here to answer them for you. Have a good one.

Fiat Lux - ASIA

Level 14

@AmberT13

Prepare your Receive Payment data with the following template

RefNumber	TxnDate	PaymentRefNumber	Customer	PaymentMethod	DepositToAccount	InvoiceApplyTo	LineAmount	PrivateNote	Currency	ExchangeRate
1	28/11/2020	50245	Janice Johnson	Check	Checking	101	100.00
2	28/11/2020	4908	Leonard Walker Inc	Check	Checking	102	138.78
3	28/11/2020	4908	Lisa Smith	Check	Checking	103	126.50

then utilize an importer tool

https://transactionpro.grsm.io/qbo

Sign up

Login with SSO

Let's get you signed in

Login with SSO