United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
nealeb
Level 1
posted
‎March 24, 2023 06:46 PM
last updated ‎March 24, 2023 12:46 AM

Import receive payments

clinet uses a third party for collects income and then remits - i have file of the trx s( in excel)  that make up various payments , rather than reenter 6 months worth wondered if way to import
Reply
1 Comment 1
jenop2
QuickBooks Team
QuickBooks Team
‎March 24, 2023 09:55 PM

Import receive payments

We're glad to have you here in the Community, nealeb.

 

You can convert the Excel file into a CSV format. Then, import it into QBO. I'd be glad to share all the steps with you.

 

Firs, follow the steps in these Microsoft articles on how to convert the Excel file to CSV:

 

 

Second, follow the format in this article so you can import it: Format CSV Files in Excel to Get Bank Transactions Into QuickBooks.


Third, use these steps to move the transactions to your account:

 

  1. Go to the Bookkeeping menu, then proceed to the Bank transactions tab.
  2. Click Upload transactions.
  3. Select Drag and drop or select files. Then, look for the CSV file.
  4. Click Continue and select the account you want to upload the transactions into. 
  5. Choose Continue again to proceed. 
  6. Follow the succeeding steps on how to map the data to complete the import process. 

 

 

 

 

Let me also give you this article that provides more information about this process: Manually Upload Transactions into QuickBooks Online.


After that, you can now categorise the transactions or match them to the invoices in QBO. Let me share these articles for additional guidance:

 


Don't hesitate to always reach out to us again if you need anything else. The entire QuickBooks Team is more than happy to help you again.

Reply