Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
T
thomas71
January 2, 2026
Question

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

  • January 2, 2026
  • 2 replies
  • 16 views
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?

2 replies

SIAB
SIAB
Level 2
January 2, 2026

Can you download in csv file format?

T
thomas71Author
January 2, 2026

Hi,

 

unfortunately not. i cant find it. 

T
thomas71Author
January 2, 2026

Hi, i cant find the template. 

R
RoseJillBQuickBooks Team
QuickBooks Team
January 2, 2026

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.

    T
    thomas71Author
    January 2, 2026

    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?

     

    J
    Janiqueca_TQuickBooks Team
    QuickBooks Team
    January 2, 2026
    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.
    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement