Product guideOpen GoRefer
On this page
Firm admins

Master data

Bring returns in from your own spreadsheets, tax software exports and bank funding reports, check every change before it is made, send intake data out to your tax software, and match returns to preparers and clients.

Verified September 5, 2026Open in GoRefer

Import data

Import data is the one place returns come in and intake data goes out. A spreadsheet of returns can come from any source: your own sheet, an export from your tax software, or a bank product funding report. Commissions, bonuses, payouts and referral rewards are worked out from these returns, so every import shows you what it would change before anything is saved.

The page has five tabs: Import a file, History, Duplicates, Export to tax software, and What's supported.

  1. Say where the file is from: your own spreadsheet, a bank funding report, or your tax software. When you choose your tax software, its column names are recognized and you see how to get the file out of it. If your software is not listed, or can't be chosen, choose Other tax software and match the columns once.

  2. Choose the file and the tax year. CSV and Excel files are accepted, including reports with a title block above the column names and bank reports saved from a web page.

  3. Check what each column means. Columns are matched for you when the layout is known; a weaker guess is offered with how sure it is, and is not filled in until you confirm it. Your choices are saved, so the next file with the same columns is matched the same way.

  4. Review every row: new returns, returns with changes (each field shown before and after), returns already up to date, and rows that need you. Each problem is explained next to its row.

  5. Fix a row, choose which return it belongs to, or skip it, without editing the file.

  6. Apply. Commissions, bonuses and referral rewards are recalculated, and the dashboards update within a minute.

  • The same return is never stored twice. A row is matched to its return by the SSN, return number, DCN or EIN for the tax year. When a row has none of those, it is matched by email, or by the last four digits of the SSN together with the full name, and the preview says so. A name alone never matches; it is shown to you to decide.
  • Values someone changed by hand since the last import, and returns marked funded by hand, are kept. The rest of the row still applies. You can choose to replace them for one import.
  • Amounts are read leniently: dollar signs, commas, amounts in parentheses and "N/A" all work. Text that is not an amount, a date that cannot be read, or a funded date in the future is left out and shown to you, never saved as it is.
  • A bank funding report updates funding on returns you already have. It never adds a return unless you choose to.
  • An import from your tax software reads its client and return list: names, SSN or EIN, filing and e-file status, preparer, key dates, refund or balance due, preparation fee and the forms filed. It does not bring the return itself across.
  • History lists every import from every source, newest first, with where it came from: a file you imported, your tax software, or the report inbox. An import can be undone for 30 days, from its result or from History. Returns it added are removed and returns it changed are put back; anything changed since keeps that change. A commission already paid is never taken back automatically: it goes to review in Commissions.
  • Returns already stored twice are listed under Duplicates. Copies with no paid commission are merged into one every day, or now if you choose. Where a commission was paid, the copies wait for you.
  • Export to tax software downloads the intake data your clients submitted (identity, contact, address, dependents and the forms they reported) as a CSV for you to bring into your tax software. Nothing is written into your tax software for you. SSNs show only their last four digits unless you choose to include them in full, which asks for your password again; every export is recorded with who made it.
  • What's supported shows, for each tax software, whether its export can be imported and how to get the file out of it.
  • Import data shows while Master Data or Tax preparation is turned on in Feature Toggles. With Master Data off, it imports tax software exports and your own spreadsheets, and keeps History, Export to tax software and What's supported; bank funding reports and Duplicates need Master Data.

Records and reconciliation

After an import, check the records and link each return to the preparer who earns its commission and to the client's account.

  1. Open View Records to confirm the returns and their funding.

  2. Open Reconciliation to find preparers and clients who are not in GoRefer yet. Returns with no preparer linked earn no commission until one is.

  3. Create preparer accounts with their email. Client accounts are created only if you choose to, and clients get no email unless you also choose to invite them.