• Was this page helpful?
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en Español QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help with Intuit Products   International   QuickBooks Canada   Banking, Bookkeeping & Multi-Currency  
hide
05/24/2012 at 04:51PM PDT
Important Announcement! A planned system-wide upgrade will take place over the Memorial Day Weekend in the US (From Thurs, May 24, 2012 at 6 pm PDT thru Tues, May 29, 2012 at 5 am PDT). This includes QuickBooks, QuickBooks Payroll, Point of Sale, & Salesforce.com. This is only for US based products. This does not affect QuickBooks Online customers! During this time, you can shop, but can’t place orders online, activate products or update account info. We apologize for the inconvenience & thank you for patience while we improve our infrastructure to better serve you. International versions are unaffected. For more info, see our community discussion.
70
12005
cvCkCEtRWr4yUOacwZ5xHE
Subscribe RSS
BarbRV
BarbRV
Questions asked: 8
Questions answered: 13
Points earned: 13
BarbRV
BarbRV
Questions asked: 8
Questions answered: 13
Points earned: 13
Contributor
02/03/12 3:12pm PST
Viewed by asker 02/23/12 1:44pm PST

Journal entries, payroll, and other entries not showing in Chart of Account balances, nothing balances! Help!

QuickBooks Canada : Pro 2012

New to QB

I can't figure out what I'm doing wrong.

-Tried to print a listing of entries for my bank account to reconcile the accounts  but an entire week of JE's would not show up

- Tried to get a gross payroll balance to remit my Canadian payroll taxes as at January 31st - nothing in the Chart of Accounts showing as posted but Reports does show a balance.  

- Nothing seems to match up to what I input, and none of my accounts seem to balance. 

Note:   Most of my transactions are done via journal entry unless its a physical check issued.  Most payroll and ad-hoc checks.    The rest of my transactions are online transactions - deposits from Moneris and debits from either the bank or my franchisor.   I do these by JE.      

I'm lost here!   And starting to really hate QB!    I'm obviously missing some fundamental step.   Any ideas?

Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
14 Replies
AlexanderM
AlexanderM
Questions asked: 1
Questions answered: 833
Points earned: 2341
Allstar
Allstar
Advisory council of community power users.
ProAdvisor Canada
ProAdvisor Canada
Members of the QuickBooks ProAdvisor Program
AlexanderM
AlexanderM
Questions asked: 1
Questions answered: 833
Points earned: 2341
Allstar
02/03/12 8:28pm PST

Please contact a ProAdvisor in your area to get you started on the right track. It will be time & money well spent.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
yarddog
yarddog
Questions asked: 27
Questions answered: 7168
Points earned: 12486
Allstar
02/05/12 9:45am PST

That was a (not so to the user) helpful advertisement. 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
yarddog
yarddog
Questions asked: 27
Questions answered: 7168
Points earned: 12486
Allstar
02/05/12 12:12pm PST

It was NOT a compliment ... 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
BarbRV
BarbRV
Questions asked: 8
Questions answered: 13
Points earned: 13
Contributor
02/07/12 1:36pm PST

I agree....it's too easy to answer with "spend money to hire a pro".

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
BarbRV
BarbRV
Questions asked: 8
Questions answered: 13
Points earned: 13
BarbRV
BarbRV
Questions asked: 8
Questions answered: 13
Points earned: 13
Contributor
02/07/12 1:35pm PST

As it turns out, no need to spend the money on a Proadvisor yet.   I finally figured out what was happening.

For some reason that I do not understand, you cannot see balances in the Chart of Accounts for Income and Expense accounts - only Balance Sheet Accounts.  

I was able to do a Quick Report however that finally showed me what I was looking for, as well as a report on the General Ledger itself which confirmed that everything was being posted properly. 

There seems to be alot of very quirky things like this with QB but I find the Help menu pretty good.   You just need to know how to phrase your search criteria. 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
AlexanderM
AlexanderM
Questions asked: 1
Questions answered: 833
Points earned: 2341
Allstar
02/07/12 2:00pm PST

I truly do hope you have figured out your problem, but in my many years of experience I find that when people say they have figured it out, what they mean is they have figured out a way around their problem, not necessarily the correct way, causing many hours of frustration at year end for both them and their accountant. I am not saying this is your situation, I am just saying in general.

When you say " for some reason that I do not understand" and " there seems to be alot of very quirky things like this in QuickBooks", these are the things that a couple of hours with a ProAdvisor could  help you figure out make your life alot easier. Having said that, you are right, the help is quite good and if you have the time and the committment to do a proper job I am sure you will be successful.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
smudgeid
smudgeid
Questions asked: 22
Questions answered: 2444
Points earned: 3193
Allstar
Allstar
Advisory council of community power users.
smudgeid
smudgeid
Questions asked: 22
Questions answered: 2444
Points earned: 3193
Allstar
02/08/12 6:22am PST

Don't use the chart of accounts for balances.

