BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months*   Ends 11/30

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
Jovychris_A
Moderator

Reply to message

I'd be delighted to answer your questions, @starfinder.

 

You may have imported these transactions with a positive sign, that's why it was it was recognized as income rather than charges/expenses. In importing CSV files, you can use either a 3-column or 4-column format.

 

When you edit these transactions using Excel, make sure to enter charges/payments/expenses with negative signs.

 

I've added a table below for visual reference.

 

3 Columns

The 3-column template has columns for the Date, a Description of the transaction, and the Amount of the transaction.

1.PNG


4 Columns

The 4-column template has a Date column, a Description column, and both a Credit and a Debit column.

2.PNG


You can add bank accounts as many as you can as long as the financial institution is supported by QuickBooks. That's why we recommend using WebConnect in downloading bank transactions because we're getting the actual data that is recorded from your bank.

 

Also, you can change the bank's name by clicking the Pencil icon beside it.

 

Here's how:

  1. You can click the Gear icon on the top right.
  2. Select Bank accounts.
  3. Click the Pencil icon beside the bank account.
  4. Tap on the blank space to save it.

 

For reference on how to manually enter single transactions and recent transactions in QuickBooks, check these articles:

 

Feel free to place a comment if you have more questions. I'm always here to help. Have a great day!

Need to get in touch?

Contact us