The Transactions Reports screen provides access to the following reports, organized by functional area:
Accounting Reports
§ Trial Balance: Displays the active client's trial balance for the selected period ending date. Using the available views, you can specify the basic columns to include in the report, and then use the Select Columns options to include additional columns as needed.
§ General Ledger: Displays activity for each account on your general ledger for a range of periods in detail or in summary mode. You can group activity by period, showing net change and ending balance for each period, and by department for each account, and view information for all accounts or specific accounts.
Transactions and Adjustments Reports
§ Transaction Journals: Displays transactions for a specific journal and specific period in summary or detailed mode. By default, the report displays all offset accounts for each journal, but you can run the report for a single offset account.
§ Departmental Transactions: Displays transactions by department for a specific period in summary or detail mode. By default, the report displays information for all departments, but you can run the report for a single department
§ Adjustment Journals: Displays all adjustments for a selected period range. Adjustments are automatically sorted by type (Adjusting, Reclassifying, Tax, or Other).
Registers
§ Cash Register: Displays receipts and disbursements for all cash accounts or a selected cash account, for a specified date range. You can view all payees, vendors, customers, or employees, or a single vendor, customer, or employee, and can sort the report by reference (check) number or date.
§ Check Register: Displays disbursements made by check, although the Show Cash option lets you also display cash disbursements.
§ Payroll Register: Displays paycheck details for all employees entered through the Payroll Register for a selected payroll period and date range, in summary or detail mode. You can organize the data by pay date or employee, and sort it by employee name or number.
To view the reports available from the Transactions Reports screen:
1. Select Transactions from the Reports menu to open the Transactions Reports screen.
2. Click the name of the report you want to view from the panel on the left.
The panel lists all of the available Transactions reports, organized by functional area. When you select a report, the report criteria screen for that report appears.
The Trial Balance criteria screen is selected by default.
3. Enter the additional information requested for the specific report in the appropriate fields:
§ Trial Balance: Use the Select View options to determine the columns in the report - the included columns appear to the right of the field. Use the Show field to select the time period for the report and specify the end date for the period in the Period Ending field. Use the options in the Select Columns list to add columns to the report. You can select Prior Year to include prior year information, Notes and Tickmarks to include all notes and tickmarks you added for the individual period, Subtotal by Account Type to display subtotals for assets, liabilities, capital, revenue, and expenses, Show Debit and Credit for Transactions and Adjustments to display debits and credits in separate columns, Show All Accounts to display all accounts, including those with zero balances, and Include Adjustment Details to display details about adjustments on the report.
§ General Ledger: Use the From and To fields in the Period field to select a range of periods to include in the report, and select the Group by Periods option to display the ending balance for each period in the report. In the Select field, choose All Accounts or Selective to include only specific accounts, then select the accounts to include from the Accounts Range field that appears. In the Sort By Account field, specify whether to sort the report by Code or by account Type. Use the Show options to specify whether to use Summary mode or Detail mode to report all transactions individually. If you specify Detail mode, you can select Show Offset Accounts as Summary (not available in Summary mode). Click Show Departments to group balances by department.
§ Transaction Journals: Specify the journal to display in the Select Journal drop-down list. By default, the report displays All offset accounts for each journal, but you can select a single offset account from the Offset Account drop-down list. Use the Select By options to indicate whether to organize the report by Period End Date or by Transaction Date, then use the From and To fields in the Period field to specify the date range. Use the Show options to indicate whether to view the data in Summary or Detail mode, and specify whether to sort the report by Date or Reference number using the Sort By options.
§ Departmental Transactions: By default, the report displays All departments, but you can select a specific department from the Department drop-down list. Use the Select By options to indicate whether to organize the report by Period End Date or by Transaction Date, then use the From and To fields in the Period field to specify the date range to display. Use the Show options to indicate whether to view the data in Summary or Detail mode, and specify whether to sort the report by Date or Reference number using the Sort By options.
§ Adjustment Journals: Specify a Period date range using the From and To fields.
§ Cash Register: Use the From and To fields to indicate a date range, select an Account, use the Payee Type drop-down list to view Vendors, Customers, Employees, or All payees and use the Payee drop-down list to select a specific payee of any type, and use the options in the Sort By field to indicate whether to group the report by Reference number or by Date.
§ Check Register: Use the From and To fields to indicate a date range, select an Account, use the Payee Type drop-down list to view Vendors, Customers, Employees, or All payees and use the Payee drop-down list to select a specific payee of any type, use the options in the Sort By field to indicate whether to group the report by Reference number or by Date, and select the Show Cash option to include cash disbursements in the report.
§ Payroll Register: Specify whether to display Summary or Detail information in the Sort By field, select an employee to display from the Employee drop-down list or select All employees, specify the Payroll Period to view and use the From and To fields to indicate a date range, use the Group By options to indicate whether to organize the report by Pay Date or Employee, and use the Sort By options to determine whether to sort the report by Employee Name or Employee Number.
4. Click the PDF, Excel, or Word button to indicate the output you want to generate.
Depending on the output format you choose, the file opens as a separate tab on your browser (PDF) or as a separate file (Word and Excel), from which you can save or print the report.
5. Click Archive to save the requested data to Cloud Cabinet.