How to Fix Donations Entered Directly on Deposits in QuickBooks for Nonprofits
Published 02/28/2011 | 
If you decide to do it, let all the deposits to into undeposited funds. Then create a deposit from all undeposited funds with an additional line using your donation revenue account with a negative amount, creating a $0 deposit. You might want to create a clearing account bank account to deposit it to, especially if you have other corrections to make.
The sales receipts will duplicate your revenue, but the negative line on the deposit will restore it back to the original value.
I’d make a backup of the file before starting, just in case.
This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.
Written by +Ruth Perryman, CMA, CFE, CFM, MBA
Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.
Web Store | Price List | Free Trials | Newsletter
How to Use Designated Funds and Their Disbursements in QuickBooks for Nonprofits
Published 02/27/2011 | If you want to control cash disbursements, you can create sub-bank accounts. It’s easy to make a mistake, though, because you have nothing to reconcile against so you might want to consider opening separate bank accounts for your funds. In either case, you'll need to physically transfer funds to the unrestricted account whenever you release a restriction.
Here's what your classes should look like (to make preparing your Form 990 easier):
Unrestricted:
Admin
Fundraising
Programs
Program 1
Program 2
Temporarily restricted:
Donor restricted
Grants
Grant 1
Grant 2
Permanently restricted:
Endowment 1
Endowment 2
You might want to consider purchasing a book about using QuickBooks for nonprofits. Kathy Iven’s in the best book out there but it’s old (2005). She recently updated it but it hasn’t been released yet. You can pre-order it at Amazon for less than $24 (it normally runs $37):
This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.
Written by +Ruth Perryman, CMA, CFE, CFM, MBA
Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.
Web Store | Price List | Free Trials | Newsletter
News Flash – New and Improved Intuit Statement Writer
Published 02/26/2011 | This is one of the many reasons I recommend purchasing QuickBooks Premier for Accountants, which offers all the industry versions in one plus additional accountant features like Client Data Review (which is useful for correcting your own file too), Fixed Asset Manager, and Intuit Statement Writer. Intuit Statement Writer is only available in the Accountant’s version of Premier (for an additional fee). It’s included in all versions of QuickBooks Enterprise at no additional cost.
_______________________________________
Intuit has done it again. Intuit Statement Writer (ISW) was already a great tool for accounting professionals and was named an Awesome Add–On last fall by The Sleeter Group >. Now, with suggestions, requests and feedback from accounting professionals, Intuit has made its ISW 2011 even better.
Since you already can create a Balance Sheet, Income Statement and numerous other reports with QuickBooks >, you may wonder why you need ISW. QuickBooks’ standard reports often do not meet the needs of you or your clients. As a result, many accounting professionals export the report to Excel to make modifications and customizations to the report. If the data changes in QuickBooks, you have to export the report back to Excel and make the modifications and changes all over again. Plus, you have to do this for each client, each time. This is a very inefficient workflow.
You can work more efficiently and produce customized financial statements and reports faster than ever. Using ISW allows you to create custom statements and reports only once – and then you can reuse them for future periods or for other clients. After you customize your statements and documents, the template is memorized; all you have to do is simply refresh it to reflect the current numbers.
ISW isn’t just for CPAs who prepare financial reports; it is also beneficial for accountants or bookkeepers who customize statements or want to add value to their clients. You can use it for internal management reports, and include charts and graphs as well. Clients really appreciate the added value, while you’ll appreciate the way ISW enables you to these tasks very efficiently.
The new enhancements in ISW 2011 include:
- New Report Designer – Easily manipulate accounts with an easy, drag-and-drop method for customizing statements. You can easily:
- move accounts to rollup/combine/separate accounts (notice Cash & Cash Equivalents in the image below);
- insert subtotals or other rows or columns (notice the column for a 3rd year on the Balance sheet and the rows for the Fixed Asset Section in the image below);
- customize headers and footers for the statement and column headers;
- format your statements to meet your needs; and
- save as a template to use in the future or with other clients (notice the memorize in the image below – you can memorize one statement template or the group template).
- Easier to save on a network drive – The new setup wizard allows you to specify the drive (network or local) to save templates, while the new Report Designer allows you to change the location if necessary.
- Round-off errors – ISW now asks you to indicate which account to use for rounding errors on the balance sheet; this information flows through to the Statement of Cash Flow as well.
- Continuous Page-numbering – You can indicate where to start the continuous page-numbering (i.e., you can skip page numbering on the cover letter and report and start on the Balance Sheet).
- ISW Information Center – There are numerous videos and resources to help you with ISW. The software includes convenient links to Learn More, Watch a Guided Tour or Check for Updates.
You really owe it to yourself to try the improved ISW 2011 to see how it can help you in your practice. To learn more about it, we are offering a new course from Intuit Academy >, “Intuit Statement Writer 2011 – Your Financial Statement Solution” in mid- to late February that includes detailed examples of how to prepare three different types of statements and reports:
- Example 1: Financial Statements with Compilation Report
- Example 2: Non Profit Organization
- Example 3: Financial Statements and charts/graphs for Management
Click here to be notified as soon as the course is available. You can watch the web seminar, get free CPE if you need it and download the PDF course manual to use as a reference.
This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.
Written by +Ruth Perryman, CMA, CFE, CFM, MBA
Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.
Web Store | Price List | Free Trials | Newsletter
News Flash – Join Ruth Perryman for a 16-Week Live QuickBooks Training Webinar Series
Published 02/25/2011 | Many of you have asked if we offer online training classes, so we're thrilled to announce that we're teaming up with Business Training Team to bring you a weekly live QuickBooks training webinar series starting this Friday (3/4) at 8am pacific.
This is your chance to learn more about QuickBooks than you ever imagined and get your most challenging questions answered.
If this series goes well, we're planning on adding additional lessons for QuickBooks Point of Sale, QuickBooks for Contractors, Quickbooks for Nonprofits, and others. So please join us!
Here's more information:
_________________________________________________
What will we cover in this course?
- Lesson 1: Getting Started
- Lesson 2: Setting Up QuickBooks
- Lesson 3: Working With Lists
- Lesson 4: Working With Bank Accounts
- Lesson 5: Using Other Accounts in QuickBooks
- Lesson 6: Entering Sales Information
- Lesson 7: Receiving Payments and Making Deposits
- Lesson 8: Entering and Paying Bills
- Lesson 9: Analyzing Financial Data
- Lesson 10: Setting Up Inventory
- Lesson 11: Tracking and Paying Sales Tax
- Lesson 12: Doing Payroll With QuickBooks
- Lesson 13: Estimating and Progress Invoicing
- Lesson 14: Tracking Time
- Lesson 15: Customizing forms and writing QuickBooks Letters
- Lesson 16: Reports, Graphs and Exporting
Have you ever left an instructor led course and went back to your office and could not remember what was taught on a particular topic? Every module will be recorded and you will have access to these recordings for an entire year. You can replay the training module as many times as needed until you have a complete understanding of the topic.
Bonuses:
- Monthly Question and Answer Live Webinars
- Excel Introduction and Intermediate Training Videos
Initial Pricing….
For the first 25 participants, you will receive this live webinar training for $27 per month. Starting March 4th we will be having our first live webinar training session where you will have the opportunity to ask your questions and follow along as Ruth Perryman, Advanced QuickBooks ProAdvisor, teaches you the ins and outs of QuickBooks. As we build our library of courses – THIS PRICE WILL GO UP.
p.s. You have nothing to lose – we offer a 30 day money-back guarantee. Simply contact us and we will gladly refund your money if you are not completely satisfied.
This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.
Written by +Ruth Perryman, CMA, CFE, CFM, MBA
Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.
Web Store | Price List | Free Trials | Newsletter
Recent Comments