• 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   Training and Resources   Intuit ProConnection Newsletter   Accountant Community Allstars Forum   Getting Started   Intuit Academy Training   Starting and Managing Your Practice   QuickBooks and Payroll   QuickBooks General Forum  
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
60
d6C_oAheKr3yUmabTJhmjm
Subscribe RSS
TSG2006
TSG2006
Questions asked: 17
Questions answered: 33
Points earned: 33
TSG2006
TSG2006
Questions asked: 17
Questions answered: 33
Points earned: 33
Contributor
09/13/06 6:27am PDT

Income and Expense Opening Balances

I am trying to enter YTD income and expenses in a new company file. The instructions say to use OBE, but I do not understand why it says to increase OBE for YTD expenses and decrease OBE for YTD income. When I do this and then go to clear out by OBE account, to which equity account do I post the offset? If I use RE as my offset, I am increasing RE for expenses.Thanks in advance for your input!

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
8 Replies
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
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.
Allstar
Allstar
Advisory council of community power users.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Intuit Moderator
Intuit Moderator
Mod/Co-mod
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
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
Allstar, Accountant Community AllStar
07/07/06 11:57am PDT

I don't use OBE for anything except when I need a wash account (which is basically its purpose anyway)

This is what I do:

Enter a journal entry for the trial balance as of previous year end (if the company was in business).

Then, enter a journal entry for all YTD totals. . .make this a month-end date. . .

If you have outstanding checks/deposits and/or if you have payables/receivables to track, the detail will need to be entered to get your file in working order.

Whatever month-end you choose, reconcile all bank, credit card, and loan accounts to the statements. Confirm accounts payable/accounts receivable/inventory and other balance sheet account balances.

Print your reports and move forward.

Hope this is helpful,

Laura Dion
Certified QuickBooks ProAdvisor?
Cents-able Bookkeeping
My motto:
Keep it as simple as you can. . .with only as much detail as you need.

When in doubt, make a backup first!!

*****
Laura Dion
Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com
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
 
 
 
TSG2006
TSG2006
Questions asked: 17
Questions answered: 33
Points earned: 33
TSG2006
TSG2006
Questions asked: 17
Questions answered: 33
Points earned: 33
Contributor
07/07/06 7:37pm PDT

Thanks Laura! I read a lot of these postings and you always have great insight.

It seems that if I enter all the YTD balances in a JE, the resulting YTD Net Income or Loss would be the end result in OBE or RE. Therefore your OBE would not zero out until it is transferred to RE (in regards to your reply to a similar post above).

Does this sound right?

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
 
 
 
blrgcpa63
blrgcpa63
Questions asked: 16
Questions answered: 995
Points earned: 1009
blrgcpa63
blrgcpa63
Questions asked: 16
Questions answered: 995
Points earned: 1009
Contributor
07/07/06 8:48pm PDT

OBE includes all equity balances. You have to set up the common stock, add'l pd in cap, re and any other equity acct that you may have.

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
 
 
 
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
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.
Allstar
Allstar
Advisory council of community power users.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Intuit Moderator
Intuit Moderator
Mod/Co-mod
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
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
Allstar, Accountant Community AllStar
07/07/06 9:48pm PDT

Actually, the other post about OBE was specifically in reference to entering opening balances in a new file.

This is what you would need to do, if you had not already done this.

If the process is followed as I described in that post, it will zero out the OBE account.

As for the other equity accounts that blrgcpa63 referred to, this should all be on the CPA's year-end trial balance. . .which is what you need to post beginning balances.

In your case, if you are posting YTD activity with a journal entry, the offset would be cash. . .if this is where the income went and how the expenses were paid.

You might have problems reconciling your books if you post totals. . .if you still have outstanding checks/deposits/bills/invoices.

You could post the 'closed' or 'reconciled' transactions (totals) using a journal entry, but then you would have to enter all unreconciled and outstanding info individually through the QuickBooks transaction windows,so that you can move forward and reconcile your accounts.

