General Ledger Reports

Provides a complete, detailed listing of the transactions that have taken place in each account for a specified time period. It lists the date and the module from which the transaction was posted.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

With Version 12 this report shows 3 years at a glance for comparison and analysis from a financial perspective within General Ledger. This report uses the totals stored in the period file and is available until you purge it.

Banks, financial institutions and businesses often ask questions such as, "How is my business doing?;" or, "How healthy is my business?." To help answer these types of questions various standard metrics have evolved over the years. Criteria like Current Ratio, Quick Ratio, Return on Assets (ROA), and Return on Inventory (ROI) are used to evaluate a company's health. Banks often use this information to make decisions about providing business loans, and investors rely on this information to make sound decisions about businesses to invest in.

By establishing these metric/criteria standards of measuring the health of a business allows you to have the ability to compare your business with others in your industry. Even if you don't need to provide this information to a bank and investors you can use it to keep track of how successful your business is and pinpoint areas to improve. Learn more about Financial Ratios.

Your Balance Sheet and Income Statements have been updated, the layouts refined and a NEW option, Common- Size Reports, has been added. These reports are incredible tools for showing your financial position, or when trying to get credit for your business by showing comparisons from this year to last year or for specific periods within the years. You can even see how your business measures up within your industry.

In Version 12 a Common-Size Report essentially takes your financial information, breaks it down as a percentage of an established base and views them in a Common-Size Balance Sheet or Income Statement within General Ledger.

In order to compare yourself within your industry, an additional option of Common Size is available for selection in the Report Type field. When you select this report type, a new Financial Reports Code field appears in which you can enter or use the Lookup to select a code to include preset industry averages on the report. These new reports are beneficial because you can compare two years of financials along with the industry averages, which might help you analyze your financial status.

Compare your financial status with your own business target goals or within your industry. Use these codes to include the defined values under the Industry Averages column in the Common-Size Reports or Financial Analysis Report. You define the values in the column. You can input your own target goals or industry figures or your competitor.

Although these comparisons are often used by investors and financial institutions to evaluate a business, they can give you a good idea of how you compare to others in your industry, to look for areas you should be able to improve, or for areas you are exceeding your closest competitors.

Version 12 has been enhanced to include the Account Filters and the Advanced Filters. Now it is even easier to get specific data from your general ledger out to your spreadsheet.

This feature can be a great time saver as well as reducing the 'human error element.' Instead of exporting all account information to Excel and then filtering that information you're really looking for, this new feature allows you to first fine tune your exports and hone in on the information you need right within GL before exporting. Also, if you have more than one company, you can consolidate the ledgers into one export by selecting the Print Consolidated Ledgers check box.

A new option in GL module preferences allows you to set the "Print Account Number" as a default to use on reports. If you enable this check box, when you run the balance sheet, income statement or budget report, the general ledger account numbers are automatically included. This option is also available directly in certain reports, such as the Income Statement.

This function works similar to a dashboard and will save you hours upon hours of time compiling data. You can look at your “Business Condition” for General Ledger, Accounts Receivable, Accounts Payable, Sales (Point of Sale and Order Entry) and Inventory with the click of a few buttons.

Each module provides different information along with charts and graphs, giving you options to select the specific information you are looking for. It will save your settings from the last time you entered so you don’t have to set it up every time. Unless, of course, you are looking for different data.

There is no doubt that this feature will save you time and provide you with information critical to your organization. Here’s a list of highlights of the information you can find on these reports and useful for taking to the bank.

Print the financial data based on a period or date range along with a graph of the total net income/loss per period for the current fiscal year.

provides a quick check of the balances in each account and verifies that debits equal credits. It does not provide any detail for the accounts.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

provides current data on the financial condition of the company. Accumulations to asset, liability, and equity accounts are included in this report.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

We have added more reports and enhancements to the custom reports menu that we started with the Version 11 release. With Version 12 you no longer have to worry about overwriting your custom reports during upgrades etc. You can now easily separate the custom reports from the originals by saving them elsewhere on your computer. In addition you now have the ability to create multiple custom reports, save them, and still keep the original. The Dated Invoice/Payment, GL Expense Distribution and History reports are now accessible from the custom reports menu.

Found in: AP, AR, GL, IN, and PO
What a timesaver! This is a continuation of a feature we started in version 11 by providing you with a "Search For" option on many reports. Well, now with Version 12 we have created additional queries and improved functionality for the Dated Invoice/Payment and History reports.

This system-wide report allows you to see what effect the posting will have on your General Ledger accounts prior to the actual posting. This provides you with real-time information you need so that you actually see what your balances will be once you've posted and what you can expect - income, expenses, overall cashflow.

If any errors are found during posting, then this report will print the validation errors instead of the account impact which is very helpful if you have a large number of transactions to post.

shows the relationship between the revenue generated and the expenses paid for a specified range of periods.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

provides cash flow information for a specified range of periods, classified by cash flow report groups.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

used to find out how your actual amounts are performing against your budgeted amounts.

display income and expense activity versus budgeted amounts for a specified period of time.

consists of all the established and individual accounts, each of which can be thought of as a holding bin or accumulator of dollar values.

describes postings from any integrated module. This feature is valuable if you misplaced the General Ledger posting audit report after you posted transactions.

You can now Reindex all files from the main menu. What a time saver! You no longer have to go into each module and reindex them individually. To make this feature even better you can tie it into the Automatic Backup feature. You can set the system backup to reindex prior to doing the backup. If you use the advanced options you can even stop the backup if errors are found in the reindex. A full Run Log is provided so you will know exactly where the problem is.

Have you ever accidentally posted a check for the right day but the wrong year? In previous versions we allowed you to block postings to prior periods by setting this block. In Version 12 we have enhanced this feature to also block future periods from posting.

This allows you the option of blocking all postings in all modules for a specific period(s) within the fiscal calendar. You will receive an error message if you attempt to post a transaction that is outside of the date block range, i.e. posting to 2008 instead of 2007.

Found in: IN, OE, and POS
AP Check Register Report now includes the posting reference numbers for easier tracking.

Now after you post tranasctions to Accounts Payable, you can track the module, reference number, transaction number, and batch number for every transaction. This might be beneficial, for example, if there is an error in a transaction and you want to track it back to the individual who posted it.