• Skip to primary navigation
  • Skip to main content

QBGarage.com

The QuickBooks Specialists

  • Home
  • Blog
  • KnowledgeBase
  • Company
  • Show Search
Hide Search

Should I Use Account Numbers In My General Ledger?

Chief Mechanic · September 7, 2010 ·

We think you should use account numbers in your general ledger, but we think it’s more important that you’re consistent in either using them correctly or not using them at all.

To use account numbers, you need to enable that preference by visiting the Edit->Preferences menu and clicking on the Company Preferences tab of the Accounting submenu, which is shown below.

QuickBooks Premier 2009 Preferences Use Account Numbers

Once the account number preference is enabled, you’ll be able to manually assign account numbers to your general ledger accounts.  QuickBooks won’t automatically assign them for you or insure that your numbers follow a consistent structure.  It will insert the account number before the account name, and you’ll then be able to quickly locate accounts by typing the first few characters of an account name or the first few digits of the account number.

When assigning account numbers, use numbers that:

  • have a consistent length
  • have multiple unused integers between numbers to accommodate changes to your general ledger
  • follow a consistent structure

New businesses or companies installing QuickBooks for the first time are more likely to make changes to their general ledgers, so it’s especially important for these firms to have the flexibility to add or change account numbers.

In older versions of QuickBooks, account numbers were a way to re-arrange the order of accounts rather than having an account list in alphabetical order based on the account description.  Since you can now drag accounts in your chart of accounts list to rearrange the order, account numbers no longer serve that purpose.  Account numbers are primarily a tool to organize account numbers outside of QuickBooks, such as in Excel, and to improve the readabilty of your account list.

Intuit recommends the following ranges for assigning account numbers:

10000 to 19999 Assets
20000 to 29999 Liabilities
30000 to 39999 Equity or Capital
40000 to 49999 Income or Revenue
50000 to 59999 Cost of Goods Sold, Job Costs, or Project Costs
60000 to 69999 Expenses or Overhead Costs
70000 to 79999 Other Income
80000 to 89999 Other Expenses

QuickBooks organizes accounts on reports based on the account type, not the account number.  Whether you follow this structure or another one of your own choosing is up to you.  Just keep in mind that account numbers are another tool to help organize information.  If you use account numbers but don’t use them in a way that results in a better organized chart of accounts, you’re actually worse off.

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

What Is the Transaction Log File?

Chief Mechanic · September 7, 2010 ·

The QuickBooks transaction log file is a log of all changes about to be made to the company file (.qbw) before they are actually recorded in the company file.  It is stored in the same folder as the company file itself.  It’s automatically created by QuickBooks.

The filename of the transaction log file is in the form:

[company file name].qbw.TLG

QuickBooks uses data written to the transaction log file to transparently complete the recording of transactions that were not completely recorded in the company file itself because a connection to the company file was lost.  The transaction log file can also be used in conjunction with a QuickBooks backup file (.qbb) to recover from a damaged company file.

The transaction log file is reset when:

  • you sucessfully complete a manual (not a scheduled or online) backup in QuickBooks
  • you restore a portable company file (.qbm)
  • the company file does not match the transaction log file

The company file may not match the transaction log file if you restore a backup of the company file using the same filename in the same folder or if you make a copy of a company file, take the copy to another computer and make changes, and put the changed copy back in the original location.  For example, if you want to make a copy of the company file and work on it on another computer, you need to copy both the company file itself and the corresponding transaction log file in order to preserve the data recovery benefits that the transaction log file offers.

Because the transaction log file is only reset under specific circumstances, it may grow in size and become larger than the QuickBooks company file itself.  Large transaction log files can have an adverse effect on overall QuickBooks performance, so it’s important to periodically cause the events that trigger a reset of the transaction log file.  If you perform a manual backup, it’s important to run the backup with some degree of verification enabled.  If you complete the backup without verification enabled, your transaction log file will be reset, and the unverified data in the backup may be unusable.

Additional information on the QuickBooks transaction log file can be found in this Intuit knowledge base article as well as our article on the file types used by QuickBooks.

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...

What Does Error Code 6123 Mean?

Chief Mechanic · September 6, 2010 ·

According to Intuit, Error Code 6123 indicates that QuickBooks didn’t receive a reply from the computer on which the QuickBooks company file is located.  It occurs when QuickBooks is operating in multi-user mode.

The file path at which QuickBooks expects to find the company file is the location shown on the Product Information screen.  This screen can be displayed by pressing F2 while in QuickBooks.

QuickBooks Premier 2009 Product Information  Location

For more information on resolving Error Code 6123, consult this Intuit knowledge base article.

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...

Are There Restrictions On Making General Journal Entries In a Multicurrency Environment?

Chief Mechanic · September 6, 2010 ·

Yes, there are a few restrictions on making General Journal entries in a multicurrency environment.

  1. Only 1 foreign currency is allowed per General Journal entry
  2. The currency of the General Journal entry must match the currency of the accounts selected or be your home currency
  3. If you enter data in the Name field, it must match the currency of the Account field

The Currency selected in a General Journal entry represents the currency units used in the entry.  A General Journal entry to an account transacting in EUR with the Currency set to USD (where USD is the home currency) is permitted – the entry will simply be converted at the Exchange Rate recorded with the General Journal entry.  However, a General Journal entry between 2 accounts, 1 transacting in EUR and the other transacting in GBP (where the home currency is USD) is not permitted.  Further, if the Currency for the entry is set to something other than the home currency (such as EUR if your home currency is USD), you can’t enter a General Journal entry to an account transacting in GBP even though there is just 1 foreign currency on the entry.

Here’s an example of a General Journal entry in Euros (EUR) that meets these restrictions:

QuickBooks Premier 2009 Multicurrency Make General Journal Entry

Here are some of the warning screens you’ll see if you attempt to violate these restrictions:

QuickBooks Premier 2009 General Ledger Warning 4

QuickBooks Premier 2009 General Ledger Warning 6

QuickBooks Premier 2009 General Ledger Warning 5

The restrictions on General Journal entries in a multicurrency environment are in addition to the restrictions that apply when only 1 currency is used.

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...

What Does the Detail Level Filter Do?

Chief Mechanic · September 6, 2010 ·

When running a report in QuickBooks, the output is controlled by the Filters set for that report.

The Detail Level is one such filter.

It has 3 possible settings:

  • All
  • Summary only
  • All except summary

Many transactions in QuickBooks can have multiple line items.  For example, a customer invoice may consist of 2 separate line items of $50 each that total $100.

With the Detail Level filter set to All, a QuickBooks report would show both the individual line items andthe total.  In the above example, that’s the 2 line items of $50 each and the transaction total of $100.

With the Detail Level filter set to Summary only, a QuickBooks report would show only the transaction total.  In the above example, that’s $100.

With the Detail Level filter set to All except summary, a QuickBooks report would show only the detail lines and exclude the transaction total.  In the above example, that’s the 2 line items of $50 each.

The function of the Detail Level report filter is summarized in this Intuit knowledgebase article.

Vote This Post DownVote This Post Up (0 rating, 2 votes)
Loading...
  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 19
  • Page 20
  • Page 21
  • Page 22
  • Page 23
  • Interim pages omitted …
  • Page 56
  • Go to Next Page »

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–2026 QBGarage.com · Privacy · Terms & Conditions · Site Help