I always pull up a trial balance (under reports>accountant) and put it on my icon bar.  I love trial balance & you can drill down (double click) on any GL amount to see the entries.

Play a little with your reports - you'll quickly learn to check dates & be able to modify for specific information.

Kate

Fiscal Year Inc.
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
1
 Report Abuse
 
 
 
BarbRV
BarbRV
Questions asked: 8
Questions answered: 13
Points earned: 13
Contributor
02/08/12 2:51pm PST

I discovered that as well, but thanks for the additional tip to add it to my bar!  

It still would be interesting to know why the chart of accounts doesn't show p/l balances?   What's that about?

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
CountryMusicMom
CountryMusicMom
Questions asked: 47
Questions answered: 10954
Points earned: 26420
Allstar
02/08/12 3:28pm PST

Because it is just a Chart of Accounts, not a report.

Why Intuit shows Balance Sheet balances, I'm not sure.  I wish they didn't as it does confuse new users.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
smudgeid
smudgeid
Questions asked: 22
Questions answered: 2444
Points earned: 3193
Allstar
Allstar
Advisory council of community power users.
smudgeid
smudgeid
Questions asked: 22
Questions answered: 2444
Points earned: 3193
Allstar
02/08/12 6:24am PST

I highly recommend using your write cheques function for any bank withdrawals that you need to enter (just change the cheque number to something like "online" or "debit") and the deposits function for Moneris receipts.

Save the journal entries for 'non bank' activities.

Kate

Fiscal Year Inc.
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
BarbRV
BarbRV
Questions asked: 8
Questions answered: 13
Points earned: 13
Contributor
02/08/12 2:49pm PST

Any particular reason why you suggest this?  

I just purchased a franchise.   I get daily sales journals from the POS that show my daily sales (cash, debit, credit transactions), HST, cash float adjustments, coupons, gift certificates bough/redeemed, etc.

If I separate out the deposits to the bank account, it might make balancing even more difficult.

Similarly, I get an auto-withdrawal from the franchisor which includes my inventory charges, rent, royalties, marketing charges, etc.    It seems easier to do this by JE than by writing cheques.    

Unless there is a good reason why, of course.....that I've missed.    Thanks in advance!

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
smudgeid
smudgeid
Questions asked: 22
Questions answered: 2444
Points earned: 3193
Allstar
02/08/12 5:35pm PST

I've got a Second Cup franchise as a client & it's the same sort of paperwork.

I recommend memorizing a sales receipt with zero values for all your sales & receipts.  Have it automatically enter daily.  (It takes a little time to build your item list, but it's awesome having daily sales receipts ready to have the numbers posted.  It goes really fast.)

Then you can go to each day's receipt and post your transactions. The balance of your sales receipts should be zero and your category sales and all your receipts will be entered.  (Make sure your credit card receipts match your daily summary, the pos depends on staff accuracy.)

Your deposits will go to undeposited funds.  You'll wait for a bank statement, or download a week's worth & do the deposits per the actual bank.  Collect the appropriate receipts for each deposit.  In the end, balancing should be easier.

When you get your printout for the royalties etc., you would post a cheque and split it into the appropriate GLs there.  Make sure you include your HST.  When you are more used to writing cheques it should be easier than the JE & offers less chance for error.

Kate

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
1
 Report Abuse
 
 
 
BarbRV
BarbRV
Questions asked: 8
Questions answered: 13
Points earned: 13
Contributor
02/10/12 2:10pm PST

Thanks so much for the tips!   

Uum!   Dumb question...how do a memorize a sales receipt.   I haven't looked at this part of QB's yet as I didn't think it would apply.    I also like the idea of moving deposits to undeposited funds because I don't do daily bank deposits.    This will make reconciliation easier, I think.  

I also did not realize that I could "write" cheques without actually issuing a cheque number.   Good to know, and I agree better than JE's. 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
smudgeid
smudgeid
Questions asked: 22
Questions answered: 2444
Points earned: 3193
Allstar
02/10/12 5:29pm PST
Latest post

Make a sales receipt  (all your categories, in the same order as your pos printout.  I usually end with over/short. Leave the amounts as zero.).  Go to Edit>Memorize & memorize it. 

Choose "Daily" and "Automatically Enter".  Now every time you open quickbooks it will add a blank sales receipt for each day.  (You can also add them by going to lists>memorized transactions.)  I usually drill down into my income category on the trial balance to get to the first un-posted one.

Do your deposits each week (or more if you need) - your 'payments' window gets a little busy if you wait a whole month.

Kate

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
   
 
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
  • pro
  • quickbooks canada
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
salatech
20 mins ago
salatech
replied to
How do I categorize consuma...
salatech
20 mins ago
salatech
just received a solution to
How do I categorize consuma...
EPILIN
21 mins ago
EPILIN
posted
Where is my question?
ranaSMA
23 mins ago
ranaSMA
replied to
Problem with exchange rates
CountryMusicMom
28 mins ago
CountryMusicMom
replied to
Sales Receipt - missing "de...
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2012 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business