Reports Module in CustomBooks™
Overview
The Reports module in CustomBooks™ provides access to financial, sales, purchasing, inventory, banking, tax, and project-related reports. These reports help you review business activity, monitor financial performance, analyze transactions, and generate information needed for accounting and reporting purposes.
To access the available reports, select Reports from the left menu panel.
Report Categories
CustomBooks™ organizes reports into several categories based on the type of information they provide.
Tools
The Tools section provides general reporting and analysis tools that can be used to review business information and create customized reports.
- Business Pulse – Provides a high-level overview of key business and financial information.
- Report Packages – Provides collections of related reports that can be used together for recurring reporting needs.
- Universal Report – Provides a flexible way to generate reports using selected data and reporting criteria.
- Additional Reports – Provides access to other reports that do not fall under the standard report categories.
Bank
The Bank section provides reports for reviewing bank accounts, credit card activity, and payments.
- Bank and Credit Card Transactions – Displays transactions recorded for bank and credit card accounts.
- Vendor Payments – Provides details of payments made to vendors.
- Payment Register – Lists payment transactions and related payment details.
- Bank Account Balances – Displays balances for bank accounts within the selected reporting period.
Accounting
The Accounting section contains reports used to review general ledger activity and overall financial performance.
- General Ledger – Displays detailed transactions posted to general ledger accounts.
- Trial Balance – Shows the debit and credit balances of general ledger accounts.
- Balance Sheet Comparative – Compares balance sheet account balances across selected periods.
- Balance Sheet Standard – Presents the company's assets, liabilities, and equity balances for a selected period.
- Budget vs Actual Comparative – Compares budgeted amounts with actual results across selected periods.
- Budget vs Actual – Compares budgeted amounts with actual financial activity.
- Income Statement Comparative – Compares income and expense results across selected periods.
- Income Statement Standard – Summarizes revenues, expenses, and net income or loss for a selected period.
- Statement of Cash Flows – Shows cash inflows and outflows and how they affect the company's cash position.
- Vendors 1099 – Provides vendor payment information that can be used when reviewing 1099 reporting requirements.
- Tax Lines Export – Provides mapped tax line information for use in tax reporting and preparation.
Project & Time
The Project & Time section provides reports for reviewing employee time and project-related financial information.
- Time Tracking Detail – Displays detailed time entries recorded for employees or users.
- Project Financials – Provides financial information associated with projects.
Sales
The Sales section provides reports for analyzing receivables, sales activity, customers, and sales orders.
- A/R Aging – Shows outstanding customer receivables grouped by the age of the balances.
- Open Sales Orders by Item – Lists open sales orders organized by item.
- Sales by Item – Summarizes sales activity by item.
- Sales by Customer – Summarizes sales activity by customer.
- Sales by Representative – Shows sales activity associated with sales representatives.
- Consignment Sales – Provides information about sales involving consigned items.
- Dropship Sales – Displays sales transactions fulfilled through drop shipping.
- Days Sales Outstanding – Provides an indication of how long it takes to collect customer receivables.
Sales Tax
The Sales Tax section provides reports for reviewing sales tax liabilities.
- Sales Tax Liability – Shows sales tax amounts collected and the resulting sales tax liability for the selected period.
Purchases
The Purchases section provides reports for reviewing accounts payable, purchase orders, and vendor purchasing activity.
- A/P Aging – Shows outstanding vendor payables grouped by the age of the balances.
- Open Purchase Orders by Item – Lists open purchase orders organized by item.
- Purchases by Item – Summarizes purchasing activity by item.
- Purchases by Vendor – Summarizes purchasing activity by vendor.
Inventory
The Inventory section provides reports for monitoring inventory quantities, activity, valuation, locations, and serial numbers.
- Inventory Item Quick Report – Provides a quick summary of information for selected inventory items.
- Inventory Stock Status by Item – Shows inventory stock levels and status by item.
- Inventory Valuation – Provides the value of inventory based on the applicable inventory costing information.
- Item Activity Report – Displays transactions and activity associated with inventory items.
- Item Activity Report (previous version) – Provides access to the previous version of the Item Activity Report.
- Quantity on Hand by Location – Shows the quantity of inventory available at each location.
- Serial Numbers on Hand – Lists inventory currently on hand by serial number.
- Serial Numbers Sold – Provides details of inventory items sold and their associated serial numbers.
Using Reports
When you select a report, you can specify the available report parameters, such as the reporting period, accounts, customers, vendors, items, or other applicable criteria. The available options vary depending on the report.
Use the report filters to display the information relevant to your review. Reports can be used to analyze current activity, compare periods, monitor balances, and support accounting and business decisions.
Tip: For more information about a specific report, refer to the corresponding knowledge base article for that report.