December 2012
WB Logo

 From the office of:

Weltman Bernfield

Follow us on TwitterView our profile on LinkedInFind us on Facebook 

Join Our Mailing List
Our Monthly Tip:  
Making a Change After Reconciling
by Mandy Miles,
Staff Accountant


Ever need to change a transaction after you've reconciled an account or realize you made a mistake after reconciling? You can either unreconcile the account, make your change, and re-reconcile; or you can change the transaction from the register and then place a check mark in the far right hand corner of the line item in order to mark the changed transaction as reconciled for the next time you reconcile the account. Follow the following steps for either method:

To unreconcile an account, follow these steps:
  1. Go to banking and reconcile like you normally would.
  2. Make sure you have the correct account chosen, then click on Undo Last Reconciliation.
  3. Press continue and you will be back at square one where you can re-do the reconciliation.
To change the transaction from the register and place a check mark next to it, follow these steps:
  1. Go to banking and register; choose the appropriate account.
  2. Find the transaction in the register and click in the line to change it.
  3. Once you have completed your change, click on the Record button at the bottom the screen.
  4. Now click in the box in the column with a  in the same row as your changed transaction.
  5. Now you have marked the changed transaction as reconciled.
______________

    


Webinars Designed
To Peak Your Interest
and sharpen your skills!

 

Be a part of one of the upcoming QuickBooks webinars and increase your understanding of the software.

If you have a friend who
is interested, make sure they
sign up for the QB Newsletter so they
can receive future announcements.

 
Webinar Topics 
Wed., Dec. 12, 10 am 

Cost: $49    
1 hour CPE credit for CPAs
 
To register, please
email your name and
contact information to:
 
If you have an idea for a topic or need more information, please email Rich Kane. 
_________

Have a question that needs a solution?

  

Contact one of our QuickBooks Pros...
they have the answers!
 
Rich Kane 
847.941.0253
Dean Klemenz
847.941.0205

Adam June
 
847.941.0204  
 
Rich Bauer 
847.941.0237 

  

Weltman Bernfield 
485 E Half Day Rd, Suite 250 
Buffalo Grove, IL 60089

P: 847.941.0100 
F: 847.941.0101

 
Intuit Certified ProAdvisor - Quickbooks Intuit Certified Pro Advisor - QuickBooks Advanced




Happy New Year 2013

Greetings!      

 

Greetings!

 

It's the end of the year--time to celebrate our accomplishments, reconcile our books and start getting our tax papers in order. Below are some actions you can take with QuickBooks® to close out 2012 and get ready the new year.

 

If you have more "What do I do at year end?" questions, check our our "QuickBooks® at Year End" webinar on December 12. In this webinar, we'll cover how to prepare 1099 forms, how to set the year end close date, what items to give your accountant at year end, what to do with inventory at year end and much more. See the left column or click the link above for information on how to register.

 

We hope you find these end of year tips helpful. Please contact us with any questions you have. 

 

Sincerely,

Your QuickBooks Pro Advisory Team

rkane@weltmanbernfield.com

 


QBC Logo
Say Good-Bye to 2012 and  
Ready QuickBooks for 2013

 

We hope you'll be ringing out a successful financial year at month's end. In any case, here's what you should know about preparing for 2013.

 

End of the year. QuickBooks has been hard at work for the past 11+ months, recording and tracking and storing all of that financial data that you've entered so faithfully.

 

But when you turn the calendar page and make a new start January 1, your accounting software could use some closure on the year that's just passed. Here are some actions you can take to ring out the old and ring in the new. There's more you can do (we can help you with the advanced activities), but we'll just hit the highlights here.

  • Reconcile, reconcile, reconcile. Yes, we know it's not one of your favorite chores, but we really like to see all bank and credit card accounts reconciled by the end of the year if at all possible. Void all checks necessary and enter missing transactions.

Reconciliation  

Figure 1: You can make yourself crazy looking for a nickel when you're reconciling, but it's a critical function.

 

  • Make accrual adjustments. This is complicated, and it only applies if you accrue payroll and liabilities or prepay expenses that are then carried as assets. We'll need to create journal entries for you.  
  • Close your books. This is totally optional. It depends on whether you want to lock 2012 data to everyone except those who have the password and permissions. If you don't close them, you'll have easier access to last year's transaction details. Regardless of what you choose, QuickBooks will automatically make some year-end adjustments.  
  • Do a physical inventory. Then compare this with what QuickBooks says. Reports | Inventory | Physical Inventory Worksheet.

Physical Inventory Count  

Figure 2: It's good to match up your physical inventory count with QuickBooks occasionally, and the end of the year is as good a time as any.

 

  • Run income tax reports. As you know, QuickBooks lets you assign tax lines to tax-related transactions. Use the Income Tax Preparation Report and the Income Tax Summary Report. Let us know about any errors or omissions.    
  • Check W-2 and 1099 data. You can't create these forms, of course, until after your final 2012 payroll, but you can get a head start. Ask employees to verify their names, addresses and Social Security numbers for accuracy. Also, make sure that your EIN and SEIN are correct, as well as the company address.    
  • Clean up, back up. We can monitor the health of your QuickBooks data file anytime. But year-end is a good time to scrutinize your software's performance. Has it slowed down, started crashing or returning error messages? We can troubleshoot to find the problem and clean it up. We're sure you've been backing up your file faithfully, but archive all of 2012 and store it in a very safe offsite location - or use Intuit Data Protect for online storage.

  Create Backup

Figure 3: Frequent backups are critical, but you should be sure to have a copy of your entire 2012 data file stored somewhere safe.

 

  • Double-check tax liabilities. If you're handling your own payroll, look back to see whether all of your payments and filings have been completed.

 

 

Thanks for another year.

 

Again, these are suggestions. QuickBooks does not require you to do any of them. There's more you can do, and you will need assistance with some of these. So sign up for our webinar or call us to set up a December or early January meeting to get you started right in 2013.

 

We want to take this opportunity to thank you for letting us serve your company in 2012. We certainly appreciate your business, and we're happy to do what we can to help your business prosper.

 

And, remember--It's not too early to think about taxes, so let us know if you want to get a jump on planning and preparation in January.