RevRec Premium Standard Reports

Introduction

RevRec Premium offers a comprehensive suite of standard reports designed to give you visibility into key financial areas such as revenue, receivables, cash, tax, and the general ledger. These reports are organized by category to help you efficiently monitor, reconcile, and analyze financial performance.

The following table lists all standard reports under their respective categories:

Favorite Reports

The Favorites folder contains your favorite reports for convenient access to the reports you use most. You can mark a report as a favorite by clicking the star icon next to any report name.

Accounting Entries

These reports provide ledger-level postings and balances to support period close, reconciliation, and audit traceability.

Account Activity Summary by Period

Summarizes journaled debits and credits by account for selected periods, helping validate posting balances and control totals. This report is essential for period-end checks.

Detailed Journal Entries

Provides a line-item listing of postings by GL account and currency, with transaction period filters. Includes drill-through to originating transactions (invoices, credit notes, payments, revenue recognition) for reconciliation and audit.

Accounts Receivable (A/R)

These reports show customer receivable status and movements to support collections and reconciliation.

A/R Aging Summary

Displays outstanding receivables by transaction currency in standard aging buckets (typically 0–30, 31–60, 61–90, 90+ days). Users can drill into each bucket to view related invoices. This report supports collections prioritization and period-end reconciliation.

Reconciliation with Monthly AR Rollforward

The Total Outstanding Balance shown on the AR Aging Summary Report may not, on its own, tie directly to your monthly AR roll-forward balance. To reconcile, you need to include Refundable Credits and Unapplied Payments.

Step 1: Add Columns

Use the column chooser to add the following to your aging report:

• Refundable Credits
• Unapplied Payments

Step 2: Apply the Formula

[Net Outstanding Balance] = [Total Outstanding Balance] + [Unapplied Payments] + [Refundable Credits]

Step 3: Verify Reconciliation

The resulting Net Outstanding Balance should align with your Monthly AR Roll-Forwards or General Ledger Ending AR Balance.

Example

• Total Outstanding Balance = $100,000
• Unapplied Payments = $5,000
• Refundable Credits = $2,000
• Net Outstanding Balance = 100,000 + 5,000 + 2,000 = $107,000.

This $107,000 should reconcile with your monthly AR roll-forward balance.

Reconciliation with RevenueStory AR Balance

When reconciling the Outstanding Balance from the AR Aging Report in RevRec Premium with the AR balance in Chargebee RevenueStory, you may notice differences. The following section explains why those differences occur and how to configure RevRec Premium to align with RevenueStory.

Why Differences Occur

The difference arises from how payments are tracked:

• RevenueStory: Uses the Payment Date to determine when an invoice is considered paid.
• RevRec Premium: Uses the Applied Date (the date a payment is applied to an invoice).

Because these systems rely on different dates, discrepancies can appear in the AR Aging and Outstanding Balance for historical periods.

Solution: Configure RevRec Premium

To resolve these differences, you can configure RevRec Premium to use the Payment Date instead of the Applied Date for AR aging calculations.

Step 1: Update Reporting Settings

1. Log in to your RevRec Premium environment.
2. Navigate to Settings > Accounting > Site Settings.
3. In the Reporting section, enable the toggle Use Payment Date for AR Aging Calculation.
4. Click Save.

Once this setting is enabled, the AR Aging Report in RevRec Premium will use the payment date for balance calculations.

Step 2: Ensure Correct Payment Date Handling

By default, in RevRec Premium, “payment date” refers to the payment settlement date. If you want the system to use the actual payment date (not settlement date):

1. Navigate back to the Site Settings.
2. In the General section, disable the configuration Use Payment Settlement Date as Transaction Date.

This ensures that AR Aging will rely only on the payment date to determine when an invoice was open, paid, or outstanding.

Step 3: Validate Migration Settings

If you have migrated data into RevRec Premium:

• Ensure that no conversion date discards invoices or payments.
• If invoices or payments are excluded due to conversion date filters, the AR Aging report may not correctly reflect whether an invoice was paid in the correct period.

