Use Data Quality Control (Data QC) to make Avid's fundraising totals match the reports your team runs in your donor CRM. Enter or upload your CRM numbers by fiscal year, confirm your counting rules with Edna, then approve each section.
Data Quality Control
Make Avid's numbers match your CRM, in three steps
Data QC puts your CRM's totals beside Avid's, finds what explains each difference and turns your answers into counting rules. When every section lines up, you approve it and your reports start from the same numbers your team already trusts.
Four sections Last 5 fiscal years plus this year Definitions you can download
Before you start
This table shows what you need to use Data QC.
| Avid access | View access to Connections opens Data QC. Edit access to Connections lets you add numbers, answer questions, apply rules, approve sections and ask for help. |
|---|---|
| Data source | Data QC runs on the connection behind your primary transactions data set, usually your main donor CRM. |
| Fiscal year | Check Fiscal Year Start Month in Settings → Organization, under Fiscal Year & Donor Settings, so Avid's fiscal years match your CRM report. |
Compare Avid to the right report
The critical step
What to pull: Run your organization's standard fundraising summary report directly from the primary donor CRM connected to Avid, grouped by your Fiscal Year, using your normal fundraising filters. Data QC will then align Avid to that exact way of counting.
Not sure the report you have is the right one? Pick it below to see whether it will line up.
Fundraising summary from your donor CRM: This is the right report.
This is the report described in the card above. Data QC aligns Avid to it.
QuickBooks or general ledger: This will not match Avid one to one.
Accounting reports include revenue that never lives in your donor CRM, such as program fees, grants, interest and transfers, and they book revenue when cash clears rather than on the gift date.
Stripe or bank deposits: This will not match Avid one to one.
Deposits are net of processing fees, refunds and chargebacks, and land days after the gift. Fundraising reports count the donor's gross gift on the gift date.
Audited financials: This will not match Avid one to one.
Finance recognizes multi-year pledges on an accrual schedule and credits the legal payor, such as a donor-advised fund. Fundraising reports follow your CRM's gift-type and soft-credit rules.
A list of single gifts: Use a summary instead.
Data QC compares totals. Upload or enter totals by fiscal year or month, not one row per gift. To load gift-level data as a data source, see Upload your gift history to Avid from your CRM.
Why fundraising and accounting reports never match one to one
| Fundraising CRM report | Accounting report | |
|---|---|---|
| Which revenue | Gifts recorded in your donor CRM | Every ledger entry, including program fees, grants, interest and transfers |
| Which date | The donor's gift date | The date cash clears or a batch settles |
| Which amount | The donor's gross gift | Net deposits after fees, refunds and chargebacks |
| Pledges | Your CRM's gift-type rules for pledges and payments | Accrual schedules with discounts or reserves |
| Who gets credit | The household or donor who advised the gift | The legal payor, such as a donor-advised fund or employer |
Where to open Data QC
All three routes open the same Data QC page.
During onboarding
Where to click
From your primary CRM's card in Settings
Where to click
From inside your primary connection
Where to click
When you open Data QC, Avid starts the comparison on its own. If your data is still building for the first time, you see Your data is still being prepared, and Avid compares it as soon as the first build finishes.
Step 1 Enter or upload your CRM numbers
Start with the right numbers. Check your report against this list, ticking each item as you confirm it.
Your report is ready when it
- Comes from your donor CRM, the one connected to Avid, not from accounting or a payment processor.
- Shows totals, not gifts: one line per fiscal year or month, not one row per gift.
- Uses your fiscal year, matching the start month set in Avid.
- Uses your normal filters, the same ones your team uses for its usual fundraising report.
- Has a yearly donor count, because monthly unique donors do not add up to a year.
The four sections Data QC compares, in order
Revenue
Total gift revenue by fiscal year, compared with the same totals from your CRM report.
Revenue
What Avid checks:
- Whether pledges count when they are made or as payments arrive.
- How reversals and refunds are handled, and which gift types count.
- Which date your report uses, and your fiscal year start.
Donors and Gifts
Unique donors and gift count.
Donors Gifts
What Avid checks:
- How soft credits and households affect who counts as a donor.
- Which kinds of donor records, such as organizations, count in your donor total.
- Include a yearly donor count: monthly unique donors do not add up to a year.
Recurring
Revenue and gift count for gifts your organization treats as recurring.
Recurring Revenue Recurring Gifts
What Avid checks:
- How recurring gifts are set up in your CRM, and which gifts count as recurring.
Online
Revenue and gift count for gifts your organization treats as online.
Online Revenue Online Gifts
What Avid checks:
- How your CRM marks a gift as online.
-
Open the upload window. At the top of the Data QC page, click Update Your Numbers.
The Upload & Compare window opens.
-
Add your totals. Upload your summary report as a CSV, Excel, PDF, PNG or JPG file up to 20 MB, or click Enter data manually and type or paste the totals from a spreadsheet.
While Avid reads an upload, you see Edna is reading your report.
Say what period the numbers cover. Under What period do these numbers cover?, choose whole fiscal years, whole years plus this year so far, or fiscal year to date. For the last two, enter the date your data runs through.
-
Save your numbers. Click Save and compare. Avid compares the totals and looks for what explains each difference.
You see Comparing your data, then each year shows whether it matches.
Avid compares at the precision you enter, so a total typed in whole dollars matches whole dollars. To change your totals later, click Update Your Numbers again. Each section can switch between Fiscal Year and Month when you add monthly numbers.
Step 2 Align your counting rules with Edna
Data QC walks you through one section at a time. Each section shows its next step first, with more things to check below it and minor checks set aside. Answer the questions until the years line up. Try it on this sample section.
Revenue
Sample numbers
Approved
Your CRM report Avid
FY2024
CRM $1,184,200 $1,243,900 +5.0%
FY2025
CRM $1,291,500 $1,362,800 +5.5%
FY2026
CRM $652,300 $690,100 +5.8%
Next step
When does your team count a pledge as revenue?
Avid counts more than your CRM report in every year. Answer the question to see why.
In this sample, Avid counts pledges when they are made, while the CRM report counts each payment as it arrives. Answering that question applies the matching rule, each year lines up, and you approve the section.
Sample numbers for illustration. In Data QC, answers are confirmed with Edna and applied to your own data.
Answer the questions. Click Answer This Question to confirm how your team counts that item, or apply the recommended rule. When several rules apply, a button such as Use All 3 Rules applies them together.
-
Ask Edna about what is left. If a gap remains, click Need Help? on the section and choose Chat with Edna. Edna asks about your CRM setup, tests possible rules against your data and proposes the change.
Edna opens after you have compared your numbers, in a browser window at least 992 pixels wide. If the window is narrower, you see Make your window wider to fix this with Edna.
Settle what is left. If a difference comes from CRM edits made since the last sync, click Sync Now at the top of the page. You can also approve a section that still has differences; Avid saves them as accepted differences.
Counting rules Avid checks
- Gift types and pledges: which gift types count, and whether pledges count when made or as payments arrive. See Counting Gifts in Avid.
- Hard and soft credits: who gets credit for a gift, including households. See Soft Credits.
- Donor types: which kinds of records count as donors.
- Reversals: how refunds and reversed gifts are handled.
- Date basis: which date your report uses, and your fiscal year start.
- Recurring setup: how recurring gifts are structured in your CRM.
Step 3 Approve and download your Reporting Definitions
-
Approve each section. When a section matches how your team reports, click Approve on it.
The section shows Approved.
-
Finish. When all four sections show Approved, click Done, then Confirm in the Confirm your reporting alignment? dialog.
Avid saves your numbers and takes you back to the connection. If you confirmed rules, Avid rebuilds your data, which usually takes a few minutes.
Download your Reporting Definitions. On the Data QC page, click View Reporting Definitions, then Download PDF. The PDF lists the definitions Avid uses for your data, such as which records are included, how your fiscal year is set and where each column comes from, with who approved them and when.
After you click Done, your numbers are locked in. If a section's full-year numbers change later, its approval is removed so you can review it again.
Questions about Data QC
Avid does not match QuickBooks or our audit
That is expected. Avid aligns to your donor CRM's fundraising report, on gift date and gross gift amounts. Pull your CRM fundraising summary by fiscal year for Data QC.
I see "Data QC is only available for the primary data set"
You opened Quality Control on a secondary connection, such as an email, ad or other gift tool. Click Review the primary data set to switch to your main CRM connection.
Can I attach a report inside Edna chat?
No. Upload your CRM summary on the Data QC page through Update Your Numbers. To load gift-level data as a data source, see Upload your gift history to Avid from your CRM.
Chat with Edna is locked or asks for a wider window
Enter or upload your numbers first, then widen your browser window on a desktop so the side-by-side panel can open.
A gap remains after working with Edna
Click Need Help? on the section and choose Request Support under Still stuck? Ask LockStep for help.
What does Reset Report do?
Reset Report puts the gift filter and column mapping back to the last approved setup. Your uploaded reports, numbers and answers stay as they are.
Which years does Data QC compare?
The last 5 closed fiscal years plus the current fiscal year to date.