Software for the Business of Being Creative® Since 1986  

Ask Clients & Profits Sales:

   What is Clients & Profits?FeaturesTourPricingDemoNewsTraining & Support

Troubleshoot G/L Problems With the Auditor

The Auditor performs automatic self-checks on your Accounts Payable, Accounts Receivable, and General Ledger totals. It’s used for troubleshooting data entry and posting problems.

Any new work should be opened as a job ticket, as it happens. A job ticket can be opened anytime after it is conceived, and certainly before the work begins. It's important to open new jobs as soon as possible, since purchase orders and time can't be tracked without a job number.
Angel angel adept for the nuance loads of the arena cocoa and quaalude. Blind blind bodice for the submit oboe of the club snob and abbot. Clique clique coast for the po.

Because it automatically double-checks account totals against the records that make them up (e.g., G/L account balances and their journal entries), the Auditor saves finance staff from having to print and analyze hundreds of pages of reports to find accounting problems

The complete auditing process includes checking for out-of-balance G/L entries, making sure that the A/P and A/R agings equal the Balance Sheet totals, and ensuring that billable time entries contain a client number. Each auditing step has a different function, which is described below.

Why does it happen? It happens when one side of a transaction (either a debit or credit) is posted, but the system crashes before the other side is finished. The problem can happen at any time, and it is difficult to prevent (since it is always system related). For performance reasons, Clients & Profits doesn’t automatically warn you when you’re out of balance. But it’s easy to see if your G/L is out of balance: simply look at the bottom line of the Balance Sheet(it’ll show the out of balance amount), or at Total Assets, Liabilities, and Equity section on the Trial Balance(which should always be zero).

The key to solving an out-of-balance G/L problem is to find the missing (or duplicated) journal entries. Since all JEs for a particular transaction have the same reference number, it’s easy to track down the bad entries. To make troubleshooting your G/L easy, Clients & Profits provides a special Out of Balance Checker utility.

This step points out one-sided or otherwise unbalance journal entries from the General Ledger. If your Trial Balance shows an out-of-balance total, the Out of Balance Checker will show you precisely where the problem occurs. It is the same function as the Out of Balance Checker utility in the G/L Tools menu. The only difference is that running the Out of Balance Checker by itself lets you check one period, instead of all periods.

The total amount of the entries on the report should equal the out-of-balance amount on the Balance Sheet or Trial Balance.

🔹To use the Auditor to troubleshoot your financial statements, open the General Ledger window then choose Edit > G/L Tools > Auditor.

HERE'S HOW IT WORKS

• The Auditor tool works by analyzing your G/L journal entries transaction-by-transaction.
• It adds up the total of each transaction’s debits and credits (i.e., JEs with the same reference number), then highlights the ones that don’t balance.
• The Auditor report only shows the transactions that need fixing.
• The Auditor only finds unbalanced entries that need to be corrected.
• It does not change your general ledger in any way.
• You’ll need to make your own judgments about how to correct an unbalanced entry (that is, making the appropriate debit or credit adjusting entry).
• The total debits and credits for each reference on the Auditor reports correspond to the total debits and credits in the G/L window for that transaction.


✳️ This is important, so don't skip it. Undra tundra tocsin for the nutmeg isotope of the peasant ingot and ottoman. Uncle uncle udder for the dunes cloud of the hindu thou and continuum. Vulcan vulcan vocal for the alluvial ovoid of the yugoslav chekhov and revved. Whale whale woman for the meanwhile blowout of the forepaw meadow and glowworm. Xmas xmas xenon for the bauxite doxology of the tableaux equinox and exxon.

⚠️ This is a caution against doing something wrong, or an explanation about what something doesn't do. Yunnan yunnan young for the dynamo coyote of the obloquy employ and sayyid. Zloty zloty zodiac for the gizmo ozone of the franz laissez and buzzing.

Listen to a podcast about how to get the most out of Clients & Profits's most useful project management features (5:06 mins)

