QuickBooks Online Coming Soon: Import Sub Accounts, Late Fees, and Tips!

I am very excited to learn about the latest updates to QuickBooks Online that will be rolled out over the next several months including:

Accounts

Import sub accounts.
 

Add new accounts on the fly when creating items.

Late Fees

Automatically add a set late fee amount or percentage per invoice or per month that an invoice is overdue.

Tips

Add tips to sales receipts that automatically either go into a liability account (for pooled tips) or an income account.

Add this to my previous post about using QBO as your Point of Sale solution.

Import Old Bank & Credit Card Transactions from PDF Statements into QuickBooks Online

QuickBooks Online (QBO) downloads the last 90 days of transactions when you first connect an account. This is great when adding a relatively new account. But what if you create a new QBO account for a business that has been open for many months or over a year that you want to "catch up" on? Some banks will only allow you to do download up to a certain amount of transactions: 90 days, 6 months, only a year. You can

buy software

to scan PDF statements into QBO, but that can be very expensive. It may be cheaper to just pay a bookkeeper to key in the data! But if you are looking for a free way, except for your time, of getting these transactions imported into QBO, I have a solution for you.

1. Download your bank or credit card statements in PDF format, if you don't already have them.
   

2. Open each statement using Nitro PDF Reader. It's free.

3. Convert to a text (.TXT) file. This should open up automatically in Notepad on a PC using the default settings.

4. Create a new Excel worksheet with columns: Date, Amount, Description.

5. Depending on the format of each bank or credit card's statement, you can usually start by pasting in groups into each column. In my test with Capital One, my text file listed the transactions in numerical sequence, but the date was together with the description separate from the amounts. So I just keyed in the dates manually from the pasted descriptions and formatted the column as *M/DD/YYYY. For the amount column, I formatted as a general number to remove the $ sign. But I had to create another column temporarily to change charges to negative amount (=B2 * -1), for example, and then copy down. Then, I copied and pasted only the values back into the original column. Payments and credits have to be positive amounts. Finally, I just highlighted and hit backspace to remove the sequence number and dates from the description, but it wouldn't hurt to leave them.

6. Save Excel file in CSV format.

7. Import into QBO using File Upload option in dropdown menu. Add the account or select the account if you already have it in QBO. It should recognize the Date and Description columns, but you may have to tell QBO which column to use for the Amount. Keep the selection for 1 column. Click Next and verify what will be imported. Click Next again and you're done!

I prefer to do one statement at a time copying the Excel template and saving for each month. That way, I can confirm the imported transactions show correctly in Banking after each import. And if I make a mistake, I can exclude and delete the last ones I imported, fix the file, and import again. But if you verify the transactions in Step 7 before the final Next, you should not have to do this. 

Then, all you have to do is categorize and add or match to existing transactions, such as payments from a checking account already in QBO. You can speed things up by creating rules for transactions with similar descriptions so that QBO recognizes them and automatically adds them. 

How to Import Lists into QuickBooks Online

QuickBooks Online or QBO is

pretty limited

when it comes to importing lists such as Customers and Vendors, especially if you are trying to transfer data from an existing QBO account to a new one. For starters, while you can have multiple email addresses separated by commas or multiple phone numbers in QBO, you can only import one for each field, and this will throw out major errors and prevent those records that have multiples from importing. Another major problem is having 2 street addresses, which is pretty common, but you can only import one. 

Fortunately, I have procedure that I use which overcomes these hurdles. 

1. Export data to QuickBooks desktop edition. From within QBO, go to Gear | Tools | Export Data. You must do this using Internet Explorer.

2. Open exported file in QuickBooks for Windows (latest version).

3. If your file just has lists, now is a good time to remove inactive list items, as if you don't, they will import into QBO as "Name (deleted) (deleted)" and will be active again. I use Method CRM to create a routine that removes all of these en masse instead of deleting one by one within QuickBooks.

4.  Go to Company | Export Company File to QuickBooks Online.

5. Import Data into QBO. You can either import just the lists (no balances) or lists and transactions. Again, do this using Internet Explorer.

Note

: if you made a mistake and what you have in QBO isn't what you wanted (for example, you missed step 3 above), you can always do the import again. However, you may have to purge the data first. Just change the URL in QBO (https://qbo.intuit.com/app/homepage)

 to https://qbo.intuit.com/app/purgecompany.