Buy now and save 90% off today
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: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
thomas71
Level 2
posted
‎January 01, 2026 04:37 PM
last updated ‎January 01, 2026 4:37 PM

Is is there a specific excel sheet format to upload bank transactions into QB ?

I am trying to upload wallet transactions to QB since they cant be integrated yet. Can someone help me with the correct excel format to upload these transactions?
Reply
7 Comments 7
SIAB
Level 7
‎January 01, 2026 05:13 PM

Is is there a specific excel sheet format to upload bank transactions into QB ?

Can you download in csv file format?

Reply
thomas71
Level 2
‎January 01, 2026 05:15 PM

Is is there a specific excel sheet format to upload bank transactions into QB ?

Hi,

 

unfortunately not. i cant find it. 

Reply
thomas71
Level 2
‎January 01, 2026 05:19 PM

Is is there a specific excel sheet format to upload bank transactions into QB ?

Hi, i cant find the template. 

Reply
RoseJillB
QuickBooks Team
QuickBooks Team
‎January 01, 2026 05:23 PM

Is is there a specific excel sheet format to upload bank transactions into QB ?

Yes, there is, Thomas.

 

QuickBooks Online (QBO) supports both three-column and four-column formats when uploading bank transactions via CSV or Excel files.

 

The three-column format includes Date, Description, and Amount columns. 

 

Whereas the four-column format includes Date, Description, Credit, and Debit columns.


You can also check out this article for further tips on formatting your file: Format CSV files in Excel to get bank transactions into QuickBooks.

 

Should you need further help with your bank transactions, please feel free to reply. We are always available to assist you.

Reply
SIAB
Level 7
‎January 01, 2026 05:44 PM

Is is there a specific excel sheet format to upload bank transactions into QB ?

@thomas71 

You can prepare your data in the XLS template

TxnDatePrivateNoteCurrencyExchangeRateDepositToAccountEntityLineDescLineAmountAccount
28/07/2020Manual Feed  CheckingJane SmithMonthly Dues25Account1
29/07/2020Manual Feed  CheckingBank of the WestJuly Fees-15Office Expenses
30/07/2020Manual Feed  CheckingStaplesPaper for Copier-50Office Expenses
01/08/2020Manual Feed  CheckingTeddy JonesCharitable Contribution500Account1

 

then you can use an importer tool to proceed.

https://get.transactionpro.com/qbo

 

Reply
thomas71
Level 2
‎January 01, 2026 05:52 PM

Is is there a specific excel sheet format to upload bank transactions into QB ?

Great, thanks. how will QB know that the entries are related to each other? Say two Debits relates to one credit. shall i use the same journal entry number for this?

 

Reply
Janiqueca_T
QuickBooks Team
QuickBooks Team
‎January 01, 2026 06:38 PM

Is is there a specific excel sheet format to upload bank transactions into QB ?

Hello there, thomas71.
 
When uploading bank transactions to QuickBooks Online using Excel, the software identifies related entries by matching shared details like date, description, and account information. For instance, if two debits relate to one credit, QuickBooks links them through these common fields, ensuring they are recorded as a single transaction.
 
And yes, you should assign the same journal entry number to related transactions in your Excel file. Including consistent details like account, date, and amount helps QuickBooks automatically categorize and link debits and credits as part of the same transaction.
 
Feel free to reply below if you have further questions.
Reply