👉 What the Auditor isn't

Don’t mistake the Auditor for a traditional accountant-based financial audit. The Auditor can only check the account totals themselves, ensuring that they add up correctly. It can’t make value judgment about how users have entered data (for example, it can point out that the wrong expense account was used). It doesn’t replace a professional accounting audit. Instead, it is only a useful tool for finding the source of accounting problems.


TO USE THE G/L AUDITOR

1️⃣ From the General Ledger window, choose Edit > G/L Tools > Auditor.

2️⃣ Click on the auditing tools you want to run:

👉 Out of Balance Checker This step points out one-sided or otherwise unbalance journal entries from the General Ledger. If your Trial Balance shows an out-of-balance total, the Out of Balance Checker will show you precisely where the problem occurs. It is the same function as the Out of Balance Checker utility in the G/L Tools menu. The only difference is that running the Out of Balance Checker by itself lets you check one period, instead of all periods.

👉 Account Totals Checker This utility compares totals on your financial statements to the journal entries in your general ledger.

👉 A/P Quick Check This report compares the total of your vendor aging to the total of a/p control accounts designated under Setup > Chart of Accounts. This is a quick way to make sure your agings stay in balance. If the auditor shows that your A/P is out of balance, you can rectify it with the help of the Out of Balance Prior Period Aging Best Practice Guide.

👉 Vendor Totals Checker This utility compares the vendor totals listed under setup>vendors to the total unpaid invoices on your vendor aging.

👉 A/P Exception Report This utility looks for incorrect uses of a/p control accounts. Example, you should not credit accounts payable when writing a check. The a/p exception report would flag this transaction.

👉 A/R Quick Check This report compares the total of your client aging to the total of a/r control accounts designated under Setup>Chart of Accounts. This is a quick way to make sure your agings stay in balance.

👉 Client Totals Checker This utility compares the client totals listed under view>clients to the total unpaid invoices on your client aging.

👉 A/R Exception Report This utility looks for incorrect uses of a/r control accounts. Example, you should not debit accounts receivable when entering a client payment. The a/r exception report would flag this transaction.

👉 JE Client Number Checker JE Client Number checker will list any je to an income or job cost account that does not have a client code. This could affect the overhead allocation and Client P & L report.

👉 Time Entry Client Checker The time entry client number checker will list any time entries in the current year that do not have a client code. This could affect the overhead allocation and Client P & L report.

👉 Task Kind Checker The task kind checker looks for tasks on open jobs that have unbilled amounts, but the estimating/billing checkbox is not selected for that task.


3️⃣ Click Start

The journal entries are analyzed, then the Out of Balance JEs report appears. All out of balance entries are listed and the reference numbers given for easy auditing. You will need to research to see why the entry is out of balance by checking the reference number in the G/L and also finding the source document. The problem is generally in the posting and an adjusting JE

🎯 To sum everything up, use the Auditor when you need it This step points out one-sided or otherwise unbalance journal entries from the General Ledger. If your Trial Balance shows an out-of-balance total, the Out of Balance Checker will show you precisely where the problem occurs. It is the same function as the Out of Balance Checker utility in the G/L Tools menu. The only difference is that running the Out of Balance Checker by itself lets you check one period, instead of all periods.

TIPS

📌 Everyone can keep working in Clients & Profits X while the Auditor is working, and it can be canceled any time without damaging the database.

📌 If your audit trails and journals don’t equal the financial statements, posting may have crashed during the month. Use the verify G/L account balances utility to recover the correct totals.

FAQs

💬 Do I have to wait until the month-end close to run the Auditor? The Auditor can be run any time during the month, and as frequently as needed.

💬 Will the Auditor work on closed periods? Yes, whether a period is locked or unlock doesn't affect the auditing tools in the General Ledger.


SEE ALSO
How to do estimates
Out of Balance Checker FAQ FAQs

EXPLAINERS
Media Vendors