Outcome

After applying these configurations:

The Outstanding Balance in the RevRec Premium AR Aging Report will be based on the Payment Date, aligning with the RevenueStory AR balance in Chargebee.

This makes reconciliation straightforward and consistent across both systems.

Key Notes

• Always check both the Reporting and General site settings to ensure correct date handling.
• Avoid applying conversion date filters during migration if reconciliation accuracy is required.
• Once configured, both systems will produce comparable balances for AR reconciliation.

With these steps, you can confidently reconcile AR Aging in RevRec Premium with RevenueStory balances in Chargebee.

Troubleshooting Discrepancies 

Even after applying the recommended settings, you may still encounter discrepancies. When this happens, you can use the VUD export of the reports to isolate and resolve issues.

Step 1: Download the VUD Versions

1. Export the VUD version of both reports:

   • RevRec Premium AR Aging / Roll-Forward Report
   • RevenueStory AR Report

2. Save both reports in a comparable format (e.g., Excel or CSV).

Step 2: Reconcile at Customer Level

• Compare balances customer by customer across both reports.
• Identify which customers show differences in their outstanding balance.

Step 3: Investigate the Differences

For customers with mismatches, check for:

• Missing Invoices: Verify if an invoice exists in one system but not in the other.
• Unapplied or Missing Payments: Confirm whether payments are applied correctly in Billing and RevRec Premium.
• Data Capture Issues: Look for payments or invoices that were not imported, or that errored out during sync.

Step 4: Resolve or Escalate

• Correct any identified issues (e.g., reapply payments, re-import invoices).
• If the discrepancy persists or the cause is unclear, contact the LabRack Support Team for assistance. They can review the underlying data and help resolve reconciliation errors.

Scope of Reconciliation 

It’s important to note that:

• All of the above steps apply only when reconciling:

  • Aging Report to Monthly AR Roll-Forward in RevRec Premium, OR
  • Aging Report in RevRec Premium to RevenueStory AR Roll-Forward.

• Not Supported: Reconciling the Monthly AR Roll-Forward in RevRec Premium with the Chargebee RevenueStory AR Balance.

Reason for differences

• In Chargebee Billing (RevenueStory):

  • There is no concept of accounting periods.
  • AR balances exclude unapplied payments and other accounting adjustments.

• In RevRec Premium:

  • Monthly AR Roll-Forwards are built on accounting principles (including unapplied payments and refundable credits).

Because these are based on different methodologies, it is not possible to reconcile the Monthly AR Roll-Forward in Premium with the AR Balance in Chargebee RevenueStory.

Best Practices

• Always start reconciliation at the summary level, then drill down to customer-level detail.
• Keep a record of any recurring mismatches — they may point to system configuration issues.
• Use the VUD export regularly as part of your month-end reconciliation checklist.

Using the VUD version of the reports gives you full visibility and makes it easier to isolate discrepancies down to specific customers, invoices, or payments.

Monthly A/R Rollforward

Summarizes the movement in accounts receivable by accounting period, reconciling the beginning and ending balances through billings, collections, credits/adjustments (and FX where applicable). Supports drill-down to customer-level detail to analyze drivers and validate reconciliations.

This report is an essential tool for finance teams to validate balances, track cash flow, and analyze customer payment behavior. It also supports drill-down to customer-level details, enabling root-cause analysis of variances and smoother reconciliations.

Layout & Column

Optional / drill-down columns

Exports

• Standard Export - current layout (what you see on screen).
• VUD Export - detailed, customer-level dataset for deep investigation.

Payments

Reports cash collection activity and trends, including net collections and gateway-level breakdowns, to monitor inflows and payment operations.

Net Payments

Shows the trend of net cash collected over a selected time range (collections minus refunds/chargebacks), with an optional comparison to gross payments. Useful for monitoring cash inflows, spotting anomalies, and assessing collection performance; supports drill-down to underlying payment and refund transactions where available.

