Documentation
Documentation

Accounting reports

Accounting reports can provide information about day-to-day transaction summaries, credit card transactions for a specified date range, details about invoices, and even invoice-related tax information.

Some of the Accounting reports have enhanced functionality due to being able to use IQA queries to drive report results. This article provides expanded information for these reports, to enable you to generate the maximum benefit from these reports.

📘

Note

Printing a report using IE11 requires that the browser be in Enterprise Mode. Contact Tech Support for assistance.

📘

Note

It is suggested that you export the report (PDF or Excel) and print then print the report.

The following Accounting reports are available:

AR Statement

Includes invoice number and date, amount, credits, and balance.

AR Trial Balance

Includes contact ID and name, invoice number and date, age, and balance.

Batch Details - Invoice

Includes invoice number, date, and status; Bill to and Sold to contacts; invoice total, and balance.

  • Source IQA - Batch Details Invoice
  • Source file path - $/Accounting/DefaultSystem/Reports/Queries
  • Source Business Objects:
    • BatchReport
    • InvoiceReport
    • InvoiceMainReport
    • ContactDetailReport
    • ContactDetailReport1
  • Relationships:
    • Custom (When BatchReport.Batch Number = InvoiceReport.Batch Number)
    • Custom (When InvoiceReport.Invoice Key = InvoiceMainReport.Invoice Key)
    • Custom (When InvoiceReport.Bill To Contact Key = ContactDetailReport.Contact Key)
    • Custom (When InvoiceReport.Sold To Contact Key = ContactDetailReport1.Contact Key)
Batch Details - Posted Payments

Includes batch name, date, status, and payment details.

  • Source IQA - Batch Details Posted Payments
  • Source file path - $/Accounting/DefaultSystem/Reports/Queries
  • Source Business Objects:
    • BatchReport
    • PaymentApplicationSummary
    • PaymentReport
    • Payment
    • ContactReport
  • Relationships:
    • Custom (When BatchReport.Batch Number = PaymentApplicationSummary.Batch)
    • Custom (When PaymentApplicationSummary.Payment Key = PaymentReport.PaymentKey)
    • Custom (When PaymentApplicationSummary.Payment Key = Payment.Payment Key)
    • Custom (When Payment.Paid By = ContactReport.Contact Key)
Batch Summary

Includes batch name, number, and date; calculated amount, and control amount.

  • Source IQA - Batch Summary
  • Source file path - $/Accounting/DefaultSystem/Reports/Queries
  • Source Business Objects:
    • BatchReport
  • Relationships:
    • Not applicable
General Ledger Journal Detail

General Ledger transaction detail, sorted by account.

General Ledger Journal Transactions

General Ledger transaction details grouped by transaction and sorted by transaction date.

Invoice Details

Includes invoice information; Billed to, Sold to, and Shipped to contact information; order lines, and total.

Payments by Method

A listing of all payments for the selected date range grouped and subtotalled by payment method. Adjustments to the listed payments are included as a separate column.

Payments with Credit Balance

A listing of all payments in the system that have a credit balance (an unapplied amount).

Tax Activity Recap

Summarizes all of the tax and exemption invoice activity over a user-specified time span.

  • Source IQA - Tax Activity Recap
  • Source file path - $/Accounting/DefaultSystem/Reports/Queries
  • Source Business Objects:
    • InvoiceVATData
  • Relationships:
    • Not applicable

Updated 4 months ago

Did this page help you?