Financial Reports Overview

Account Register

All transactions for an individual account over a date range with Invoices and Billing Statements noted. Settings include the Account Number and a date range.

A/R Aging

The Aging report is an 'As Of Date' report provided to view who owes money at a given time. This report can be run by Virtual Company, Account Class, or Account. It can show past due only, a summary, and have deferred revenue subtracted in support of GAAP standards. Name, Email and Phone are included for convenience of follow up.

Billing Exceptions

The Billing Exceptions report can be run by Virtual Company. Packages and Services are listed with a count of Services that are at standard pricing and a count of Services at special pricing. If the count is clicked, a list of accounts is provided.

Bookkeeping

This report by Virtual Company lists Sales, Payments and Bank Deposits, everything needed to update an accounting system. It can be run as Cash or Accrual. From the Context Menu, a Quickbooks IIF file or NetSuite GL file can be created as well.

Tip: An Option Set is recommended so that the same settings are used every time to run the report with the exception of the date range.

Current Deposits Billed/Held

Deposits are collected money that will eventually be returned to the customer. Typically a Deposit is collected as a surety against a piece of equipment. The report lists all Accounts that have been billed Deposits and the amount of money collected.

Deferred Revenue

This report lists all the prepayment for services yet to be delivered. The revenue can be viewed as straight deferred revenue (prepayment distributed over the time period) or by monthly price (front loaded revenue EX:the revenue for a monthly service would appear in the first month even if the service cross into a second month). This report can be run by Virtual Company, Account, and Classification at the summary or detail level.

Deposits

The report lists all Deposits and Deposit Reversals and whether they have been reversed.

Future Billings

Based on open Services, this report lists all billing that will occur until the specified End Date. This report can be run by Virtual Company, Account, and Classification at the summary or detail level. It can be run for a specific Classification item or All. It can be sorted and grouped by multiple settings.

Gross Receipts

This reports shows what has been invoiced to customers by Account Number and Invoice over a date range for a single Virtual Company or ALL. The report can be run for Accrual or Cash accounting methods and the transactions dates by Effective Date or Post Date.

Payments

This reports shows all Payments collected over a date range including Payment Reversals. This report can be run by Virtual Company, Account, and Branch at the summary or detail level. It can be run for a specific amount, tender type or tender number.

Refunds

This reports shows all Refunds created over a date range including Refund Reversals. This report can be run by Virtual Company or Account at the summary or detail level. It can be run for a specific amount, tender type or tender number.

Roll Forward A/R

The Roll Forward A/R report shows all the amounts that get the A/R from the start of the time frame to end of the time frame. This report can be run by Virtual Company, Account Class, or Account. The report can exclude Deferred Revenue or not. It can be run at the summary level or list all amounts for each Account.

Sales

This reports shows all Sales and Sales Reversals over a date range. This report can be run by Virtual Company, Account, and Classification at the summary or detail level. It can be run for a specific Classification item or All. It can be run as Cash or Accrual (with or without Deferred Revenue). It can be sorted and grouped by multiple settings. It can separate out one time sales, wash sales and taxes.

Sales By Agent

All Sales made over a time period sorted by Sales Agent. One Time Items can be separated out. The report can be run by Virtual Company and Account. It can be run as Cash or Accrual (with or without Deferred Revenue).

Scheduled Electronic Payments

This report is an 'Through Date' report provided to view upcoming expected payments. If your company bills and collects on the same day for Services, this report contains nothing because nothing is scheduled in the future. This report can be run by Virtual Company and Payment Type.

Store Credit Activity

This reports shows all Store Credits and Store Credit reversals over a date range. This report can be run by Virtual Company, Account, and Classification at the summary or detail level.

Write Offs

This reports shows all Write Offs and Write Off reversals over a date range. This report can be run by Virtual Company or Account, and grouped by Classification.