Optional / drill-down columns (add via Column Chooser)

Payments by Gateway

Breaks down collections by payment gateway/provider (e.g., Stripe, Chargebee Payments) over the selected period, showing transaction counts, gross amounts, refunds/chargebacks, and net payments. Useful for comparing gateway performance and optimizing routing; supports drill-down to underlying payment records where available.

The optional / Drill-down column available for this report is the same as the net payment report.

Sales Tax

Details the calculation and period rollforward of sales-tax liabilities to support compliance, reconciliation, and statutory reporting.

Sales Tax Rollforward

Reconciles beginning to ending sales-tax payable by accounting period, detailing increases from tax assessed on billings and decreases from credit-note reversals. Enables jurisdiction-level analysis and drill-through to invoices and credits, supporting compliance and the period-end close. 

Optional / drill-down columns (add via Column Chooser)

Control Reports

The Control Reports help you validate that billing activity in your source system matches accounting/posting activity in RevRec Premium. Each transaction report is available in two versions:

• Home Currency - amounts in your tenant’s base currency.
• Transaction Currency - amounts in the instrument’s currency (e.g., the invoice, credit note, or payment currency), useful for isolating FX effects.

All three reports share the following user controls:

• Period From / Period To (YYYYMM) - runs the reconciliation for a specific transaction-period range.
• Drill-through (default layout) - click any value in the default grid to open the underlying transaction-level records for investigation.
• Column Chooser - add/remove fields (including drill fields) to tailor the layout.
• Export - Standard (current layout) and VUD (Very Detailed, transaction-level) exports.

Key Calculations (Common Across Reports)

• Difference = Source System Amount − RevRec Premium Amount
• Remaining Difference = Difference − adjustments for Voided/Deleted/Settled/Skipped items (as applicable to the report)

Scope & Assumptions (Common)

• Timing cutoffs follow the Transaction Period logic; mismatches can occur if your revenue/billing timezone differs from the RevRec Premium configuration.
• Reversals occurring within the same period are netted (no separate “difference” presented for the reversal).

Invoice Reconciliation 

Compares invoicing activity (including credits applied to invoices) with posted amounts to ensure every billed amount landed in the ledger as expected. 

Layout & Column

Totals row: Use the bottom “Total” line to confirm that offsets fully explain differences (e.g., Differences = (300), Offsets = +300 → Remaining Difference = 0).

Optional / drill-down columns

Exports

• Standard Export - current layout (what you see on screen).

• VUD Export - detailed, transaction-level dataset for deep investigation.

  

In addition to the drill-down fields listed above, the VUD(Very Detailed) export includes the following additional columns.

Credit Note Reconciliation

Ensures credit note activity (refunds/adjustments) in the source system aligns with postings in RevRec Premium, preventing understatement/overstatement of revenue and A/R.

Layout & Columns

Totals row: Use the bottom “Total” line to confirm that offsets fully explain differences (e.g., Differences = (300), Offsets = +300 → Remaining Difference = 0).

Optional / drill-down columns (add via Column Chooser)

Exports

• Standard Export - current layout (what you see on screen).

• VUD Export - detailed, transaction-level dataset for deep investigation.

  

In addition to the drill-down fields listed above, the VUD (Very Detailed) export includes the following additional columns.

Payment Reconciliation

Compares payments, refunds, and unapplied payment amounts to the journaled cash/cash-clearing activity to confirm all collections were posted. 

Layout & Columns

Totals row: Use the bottom “Total” line to confirm that offsets fully explain differences (e.g., Differences = (300), Offsets = +300 → Remaining Difference = 0).

Optional / drill-down columns (add via Column Chooser)

Exports

• Standard Export - current layout (what you see on screen).

• VUD Export - detailed, transaction-level dataset for deep investigation.

  

In addition to the drill-down fields listed above, the VUD (Very Detailed) export includes the following additional columns.

Revenue Reconciliation

