Category Archives: Uncategorized

QuickBooks update: April 29 2015

  1. Pay Bills (filter, re-sort and apply partial credits)
  2. Enter Bill, save and make payment from the same screen
  3. Permanently delete transactions from excluded section of banking page
  4. Add notes on customer page
  5. Export reports to Microsoft Excel XLSX format
  6. Add bigger size logo (400×200)


QuickBooks update: April 29, 2015

20150429 pay bills

20150429 bill save make payment

20150429 delete excluded

20150429 customer add notes

20150429 xlsx

20150429 bigger logo

20150429 tile tabs

How to close down a prior period with a password

To close the books from the home page screen:

  1. Click the Gear icon > Company Settings.
  2. Select Advanced > Accounting > Close the books.
  3. Enter a Closing date. Transactions dated on or before the closing date can’t be changed without warning.
  4. Choose how you want to allow changes:
    • Choose Allow changes after viewing a warning to display a warning message only.
    • Choose Allow changes after viewing a warning and entering password to also require the user to enter a password.
  5. Click Save.

View transactions that are changed after the closing date

Once you close your books, you can track changes that anyone makes in spite of the closing date warning. The Exceptions to Closing Date report tracks these changes on the Audit Trail page.


accounting close the books with password


How to import credit card transactions from Excel CSV (.csv) file into QuickBooks Online?

The short video (below) will show you step-by-step instructions on how to import credit card transactions from Excel CSV file into QBO so that you will not import transactions the wrong way.

Confusion has to do with bank account field and Quickbooks field screen. It is the same field name for bank download as well credit card download. Users are importing a CSV file from credit card company and every transaction ended up being the opposite of what it should be…. expenses listed as credits (spent), credits listed as expenses (received).

Once you have downloaded transactions, there is no way to UNDO or delete downloaded transactions. You will have to move to “EXCLUDED” column and it will stay there forever which is not good.

So, I highly encourage you to watch the entire video. You do not want to miss a step.

import cc csv 1

import cc csv 2

import cc csv 3JPG

import cc csv 4

import cc csv 5

import cc csv 6

import cc csv 7

import cc csv 8.1

import cc csv 8.2

import cc csv 9

Where & how do I enter new W-9 information for sub-contractors in new QuickBooks Online?

Partial information from W-9 goes to Vendor Information screen. You need PLUS level subscription.

Most important info is to enter tax ID and “track payments for 1099” checkbox.

There is no way to actually attach actual W-9 form at this time.

If you feel this feature should be added to future revision, please make your voice heard by sending your feedback.

vendor info tax id
vendor info tax id
vendor prepare 1099s
vendor prepare 1099s
vendor prepare 1099s follow steps
vendor prepare 1099s follow steps

Where is the bank reconciliation in new QB Online?

From the homepage screen

  • Click on the Company Gear (upper right- see pic)
  • Select Reconcile under Tools heading
  • Choose the Account
  • Now you can Reconcile

Another way to get there is from the homepage screen

  • From the blue navigation bar on the left, select Transactions
  • Select Registers
  • Locate and double click the bank account(or credit card account) to reconcile
  • On the bottom left is the Reconcile button.

When you reconcile, it is very important to make sure the difference (at the bottom) is zero amount. Do not go for an Auto Adjustment as that will be automatically posted to Reconciliation Discrepancies as an expense in P&L.

Click on the screenshot below to enlarge it

Bank Reconciliation
Bank Reconciliation