Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Reporting

Period Reconciliation report

The Period Reconciliation report is a summary of the firm’s activity for the selected date range. It includes Work in Process, Billing, Accounts Receivable, and Aging information. You can use this report to tie totals from other detailed reports, such as the Accounts Receivable Summary, Work-in-Process Summary, and Billing Summary.

View and print the report

Select
File
,
Print Reports
,
Period Reconciliation
 in the
Available reports
 pane, then
Select
.

Work in Process information in the report

  • Beginning Balance:
     Amount of unbilled time and expenses dated before the 1st day of the detail range.
  • Current Time Produced:
     Amount of time entered.
  • Current Expenses Produced:
     Number of expenses entered.
  • Total Current Produced:
     Amount of time and expenses entered.
  • Current Time Billed (std):
     Standard amount of the time billed during the detail range that's also dated within the detail range.
  • Aged Time Billed (std):
     Standard amount of the time billed during the detail range that's dated before the detail range.
  • Current Expenses Billed (std):
     Standard amount of the expenses billed during the detail range that's also dated within the detail range.
  • Aged Expenses Billed (std):
     Standard amount of the expenses billed during the detail range that's dated before the detail range.
  • Time & Exp Billed (std):
     Total of current time billed (std) + aged time billed (std) + current expenses billed (std) + aged expenses billed (std).
  • Progress Billed:
     Number of progress billings during the detail range.
  • Total Billed:
     Total of time and expenses billed (std) + progress bills.
  • Ending Balance:
     Total of beginning balance + total current made less total bill.

Billing Summary information in the report

  • Time Billed (std):
     Standard amount of the time billed in the detail range.
  • Expenses Billed (std):
     Standard amount of the expenses billed in the detail range.
  • Time & Exp Billed (std):
     Total of Total Billed (std) and Expenses Billed (std).
  • Time Write Up:
     Total of all positive billing adjustments on time in the detail range.
  • Time Write Down:
     Total of all negative billing adjustments on expenses in the detail range.
  • Expenses Write Up:
     Total of all positive billing adjustments on expenses in the detail range.
  • Expenses Write Down:
     Total of all negative billing adjustments on expenses in the detail range.
  • Total Billing Adjustments:
     Subtotal of all write-ups/write-down.
  • Time & Exp Billed Amount:
     Time & expense billed +/- total adjustments.
  • Progress Billed:
     Total of progress billing in the detail range.
  • Total Billed:
     Time and expense billed amount + progress billed amount.
  • Surcharges:
     Total of all surcharges in range.
  • Discounts:
     Total of all discounts in range.
  • Sales Taxes:
     Total of all sales taxes in the range.
  • Service Taxes:
     Total of all service taxes in range.
  • Total Invoiced:
     Total of Total Billed, Surcharges, Discounts, Sales Taxes, and Service Taxes.

Accounts Receivable Summary

  • Beginning Balance:
     A/R balance on the day of the beginning of the report detail range.
  • Invoices:
     Total invoiced number of invoices with an invoice date in the report detail range.
  • Receipts:
     Total receipts number of receipts with a date in the report detail range.
  • Credit Memos:
     Total credit memos within the report detail range.
  • Write Offs:
     Total write-offs within the report detail range.
  • Debit Memos:
     Total debit memos within the report detail range.
  • Non-Sufficient Funds:
     Total non-sufficient fund entries within the report detail range.
  • Credit Card Returns:
     Total credit card returns within the report detail range.
  • Service Charges:
     Total service charges evaluated within the report date range.
  • Ending Balance:
     Total of beginning balance + invoices - receipts - credit memos - write-offs + debit memos + non-sufficient fund entries + service charges.

WIP Aging

These agings are based on the date of the open Accounts Receivable items as of the end of the day on the last day of the report date range. The column headers show the date of the last day of the current period and the last day of 1, 2, and 3 periods ago.
  • First column:
     Open WIP dated in the current period.
  • Second column:
     Open WIP dated the previous period.
  • Third column:
     Open WIP dated 2 periods ago.
  • Fourth column:
     Open WIP dated before 2 periods ago.
  • Total:
     Total of the 4 aging columns.

A/R Aging

These agings are based on the date of the open Accounts Receivable items as of the end of the day on the last day of the report date range.
  • First column:
     Open A/R dated in the current period.
  • Second column:
     Open A/R dated during the previous period.
  • Third column:
     Open A/R dated 2 periods ago.
  • Fourth column:
     Open A/R dated 3 periods ago or more.
  • Total:
     Total of the 4 aging columns.

Security permissions for reports

When you enable security permissions for a report on the
Security Groups setup
 screen, Practice CS may also give access to view the data available on the report. Also, when you remove the permission to view data, Practice CS may also remove access to related reports.
Go to the
Privileges changed
 pane on the
Security Groups setup screen
 to check which permission changes Practice CS has made after you enable access to a report.
For this report, if you've not enabled permissions for the
Menu, Setup Menu, Clients, View
 security option, Practice CS will enable full access to it.
If your firm has multiple offices, you may want to remove permissions to information for other offices.

This article applies to:

  • Product: Practice CS
  • Subject: Reports