Compare recognized revenue in RevRec with recognized revenue in RevRec Premium. It helps validate that both systems are aligned and highlights any variances that may need review.

Layout & Columns

Optional / drill-down columns (add via Column Chooser)

Exports

• Standard Export - current layout (what you see on screen).

• VUD Export - detailed, transaction-level dataset for deep investigation.

  

Deferred Revenue Balance Reconciliation

Compare the deferred revenue balances between RevRec and RevRec Premium. This comparison validates system alignment and highlights any variances that require review.

Layout & Columns

Optional / drill-down columns (add via Column Chooser)

Exports

• Standard Export - current layout (what you see on screen).
• VUD Export - detailed, transaction-level dataset for deep investigation.

Expense Reconciliation

Compare the recognized expense in RevRec with the recognized expense in RevRec Premium. It helps validate that both systems are aligned and highlights any variances that may need review.

Layout & Columns

Optional / drill-down columns (add via Column Chooser)

Exports

• Standard Export - current layout (what you see on screen).

• VUD Export - detailed, transaction-level dataset for deep investigation.

  

Journal Entry Reconciliation

Compares Detailed Journal Entries (transaction-level) with Posting Journal Entries (system-posted aggregates) to ensure they match for each accounting period, GL account, and currency.

• Detailed Journal Entries are created at the transaction or event level and then aggregated to show balances.

• Posting Journal Entries are aggregated journals that the system generates through automated or manual posting schedules (daily, weekly, monthly, or manual).

The reconciliation compares both sets of entries at the level of Accounting Period, GL Account Number, GL Account Name, and Currency. Since Posting Journal Entries are derived from Detailed Journal Entries, both should always match.

Common Scenarios Causing Mismatches

• Posting Schedule Not Run

If Posting Journal Entries have not been created because the journal creation job has not yet run (based on the defined posting schedule), reconciliation will show differences.

• Unmapped Accounts (/N values)

If an account is not assigned in the Journal Account Mapping, the UI will show /N in the GL Account Number and GL Account Name columns.

Resolution:

1. Navigate to Settings > Accounting > Journal Account Mapping.
2. Download the rules file by clicking the down arrow button.
3. Filter for records with account number /N.
4. Assign the correct account number to the rule either by uploading the updated rules file or by editing directly in the UI.
5. Once corrected, rerun the journal creation job to update Posting Journal Entries.

Key Tip: Reconciliation should be used as a control checkpoint. If mismatches are found, always confirm whether they are timing-related (jobs not run yet) or configuration-related (account mappings, rules, currencies).

Contact Support if you are still blocked.

Layout & Columns

This report compares Detailed Journal Entries with Posting Journal Entries to ensure accuracy and consistency.

Optional / drill-down columns (add via Column Chooser)

Exports

• Standard Export - current layout (what you see on screen).

• VUD Export - detailed, transaction-level dataset for deep investigation.

  

Exported Data

Centralizes access to previously generated data extracts for controlled retrieval and tracking.

• User Exports - A centralized list of files you’ve exported (name, date, size) with quick download/refresh, useful for managing previously pulled datasets.
  

Security & Audit

Captures user activity and data-change events to enable access reviews, governance, and compliance audits.

• Audit Trail - A permanent event log of data changes and system/user actions with filters by data type, ID, event, user, and date, critical for SOX-style review.

  

• Security Events - Authentication activity (sign-in/sign-up, etc.) for your tenant to help with access reviews and incident checks.

  

Forex

Supplies reference exchange rates for multi-currency recognition, analysis, and reporting.

• Forex Exchange Rates - Daily close FX rates used by RevRec Premium for revenue and expense recognition; note that the exchange rate available on the Chargebee Billing will be used for the A/R, deferred, tax, or payout journal entries creation.

Rates are fetched from the 3 configurable forex libraries, i.e., Open Exchange, ECB Exchange, and Fixer API - Foreign Exchange Rates & Currency Conversion API. You can select the library of your choice from Settings > Accounting > Site Settings > Foreign Exchange Library.