• Skip to primary navigation
  • Skip to main content

QBGarage.com

The QuickBooks Specialists

  • Home
  • Blog
  • KnowledgeBase
  • Company
  • Show Search
Hide Search
You are here: Home / Archives for check

check

What Should I Do If My Accrual Basis Balance Sheet Is Out Of Balance?

Chief Mechanic · September 5, 2010 ·

A balance sheet in QuickBooks can be produced on either a cash or accrual basis.  A balance sheet that’s in balance is one where total assets are equal to the sum of total liabilities plus total equity.  Sometimes, if your company file (.qbw) has become damaged, this fundamental accounting relationship can be broken because of data damage to individual transactions.

Intuit has several troubleshooting steps to attempt to resolve problems with a balance sheet that’s out of balance.  These steps depend on which reporting basis balance sheet is out of balance.  In this article, we’ll summarize the steps to address an accrual basis balance sheet that’s out of balance.  See our related article on resolving problems with a cash basis balance sheet.  There are also other ways to use reports to assist rebuilding a damaged company file.

The most likely cause of an out-of-balance accrual basis balance sheet is an income or expense account with an account balance but without transactions that add up to that balance.  To fix this problem, Intuit recommends a multi-step process that involves:

  1. calculating the amount by which the balance sheet is out of balance
  2. identifying the problem account
  3. testing your account identification
  4. recording a check for $.01 to that account
  5. running the Rebuild Data utility
  6. deleting the check for $.01 previously recorded and testing the outcome

Step 1 – Calculate the Amount Your Balance Sheet is Out of Balance

Produce a standard balance sheet (Reports->Company & Financial->Balance Sheet Standard) and calculate the amount your balance sheet is out of balance.  Be sure to click the Modify Report… button and set the Dates to All and the Report Basis to Accrual.

QuickBooks Premier 2009 Modify Report Balance Sheet All Dates Accrual Basis

Step 2 – Identify the Problem Account

First, export your chart of accounts.  From the File->Utilities->Export->Lists to IIF Files… menu selection, choose Chart of Accounts in the Export window and click Ok.

QB_Premier 2009 Export Chart of Accounts

This export procedure will produce a delimited IIF file.  Open this file in Microsoft Excel.  Intuit recommends deleting the first 2 lines of this file, but we’ve kept them in the file in the screenshot below so you can see how the file will appear when you first open it in Excel.  Note that Name is in Column B and OBAMOUNT is in Column F.  Find the out-of-balance amount you calculated in the previous step in Column F, OBAMOUNT.  There are 2 ways to do this: a) use Excel’s Find capability or b) sort all rows below the first 3 rows in the original Excel file (below the first 1 row if you choose to delete the first 2) and scroll through the sorted list of numbers to locate the out-of-balance amount you previously calculated.

Write down the account name from Column B that matches the OBAMOUNT you locate.

Excel Chart of Accounts OBAMOUNT

Step 3 – Test To See If the Account You Identified Is the Problem Account

Return to QuickBooks and open your chart of accounts (Company->Chart of Accounts or the keyboard shortcut Ctrl + a).  Locate the account you identified in the previous step and double click on it to produce a QuickReport.  Be sure to set the Dates setting to All dates.  If there are no transactions in this account, then the identification process in Step 2 was successful.  You’ve located an account with a balance in the chart of accounts but without transactions that add up to that balance.

Step 4 – Record a Check For $.01 To The Problem Account

Record a check to the problem account for $.01 from the Banking->Write Checks menu selection or the keyboard shortcut Ctrl + w.  On the Expenses tab of the Write Checks window, enter the problem account previously identified.

Step 5 – Run the Rebuild Data Utility

From the Files->Utilities->Rebuild Data menu selection, run the Rebuild Data utility.  This utility will attempt to match the transactions in an account with the account’s balance, thereby resolving the out-of-balance problem on the balance sheet.

Step 6 – Delete the Check Previously Recorded and Test the Results

Delete the check you recorded in Step 4.  Open your chart of accounts (Company->Chart of Accounts or the keyboard shortcut Ctrl + a) and locate the problem account.

If the account you identified was a balance sheet account (accounts payable, accounts receivable, bank, credit card, equity, fixed asset, loan, long-term liability, other asset, other current asset, or other current liability), double click on the account to QuickZoom into that account’s register.  Locate the check for $.01 and delete it by clicking the Edit->Delete menu selection or using the keyboard shortcut Ctrl + d.

