Consider this scenario: you just ran a big promo and annual prepay option. Cash looks strong in your storefront and processor, but you don’t know how it will land in the books.
Run Debits & credits by accounting category to preview the posting: you’ll see how much is true Revenue now, how much parks in Deferred Revenue, and how much was taken as Discounts.
If totals look off, switch to the By-line report to pinpoint the exact invoices, subscriptions, and credit memos driving the numbers.
Adjust promo settings if needed, then sync. Now your books match the preview, and you can explain “why revenue looks lower than cash” in minutes.
Read on for a quick walkthrough.
What the report does
- Speeds close: quick category totals + instant drill-down save hours of GL hunting.
- Explains results: turns “why did the revenue dip?” into a clear list of documents and subscriptions.
- Supports flux analysis: category totals + by-line evidence pinpoint the documents behind period variances.
- Auditable and consistent: mirrors RevRec posting logic, so the preview and the books line up.
- Prevents rework: catch mapping or setup issues before entries hit QuickBooks Online.
- Zero-risk review: read-only; it never changes your books until you choose to sync.
Simple workflow: run Summary → scan categories for outliers → run By-line → filter to the items causing the change → adjust settings/policies if needed → then sync.
How to get the report
How to get the report
- Go to Revenue Recognition → Reports.
- In Accounting Reports, select Debits & credits by accounting category.
- Choose your date range and report type (Summary or By line).
- Click Download—we’ll email the file to you.
Files are generated in your home currency set in RevRec.
Report types (what they contain)
You can export Summary or By line for your chosen date range. Files arrive by email.
- Debits & Credits — Summary
Columns:- Date – last day of the selected period
- Accounting category – see list below
- Debit (positive)
- Credit (positive)
- Currency – your RevRec home currency (e.g., USD, CAD)
- Debits & Credits — By line
Columns:- Transaction date
- Subscription ID
- Transaction number (e.g., invoice no.)
- Transaction ID (gateway/system ID)
- Transaction type
- Customer name
- Customer ID
- Accounting category
- Debit / Credit (positive values)
- Currency (RevRec home currency)
- Line item (when specific to a line)
Accounting categories (what you’ll see)
Balance Sheet
- Accounts Receivable (AR) – invoices increase AR; payments/credit memos reduce AR.
- Deferred Revenue – amounts collected for future performance (invoices, refunds, chargebacks affecting deferrals).
- Cash / Clearing – payment/refund/chargeback activity through your clearing account.
- Tax liability – sales tax amounts.
P&L
- Revenue – recognized revenue (to Income).
- Discounts – recognized discounts (to Discounts Given).
- Bad Debts – recognized write-offs.
- Shipping Income – recognized shipping revenue.
- Customer balance – balancing lines for negative invoices and applied customer credits.
Quick example: Investigating a Bad Debt spike
Scenario: February close shows unusually high Bad Debts in QuickBooks Online.
What you do in RevRec:
- Export Debits & Credits — Summary for Feb 1–Feb 28.
- Confirm the Bad Debts amount matches QuickBooks Online.
- Export Debits & Credits — By line for the same range.
- Filter Accounting category = Bad Debts.
- Use Transaction number/Subscription ID to identify the credit memos.
- Cross-check those credit memos against their linked invoices: any difference between credit memo and invoice amount is recognized as Bad Debt (this mirrors the RevRec’s syncing logic).
Outcome: You can explain the spike with specific credit memos and amounts without any guesswork.
How to read the results
Summary export
- Revenue vs Deferred Revenue – sanity-check recognition vs. remaining obligations.
- Bad Debts & Discounts – confirm unusual movements before posting.
- AR / Cash (Clearing) – verify invoice/payment flow is balanced.
- Tax liability – ensure tax totals align with your tax settings.
By line export
- Transaction type + Accounting category tell you the event and the impacted account.
- Subscription ID / Transaction number let you trace a question back to the exact customer and document.
- Line item shows which product/charge drove the amount.
FAQ
Does this match what will post to QuickBooks Online?
Yes, provided your RevRec settings match your sync settings. It’s designed as a pre-sync preview and a post-sync audit.
Can I run it during a trial or without QuickBooks Online connected?
Yes. It’s available to all RevRec users, including those on trial and RevRec-standalone users.
Why are Debit/Credit always positive?
For readability. If an event reverses, we swap debit/credit rather than show negatives.
What currency is used?
Your RevRec home currency.
For more information about Revenue Recognition or other Synder features, visit our Help Center or reach out to Synder Team via online support chat or email.
