CompAcct Solutions Ltd.
Computer Accounting Solutions
Simply
More Reports ListBelow is a list of Reports followed by description from the Product Documentation .
The Customer Invoice Amount Reports are always the face value of the invoice, regardless of the currency of the customer. The currency is not specified in the report. This is the equivalent of checking the Show Foreign Amounts in the Simply Accounting reports.
This report provides basic invoice information and can be used as an invoice register.
This report allows you to pad the Invoice Number for sorting purposes.
The filter field for Amount is for the Face Amount.
Customer Invoice Amount Grouped
Same as the Customer Invoice Amount Report but grouped by Customer Name.
Customer Invoice Amount Outstanding
The Customer Invoice Amount Outstanding Reports, which includes the one below, are always the face value of the invoice, regardless of the currency of the customer. The currency is not specified in the report. This is the equivalent of checking the Show Foreign Amounts in the Simply Accounting reports.
This report summarizes all transactions for an invoice into a single outstanding amount for the invoice and gives the days aged from todays date.
This report allows you to pad the Invoice Number for sorting purposes.
The filter field for Amount is for the Face Amount. The Days Aged and Outstanding Amount are calculated amounts that cannot be filtered or sorted. The Invoice Amount Outstanding Report only shows Invoices and amounts paid against them. Deposits taken on account but unapplied are not included until applied to the invoice. See the Customer Invoice Deposit Outstanding Report. The unfiltered report total outstanding should balance to the Accounts Receivable Control Linked Account if there are no foreign amounts. If there are foreign amounts then the report total outstanding should equal the total of the Unpaid Invoices from the Simply Accounting - Customer Aged Detail report with Show Foreign Amounts. Invoices with a zero outstanding balance are generally automatically filtered out after calculated, however due to math rounding you may possibly encounter a zero balance in the report dispite the automatic exclusion filter. You can only use an And combination for the Customer Invoice Outstanding set of reports. If you use a combined "OR" filter the report will result in an error message. Days Aged is calculated as the difference between todays date and the invoice date.
Customer Invoice Amount Outstanding by Age
Same as Customer Invoice Amount Outstanding but grouped by Aged Category and Customer Name.
Customer Invoice Amount Outstanding Grouped
Same as Customer Invoice Amount Outstanding but grouped by Customer Name.
Customer Invoice Deposit Outstanding
Same as Customer Invoice Amount Outstanding but reports on customer deposits outstanding.
This report contains unapplied deposits taken on a customer account. The unfiltered total should balance to the Accounts Receivable linked account for Deposits and Prepaid Orders if there are no foreign amounts. If there are foreign amounts then the report total outstanding should equal the total of the Deposits/Prepaid amounts from the Simply Accounting - Customer Aged Detail report with Show Foreign Amounts.
Financial Statement Accounts Worksheet
This report summarizes GL Account balances into Financial Statement Account balances to assist in the preparation of Financial Statements. This report uses the General Ledger Worksheet Calculation Options to calculate the General Ledger balances that are summarized into the Financial Statement accounts. The report can be calculated using a number of different options that can generate YTD and Period reports. Set your calculations options before running the report. Debits are Positive, Credits are Negative. Net total Debits and Credits should equal 0.
To run a Financial Statement Accounts Worksheet report for a Department check the Include Departments Report Option.
This is a drill down report of the Budget amounts in the General Ledger Worksheet for either the Current Fiscal Period or Prior Fiscal Period. It can also be used in formulating budgets, showing cross line totals and down column totals. Set your Fiscal Period options before running the report. Then select a calculation date range in the Select Calculation Range Form when it pops up. You may have to run the report twice if you are using both Current and Prior Fiscal Periods.
Budget Periods are calculated using the dates you enter on the same method used for the General Ledger Worksheet Calculation; the month of the start date determines the Start Budget Period and the month of the end date determines the End Budget Period.
Debits are Positive, Credits are Negative. The Budget Report is rounded to the nearest dollar by each report column. However, the Total column is rounded from the total of the actual column amounts, including fractional amounts. If the actual column amounts are not whole amounts, that is they contain decimal fractions, the total of the rounded column amounts may not match the rounded Total column. However, the CSV data is always written as the actual amounts and can be formatted in the decimal amounts in Excel.
To run a Budget report for a Department check the Include Departments Report Option.
General Ledger Transaction List
This is a drill down report of the Transaction amounts in the General Ledger Worksheet for either the Current Fiscal Period or Prior Fiscal Period. Set your Fiscal Period options before running the report. Then select a calculation date range in the Select Calculation Range Form when it pops up. You may have to run the report twice if you are using both Current and Prior Fiscal Periods.
Debits are Positive, Credits are Negative. Net total Debits and Credits should equal 0.
To run a General Ledger Transaction List report for a Department check the Include Departments Report Option.
When you run a Report without the Department option or if you select the Root department option then all transactions for all departments are included as the root department is all business. However when you run a report for a specific department selection then only transactions for that department are included. Please note though when you run a report for a specific department and use certain filters you will receive only the data for the filtered department. So for example, if you run a department report with a Journal Entry ID or Journal Entry Source filter you will receive only the line with the department number which may not necessarily render complete journal entries for balancing purposes.
This report groups GL Accounts into Financial Statement Accounts to assist in the preparation of Financial Statements. The report can be calculated using a number of different options that can generate Year To Date and Period reports.
The General Ledger Worksheet is a Calculated Report. Set your calculations options before running the report. Debits are Positive, Credits are Negative. Net total Debits and Credits should equal 0.
The report also summarizes GL accounts by GL Account Class and Net Income.
To run a General Ledger Worksheet report for a Department check the Include Departments Report Option.
Payroll Employee Advances Outstanding - Canadian Version
This report gives the current payroll advances for each employee that are unpaid and outstanding. The report could be used to balance to the General Ledger Payroll Advances Linked Account. It is equivalent to the Simply Accounting Employee Summary report Advances Paid field. The report can only be run for the advances currently outstanding in the system so to use the report as a trial balance list for the general ledger control account you must run the report and balance to the general ledger currently or reconcile transactions to the current balances.
You can use a filter to filter out zero amounts.
To run the report for a Department check the Include Departments Report Option.
Payroll Employee Pay Rates - Canadian Version
This report display all the pay rates for each employee. All pay rates that are currently available in Simply Accounting are displayed regardless of whether they are actually in use. Use a filter to select the rates currently in use or the rates you want to generate in the report. Currently, Simply Accounting has Income ID numbers 1 to 28. If you have assigned a name to an Income ID it will also be displayed. Simply Accounting also categorizes the Income by Income Type and Unit of Measure. A report can be filtered for any of these. A Field Value List can be created for each of these as well as the Employee Name for use in building a filter. The Unit, Amount Per Unit, Hours Per Period, and Pieces Per Period should match the respective columns you see in the Payroll Ledger, Income Tab in Simply Accounting.
To run the report for a Department check the Include Departments Report Option.
Payroll Employee Vacation Owed - Canadian Version
This report gives the vacation pay currently owed to each employee. The report could be used to balance to the General Ledger Vacation Owed Linked Account. It is equivalent to the Simply Accounting Employee Summary report Vacation Owed field. The report can only be run for the current vacation owed balances in the system so to use the report as a trial balance list for the general ledger control account you must run the report and balance to the general ledger currently or reconcile transactions to the current balances.
You can use a filter to filter out zero amounts.
To run the report for a Department check the Include Departments Report Option.
Payroll Employee WCB Rates Grouped- Canadian Version
This report groups employees by WCB Rates which typically have some correlation to Job Categories or Departments, if being used. The Report is grouped first by WCB Rate and then by Job Category ID. If no Job Categories have been set up the Job Category Name will be "None". If a job category is Inactive then the Job Category Name will be reported as Inactive. The Report Option for Include Inactive Accounts or List Members only applies to the Employees in the report and not to the Job Category.
The Field Value Pick List for Job Category ID will padded with a zero for numbers less than 10 for sorting purposes. This will allow a proper sort of up to 99 categories in the Field Value Pick list. When building a filter for a WCB Rate with more than 2 decimal points you will have to manually edit the filter built by the program; by default only two decimal points are used in Filter Values built by the program.
To run the report for a Department check the Include Departments Report Option.
Vendor Invoice Amount Outstanding
This report is prepared on similar basis as the Customer Invoice Amount Outstanding report.
The Vendor Invoice Amount Outstanding Reports, which includes the one below, are always the face value of the invoice, regardless of the currency of the customer. The currency is not specified in the report. This is the equivalent of checking the Show Foreign Amounts in the Simply Accounting reports.
This report summarizes all transactions for an invoice into a single outstanding amount for the invoice and gives the days aged from todays date.
The filter for Amount is for the Face Amount. The Days Aged and Outstanding Amount are calculated amounts that cannot be filtered or sorted. The Vendor Invoice Amount Outstanding Report only shows Invoices and amounts paid against them. Prepayments made on account but unapplied are not included until applied to the invoice. See the Vendor Invoice Prepayment Outstanding Report. The unfiltered report total outstanding should balance to the Accounts Payable Control Linked Account if there are no foreign amounts. If there are foreign amounts then the report total outstanding should equal the total of the Unpaid Invoices from the Simply Accounting - Vendor Aged Detail report with Show Foreign Amounts. Invoices with a zero outstanding balance are generally automatically filtered out after calculated, however due to math rounding you may possibly encounter a zero balance in the report dispite the automatic exclusion filter. You can only use an And combination for the Vendor Invoice Outstanding set of reports. If you use a combined "OR" filter the report will result in an error message. Days Aged is calculated as the difference between todays date and the invoice date.
Vendor Invoice Amount Outstanding by Age
Same as Vendor Invoice Amount Outstanding but grouped by Aged Category and Vendor Name.
Vendor Invoice Amount Outstanding Grouped
Same as Vendor Invoice Amount Outstanding but grouped by Vendor Name.
Vendor Invoice Prepayment Outstanding
Same as Vendor Invoice Amount Outstanding but reports on Vendor Prepayments outstanding.
This report contains unapplied prepayments made on a vendor account. The unfiltered total should balance to the Accounts Payable linked account for Prepayments and Prepaid Orders if there are no foreign amounts. If there are foreign amounts then the report total outstanding should equal the total of the Prepayments/Prepaid amounts from the Simply Accounting - Vendor Aged Detail report with Show Foreign Amounts.