If the account you identified was an income statement account (income, expense, other income, other expense, or cost of goods sold), double click on the account to produce a QuickReport.  Be sure to change the Dates setting to All.  Locate the check for $.01 and double click on that entry on the QuickReport.  Delete the check by clicking the Edit->Delete menu selection or using the keyboard shortcut Ctrl + d.

Repeat the steps in Step 1 to produce a standard balance sheet and verify that the balance sheet is in balance.  Be sure to confirm your Dates setting is set to All and your Report Basis is set to Accrual.

Sometimes, if you have several problem accounts, repeating this entire series of steps can restore balance to your balance sheet.  For more serious data problems, send us an email.

To follow Intuit’s discussion of these steps, consult this Intuit knowledge base article.

Vote This Post DownVote This Post Up (0 rating, 2 votes)
Loading...

What Distinguishes a Reimbursable Expense From Other Expenses?

Chief Mechanic · September 1, 2010 ·

A reimbursable expense is an expense that you expect to invoice to a customer or client either at the actual cost or with a markup.  QuickBooks includes features to distinguish reimbursable expenses from other types of expenses and to track which reimbursable expenses have in fact been invoiced to a customer. 

For more information on handling reimbursable expenses, see our related articles on enabling automatically invoicing customers for reimbursable expenses, invoicing a customer for reimbursable expenses, removing expenses from the list of billable expenses to be invoiced to a customer, and finding out which reimbursable expenses haven’t been billed to a customer.

In QuickBooks, the 4 principal ways to record expenses for a business are:

  1. Recording a vendor bill using the Vendor->Enter Bills menu selection
  2. Writing a check using the Banking->Write Checks menu selection or Ctrl + W keyboard shortcut
  3. Recording a credit card transaction using the Banking->Enter Credit Card Charges menu selection
  4. Via a General Journal entry using the Company->Make General Journal Entries… menu selection

When you record an expense using 1 of these 4 methods, you can associate line items on the transaction with one or more Customer:Jobs.  Doing so will enable you to analyze both the expenses as well as the revenues from a job.

When you add a Customer:Job to a line item on a check, vendor bill, credit card charge, or General Journal entry, QuickBooks will automatically put a check mark in the Billable? field.  That check mark in the Billable? field indicates this is a reimbursable expense to be invoiced to a customer or client.  If it’s not, simply remove the check mark by clicking on it.

Unfortunately, there’s presently no way to set the default for the Billable? field to being unchecked for those organizations who want to simply assign expenses to customers and not seek reimbursement.  Leaving this field checked won’t interfere with associating expenses with customers; it’s an important detail if your organization does want to use it to track reimbursable expenses. In either case, with a Customer:Job associated with the line item for the expense, you’ll be able to use QuickBooks to perform job profitability analysis, more commonly known as job costing.

The screens for each of the 4 principal ways to record an expense are shown below.  Here’s the Enter Bills window:

QuickBooks Premier 2009 Enter Bill Reimbursable Expense Tab

The Write Checks window:

QuickBooks Premier 2009 Write Checks Billable

The Enter Credit Card Charges window:

QuickBooks Premier 2009 Enter Credit Card Charge Billable

And the Make General Journal Entries window:

QuickBooks Premier 2009 Make General Journal Entries Billable

Note that the field where you enter the Customer:Job on the Make General Journal Entries window is actually called Name because General Journal entries can be recorded for an entity that isn’t a Customer:Job, such as a Vendor, Employee, or Other Name.

Vote This Post DownVote This Post Up (+2 rating, 2 votes)
Loading...

How Does Quickbooks Handle Voiding a Check Dated In a Closed Period?

Chief Mechanic · August 30, 2010 ·

When you void a check, QuickBooks:

  • changes the original amount of the check to 0.00
  • adds the text VOID: to the beginning of the Memo
  • sets the cleared flag, Clr

When you’ve specified that your books are closed through a given date, in addition to performing the above steps, QuickBooks gives you the option of automatically adding reversing general journal entries so that accounting reports for the closed period are not affected. However, this option to automatically add a reversing general journal entry comes with a big stipulation: the accounts associated with the check must be expense accounts. If they’re other account types, you’ll have to construct reversing general journal entries on your own.

