QUICKBOOKS TIPS

Reconciling Accounts

 We have been using QuickBooks since it first came out, and are very familiar with all kinds of shortcuts to allow you to do your entries quicker and more accurately.  Many of our clients will be able to put aside extra Excel spreadsheets, as they find out how to use the QuickBooks software to reconcile many accounts besides the bank account. 

Q: Can you reconcile again to include a fixed entry

 A: Of course, just reconcile again on the same date that you used the first time.  Use zero as the statement balance.  Check your printed reconciliation report to confirm which date you used.  Then reconcile the corrected item back into that reconciliation by checking it off.  Then to finish the reconciliation, modify the balance and make it agree to what you see on the screen as the Cleared Balance. You should not have any adjusting entries to delete with this method. 

Q:Can you still use iif files to import into QuickBooks desktop

 A: Yes, some entries will work quite well, however, Intuit Canada does not support the use of IIF files.  We can help we integration problems because we have worked with many different add on software and point of sale solutions.  We cannot promise a fix, but in most cases we have been able to bring through payroll and sales etc 

Hot Keys in QuickBooks

If you want to go forward or back one YeaR, then you would type Y to get to the beginning of the year, then type the letter R to get to the end of the year.

You can you the same principal with M and H for going forward or backwards by a MontH. 

You can use the letter T for Today`s date. 

Calculating in QuickBooks

When you are in most of the number fields you can calculate of the fly using the symbols around the number pad on your keyboard. 

For example, use * to multiply or use / to divide.

You can also use the amount field in a vendor bill to add a long column of numbers, and it acts just like a calculator with a tape.