Just so you know, in QuickBooks, net income/loss automatically posts to Retained Earnings on the first day of the new fiscal year. Adjustments from R/E to other equity accounts might also then be necessary, but that depends on the type of company you have. The CPA can advise you on this when the time comes.

I hope this clarifies things for you.

Laura Dion
Certified QuickBooks ProAdvisor?
Cents-able Bookkeeping



Edited 7/8/2006 6:45 am ET by ldion2
My motto:
Keep it as simple as you can. . .with only as much detail as you need.

When in doubt, make a backup first!!

*****
Laura Dion
Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com
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
 
 
 
SGill
SGill
Questions asked: 12
Questions answered: 3
Points earned: 3
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.
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
SGill
SGill
Questions asked: 12
Questions answered: 3
Points earned: 3
New Member
04/21/09 3:29pm PDT

Here's what I don't get. Lets say I start QB on April 1. I enter the bank account statement balance as of March 31, and there is one uncleared check for rent ($1,000). So I enter this check in QB with a March date (debit rent/credit bank account). This, according to the instructions, is necessary in order to do the April bank reconciliation.

Now, according to the instructions I have when setting up a file mid-year, I should JE all YTD income and expense account balances up to the Start Date, with the offset to OBE.

But, since the March rent expense is included in these income and expense entries, and I have now entered the rent check again as part of my setup routine, I end up duplicating the rent expense for March.

What have I done wrong?

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
 
 
 
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
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.
Allstar
Allstar
Advisory council of community power users.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Intuit Moderator
Intuit Moderator
Mod/Co-mod
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
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
Allstar, Accountant Community AllStar
04/22/09 4:09am PDT

All of your outstanding checks, deposits in transit, unpaid bills and open invoices should use Opening Balance Equity since those numbers are already captured in your journal entry.

Does this help?

_______________________________

Laura D

See my profile at:

http://proadvisor.intuit.com/r...

My motto:
Keep it as simple as you can. . .with only as much detail as you need.

When in doubt, make a backup first!!

*****
Laura Dion
Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com
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
 
 
 
SGill
SGill
Questions asked: 12
Questions answered: 3
Points earned: 3
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.
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
SGill
SGill
Questions asked: 12
Questions answered: 3
Points earned: 3
New Member
04/22/09 12:30pm PDT

Actually that does help Laura, and makes sense. But it is not what the Intuit training materials for QuickBooks certification say. They show examples entering outstanding checks with the applicable expense account shown, and make no reference to entering checks, invoices or bills with OBE as the offset account. Thanks!

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
 
 
 
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
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.
Allstar
Allstar
Advisory council of community power users.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Intuit Moderator
Intuit Moderator
Mod/Co-mod
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
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
Allstar, Accountant Community AllStar
04/23/09 3:27am PDT
Latest post

You are welcome.

My posts and suggestions are a result of much trial and error - many times the 'help' files are not that 'helpful'. . .

If you are going to need cash basis reports (which I don't recommend), you will need to enter everything using the original expense and income accounts. Then, you will need to adjust your beginning balances to account for those numbers. . .

End result - you need a trial balance as of the date before you begin activity - one that is 'approved by' your accountant. . .and with no Opening Balance Equity amount (hopefully, your accountant won't overlook this. . .)

Laura D

My motto:
Keep it as simple as you can. . .with only as much detail as you need.

When in doubt, make a backup first!!

*****
Laura Dion
Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com
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
scobet
8 secs ago
scobet
posted
How to copy check detail
BillR456
8 mins ago
BillR456
replied to
Can I dumb it down for my c...
clasebnik
11 mins ago
clasebnik
posted
posting a cheque received f...
JimatIntuit
17 mins ago
JimatIntuit
replied to
re: Client Data Review
GRRA
28 mins ago
GRRA
posted
re: Client Data Review
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