A bill payment check is similar to a check, but it is actually a different transaction type. QuickBooks only provides the option to automatically reverse voided checks, not bill payment checks. Later in this article, we’ll describe how to manually make the reversing general journal entries when voiding a bill payment check from a closed period.

To see this process in action, first verify your Closing Date.  You can find it by clicking on the Company->Set Closing Date… menu selection.

QuickBooks Enterprise Solutions 10 Closing Date

For our sample company, the Closing Date has been set to 11/30/2013.  If you void any check dated on or before this date, QuickBooks will give you the option of automatically creating well-documented reversing general journal entries that will maintain the accuracy of your accounting reports for the closed period.

To void a check, you can either right click on the check in the bank account register to invoke the context menu and select Void Check or you can select the check in the register and choose Void Check from the Edit menu.  Both paths take you to the same destination.

QuickBooks Enterprise Solutions 10 Void Check

Since check # 5244 is dated before the Closing Date, voiding it will bring up this warning:

QuickBooks Enterprise Solutions 10 Void Old Check Warning

You have the option of simply voiding the check and not having QuickBooks create the reversing general journal entries.  Just click the No, just void the check button.  However, unless you manually create reversing general journal entries, financial reports from the closed period will no longer be accurate, since the check amount was just changed to 0.00.  Even if you intend to modify the reversing general journal entries (such as to add more information to the Memo), it’s a good idea to click the Yes (Recommended) button.

Clicking the Yes (Recommended) button causes QuickBooks to automatically perform these steps:

  • create a reconciled general journal entry on the date of the original check
  • create a reconciled, reversing general journal entry on the date you voided the check
  • add additional text to the Memo of the voided check to refer to the journal entries made

The general journal entry on the date of the original check:

QuickBooks Enterprise Solutions 10 Void Check Reversing Journal Entry 1

The reversing general journal entry on the date the check was voided:

QuickBooks Enterprise Solutions 10 Void Check Reversing Journal Entry 2

The updated memo on the voided check that refers to the general journal entries:

QuickBooks Enterprise Solutions 10 Void Check Memo

Note that QuickBooks automatically sets the Clr flag for both journal entries, just like it does for the voided check.  By doing so, voiding the check and recording the reversing journal entries will not interfere with your bank reconciliation.

Recording these journal entries preserves the accuracy of your financial statements for the closed period.  If you simply voided the check and didn’t record these entries, rent expense for the closed period would be lower than previously reported on your financial statements or tax returns.  That inconsistency can lead to questions about the reliability of accounting information and cause time to be spent trying to reconcile the difference.  Well-documented general journal entries eliminate the potential for inconsistency.

The reversing general journal entry puts a credit to rent expense in the current period.  If you were voiding the original check because it was never cashed and you now plan to issue a replacement, the credit and the replacement check will offset.  That way, your expenses (or the accounts on the original check) are not overstated in the current period.  If you were voiding the check and you don’t plan to reissue it, expenses for a closed period were overstated, and they’ve been adjusted in the current period – when the overstatement was discovered.

QuickBooks did a lot of work once you clicked on the Yes (Recommended) button.  But don’t forget that the entire process is triggered by setting your Closing Date.  If you haven’t done that, QuickBooks won’t go through these time-saving steps because it lacks the information to do so.

For bill payment checks, QuickBooks won’t automatically perform the steps described above, so you’ll have to go through them manually when voiding a bill payment check in a closed period. Those steps are:

  1. void the bill payment check, noting the vendor; voiding the bill payment check will turn the bill into an outstanding A/P balance
  2. record a general journal entry on the date of the original bill payment check with the first line on the journal entry as a debit to accounts payable; record the vendor in the Name column on this line; the second line of the journal entry is a credit to the bank account from which the bill payment check was written
  3. record a general journal entry on the date the bill payment check was voided with the first line on the journal entry as a credit to accounts payable; record the vendor in the Name column on this line; the second line of the journal entry is a debit to the original bank account
  4. use the Vendors->Pay Bills function to use the older general journal entry to pay the original bill
  5. pay the newer general journal entry in the normal course of business

