• Was this page helpful?
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
QuickBooks General Forum QuickBooks Payroll 3rd Party Apps that work with QuickBooks QuickBooks Accountant Edition QuickBooks Online for Accounting Professionals QuickBooks Enterprise Solutions QuickBooks Point of Sale
ProAdvisor Program & Certification
ProSeries DMS ProSeries Community
Lacerte DMS Lacerte Community
Intuit Tax Online Tax Research for Lacerte and ProSeries Tax Import for Lacerte and ProSeries Intuit Practice Management EasyACCT Intuit Statement Writer
Starting and Managing Your Practice Classifieds Intuit ProConnection Newsletter Intuit Academy Training Your Peers Recommend
  • QuickBooks & Payroll
  • ProAdvisors
  • Lacerte
  • ProSeries
  • Productivity Tools
  • Training & Resources
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 for Accountants  
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.
1
31
dIdyGmheKr3yUmabTJhmjm
Subscribe RSS
JuliaS
JuliaS
Questions asked: 1
Questions answered: 0
Points earned: 0
JuliaS
JuliaS
Questions asked: 1
Questions answered: 0
Points earned: 0
New Member
02/11/08 11:04pm PST

A/R on balance sheet doesn't match A/R report

I've just met with a new client who was having trouble being bonded for a construction job. One of the obvious things I saw was the current accounts receivable on their balance sheet (negative $13,000!) doesn't match the actual A/R on the Customers & Receivables report (positive $100,000+). Their CPA suggested it was a cash-accrual reporting issue with Quickbooks (they're on Premier 2008), but I've changed their preferences to accrual from cash and it makes no difference.I've never seen this before. I've triple-checked my report dates. The customer is positive the true balance is what the Customers & Receivables A/R summary is reporting. Why is the balance sheet reporting a negative number?Thanks!Julia

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
3 Replies
1244519
1244519
Questions asked: 1
Questions answered: 3
Points earned: 3
1244519
1244519
Questions asked: 1
Questions answered: 3
Points earned: 3
New Member
02/14/08 12:00am PST

Are you saying that when you look at the report in accrual it shows the same A/R amount as when you look at the report in cash?

This would be impossible if they actually have outstanding receivables.

Do make sure that you are running all the reports with the same dates.

What part of CA are you in?

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
 
 
 
WMurphyOKC
WMurphyOKC
Questions asked: 24
Questions answered: 1985
Points earned: 5956
Advanced Certified ProAdvisor
Advanced Certified ProAdvisor
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks experts.
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Certified ProAdvisor - ES
Certified ProAdvisor - ES
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient Enterprise Solutions experts
Certified ProAdvisor - POS
Certified ProAdvisor - POS
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks POS experts
WMurphyOKC
WMurphyOKC
Questions asked: 24
Questions answered: 1985
Points earned: 5956
Allstar, Accountant Community AllStar
02/14/08 12:43pm PST

You should do a direct comparison of each customer's actual open invoices and total of same to the A/R on the balance sheet, use the 'Open Invoice Report' with same date range as the Balance Sheet. When you have the Open Invoice Report review it for negative/positive offsets that show when a customer has an invoice and payments/credits but which may not have been applied.

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
 
 
 
EstherFriedberg
EstherFriedberg
Questions asked: 2
Questions answered: 180
Points earned: 182
Advanced Certified ProAdvisor
Advanced Certified ProAdvisor
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks experts.
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Certified ProAdvisor - ES
Certified ProAdvisor - ES
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient Enterprise Solutions experts
ProAdvisor Canada
ProAdvisor Canada
Members of the QuickBooks ProAdvisor Program
EstherFriedberg
EstherFriedberg
Questions asked: 2
Questions answered: 180
Points earned: 182
Contributor
02/15/08 2:32pm PST
Latest post

Are you running an Open Invoices report for a prior date and comparing it to the balance sheet as of that date?

If so, or if you are running it as of today but you've got post-dated payments, you have to Modify the report, and in the Display tab you'll see the Advanced tab. Choose it and select As of Report Date. Click OK and OK again to get back into the refreshed report.

That should fix the balance so that it matches the balance sheet.

Esther Friedberg Karp

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
    Help other users find this post by tagging it
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
Hygene
1 min ago
Hygene
posted
Month End Tax On Sales
Adityaa
19 mins ago
Adityaa
replied to
Bank rec diffrence..Please ...
Adityaa
27 mins ago
Adityaa
has a new Spotlight
Commodity brokers
rwkarr
1 hr ago
rwkarr
posted
how to download the latest ...
JOBNEWTON
2 hrs ago
JOBNEWTON
posted
I WANT TO MAKE A LIST OF TH...
Product Resources
QuickBooks Tax Products Payroll ProAdvisor Program Training and Certification Feedback Survey
Resources: Find Local ProAdvisor Tax Almanac Practice Resources
Support: QuickBooks Lacerte ProSeries EasyACCT
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