It’s important to note that the procedures described here cover voiding – but not re-issuing – a check. If you need to re-issue a check, you’ll have to do so in the current accounting period. Voiding a bill payment check leaves a current accounts payable balance for you to pay in the current period. If you want to void a bill payment check in a closed period and cancel the original bill, you’ll need to record a bill credit in addition to the steps outlined above.

Vote This Post DownVote This Post Up (+8 rating, 16 votes)
Loading...

What Image File Formats Are Supported for Logos On Forms and Checks?

Chief Mechanic · August 28, 2010 ·

QuickBooks supports the following image file formats:

  • JPEG (Joint Photographic Experts Group)
  • PNG (Portable Network Graphics)
  • GIF (Graphics Interchange Format)
  • TIFF (Tagged Image File Format)
  • WMF (Windows Metafile Format)
  • EMF (Enhanced Metafile Format)
  • BMP (bitmap)

Our list of supported formats is in the order, generally speaking, that we recommend you use them. The format that’s right for you depends on a number of factors.

When choosing a file format, keep in mind that large files take longer to load and redraw. For high-volume tasks such as invoicing, it’s important to choose an image file that offers both high quality and small size. Bitmapped images are based on a series of pixels, or picture elements. Vector images are based on mathematical formulas. It’s easier and more accurate to represent curves in a vector format than a bitmapped format, so the format that’s right for you will also depend on what you are displaying in your image. You’ll need to strike a balance between high quality and small size based on your specific needs.

A JPEG file is a compressed bitmap format that’s best suited for photographs and images that contain smooth color and tone variations. Because of compression, JPEG files save on space. However, the compression isn’t lossless – data is discarded to compress the image.

A PNG file is a compressed bitmap file that offers transparency and lossless compression. The PNG format was created to improve on the GIF format by offering more colors in a small size. It’s a format that was designed for exchanging and displaying images on the internet, and therefore doesn’t support features that professional printers require, such as the CMYK color space.

A GIF file is a bitmap file based on a format originally developed by Compuserve that offers small size based on lossless data compression and transparency. GIF’s support only 256 colors, so it can’t render a photograph as well as a JPEG. But it’s a good choice for logos or artwork with solid blocks of color.

A TIFF file is a flexible yet powerful format originally developed by Adobe that can use lossless compression or remain uncompressed. TIFF files offer color depth, high resolution, and the ability to store vector drawings. TIFF files can even store multiple pages. They’re a good choice where vector-based illustration tools produced line drawings that need to re-produced without degrading quality. If you’re planning to use a TIFF image in QuickBooks that includes color, pay attention to your color space. We’ve observed that QuickBooks works best with images designed for the RGB color space as opposed to CMYK. CYMK is often the default color space for a TIFF image. An image designed for a professional printer in an image editing program such as Adobe Photoshop is often set to use the CMYK color space. Colors may not render on your QuickBooks forms as you expect in that situation.

Like the name suggests, WMF is Microsoft Windows-based format that can store high quality vector images. It supports 16 bits. WMF is the standard format for popular programs, such as Microsoft Office, so there’s a wide variety of clipart available in this format. If you want to quickly create a logo from free clipart, WMF (and its relative EMF) may be a good choice.

EMF is the 32-bit version of WMF. More bits translate into the ability to store more colors. An EMF file can store up to 16,777,216 colors, a big jump over WMF’s 65,536 colors.

BMP, as its name indicates, is an uncompressed bitmap image format. Because images are uncompressed, file sizes are much larger than other file types. For example, it’s not uncommon for a BMP file to be 10 times larger than a PNG of the same image. However, BMP images are widely available, especially in the Windows environment. It may be a reasonable format choice for a small clipart image used on a form. It wouldn’t be suitable as a background for an entire page.

Although the integrated help file for some versions of QuickBooks, such as QuickBooks 2009, only lists 3 file types, all of the file types listed in this article are supported for versions 2009 and later.

Vote This Post DownVote This Post Up (+1 rating, 1 votes)
Loading...
  • « Go to Previous Page
  • Page 1
  • Page 2

Accounting

  • Financial Accounting Standards Board

Developer

  • Intuit Developer Network Forums
  • qbXML Onscreen Reference

Intuit

  • Enterprise Solutions
  • Intuit
  • Intuit Marketplace
  • QuickBooks
  • QuickBooks Online Community

QBGarage.com

Copyright © 2008–2025 QBGarage.com · Privacy · Terms & Conditions · Site Help