Inter-Auth Data Aggregation
Data Pipelines for Auditors
Collect financial and operating data from the businesses you review, lend to or manage, written directly to your own cloud storage on a schedule. Each business connects its own accounts, agrees to share with you by name, and can stop sharing at any time.
Affiliates, clients or partners use their own free Flatly accounts, preconfigured to push name-stamped files to your cloud storage based on policies you define. No credential sharing is required. Members remain in control of their authorized connections.
- Scoped. Your members explicitly opt in at the data source, dataset and data destination levels and may revoke access at any time.
- Branded. Your members see your company, not a storage provider, as their data destination.
- Effortless. Setup takes under an hour on Flatly's side, under 10 minutes on your side, and can be trialed without any commitment.
Why collecting outside data is hard
Data held by another business usually reaches you in one of three ways. Each has a cost.
- Document requests. Staff email for statements and exports, follow up when they are late, and re-key PDFs. The data is out of date by the time it is usable.
- Shared logins. Clients send their bank or accounting passwords. Your firm now holds credentials it should not, and the client cannot limit what you see.
- Building an integration. Contracting with a data aggregator and writing code against several APIs takes engineering time, compliance review and ongoing maintenance.
Flatly replaces all three. Each business authorizes the connection itself, the scope is fixed by your policy, and the output is plain files in storage you already use.
How it works
- 1
Define your policy
Tell Flatly which data sources your members may connect, which datasets and columns to collect, how much history to request, how often to sync, and which file format to write. Flatly configures the program on your behalf, usually in under an hour.
- 2
Connect your storage
Connect one destination you own, such as a Google Drive folder, an Amazon S3 bucket or a SharePoint site. Every member's files are written there. This is the only setup on your side and takes under 10 minutes.
- 3
Share your sign-up link
You receive a sign-up link carrying your company name. Send it to applicants, clients, borrowers, franchisees or portfolio companies by email, in your application flow, in your client portal or in an engagement letter.
- 4
Members consent and connect
A member creates a free Flatly account from the link, signs a short authorization naming your company, and connects their own source, for example their bank through Plaid or their QuickBooks Online company. Flatly creates their sync with your policy already applied.
- 5
Files arrive in your storage
Each sync writes a file to your destination, prefixed with the member's legal company name. Syncs continue on schedule until the member disconnects or you end the program.
What your policy controls
Members connect their own accounts within these limits. Datasets and columns outside your policy are not offered to them.
- Sources.
- The data sources members are allowed to connect. Members see only those sources during setup.
- Datasets and columns.
- The datasets offered per source, and optionally the exact columns written to file. For example, bank balances limited to account ID, available balance and current balance.
- History.
- How much history is requested at connection time, where the source supports it. Banking connections can request up to 24 months of transactions.
- Sync behavior.
- Whether each run writes a new time-stamped file, which keeps a dated series of snapshots, or refreshes the same file in place.
- File format.
- CSV, Excel, JSON or parsed Google Sheets, depending on the destination.
- Plan limits.
- Members inherit the plan you subsidize. Limits such as the number of linked sub-accounts can be raised for your program, so a member with many bank accounts connects all of them.
What each side sees
Connections are blind in both directions. Members cannot see your destination details, and you cannot see their source details.
| You | Your member | |
|---|---|---|
| Member's source login and credentials | Never shared | Held by the member |
| Your storage location and credentials | Held by you | Never shared |
| Destination shown during setup | Your own storage | Your company name |
| Data synced | Files in your storage | Run status and history in Flatly |
| Membership | List of connected members on your account page | Your company shown as their partner |
| Direction of data flow | Receives files only | Sends data one way, read-only |
| Ability to stop sharing | End the program at any time | Disconnect at any time |
One folder, every member
All members write to the same destination. Each file name begins with the member's legal company name and a four-character code unique to that member, so files sort by member and never overwrite each other. With time-stamped syncs, your folder fills like this:
Acme Holdings LLC_x7Qa_Plaid Transactions 2026-09-01
Acme Holdings LLC_x7Qa_Plaid Transactions 2026-10-01
Acme Holdings LLC_x7Qa_Plaid Balance 2026-10-01
Birch Street Dental PC_m2Kd_Plaid Transactions 2026-10-01
Birch Street Dental PC_m2Kd_Plaid Balance 2026-10-01
Northline Freight Inc_R9td_Plaid Transactions 2026-10-01 Illustrative names. The exact suffix depends on your sync settings.
Examples
Lenders collecting applicant bank data
A financing company asks every applicant for bank data as part of underwriting. The application includes the sign-up link. Each applicant creates a free Flatly account, accepts the authorization, selects the bank accounts to share and syncs. All applicants' transactions and balances land in a single repository owned by the lender, one name-stamped file set per applicant. Applicants never see the lender's storage details, and the lender never handles bank logins or chases statements.
Audit and accounting firms
A CPA firm with 60 business clients needs bank transactions for year-end reconciliations. Each client connects their banks through Plaid once. Twenty-four months of transactions and current balances arrive in the firm's Google Drive as one sheet per client per month, so audit prep starts with data already in hand instead of a request list.
Lenders and credit funds
A small-business lender monitors cash covenants across its loan book. Borrowers connect their operating accounts at closing. Daily balance snapshots are written to the lender's Amazon S3 bucket, where the risk team's existing scripts read them. A missed covenant shows up in days, not at the next quarterly certificate.
Fractional CFOs and bookkeepers
A fractional CFO practice serves 25 companies on QuickBooks Online and Xero. Each company connects its ledger, and invoices, bills and the chart of accounts sync weekly to the practice's SharePoint. Board packs are built from one folder with consistent file names instead of 25 separate logins.
Franchisors and portfolio owners
A franchisor collects royalties on gross sales from 40 locations running Square or Shopify. Franchisees connect their point-of-sale accounts, and daily sales files land in the franchisor's storage. Royalty calculations use the source data instead of self-reported figures.
Bring your Cloud
All of Flatly's cloud storage and sheet destinations are supported,
including Google Drive, Google Sheets, Amazon S3, Azure Storage,
SharePoint, OneDrive, Dropbox, Box and SFTP.
For a full list see Data Destinations
Fully turnkey
Set up your own storage connection and then reach out to Flatly Support. You will be able to test the flow from your stakeholder's perspective same-day.
Billing is waived for your members. The Pipelines for Auditors program requires a minimum of 10 member seats. Data volumes and sync frequency determine which Flatly pricing plan you subsidize at a discounted rate.
Frequently asked questions
- Who is the Pipelines for Auditors program for?
-
Any organization that needs recurring data from businesses it does not control: audit and accounting firms, lenders collecting applicant or borrower data, insurers, fractional finance teams, franchisors, private equity and venture firms collecting portfolio reporting, and platforms that onboard business customers. The name refers to the reviewing party, not only to licensed auditors.
- Do my members pay for Flatly?
-
No. Billing is waived for members and no payment details are requested from them. You subsidize member seats at a discounted rate, with the plan determined by data volume and sync frequency.
- Can I see my members' bank or app credentials?
-
No. Members authenticate directly with their source, for example through Plaid for banks or OAuth for QuickBooks Online. You receive files in your storage and nothing else. Flatly never shares source credentials with you.
- Can members see where their data is stored?
-
No. During setup and in their dashboard, members see your company name as the destination. Your bucket, folder, site or account details are not shown to them.
- What do members agree to?
-
Before connecting, a member confirms that they have an existing relationship with your company, consents to Flatly sharing their data with your company until they revoke or disconnect access, and accepts Flatly's terms and your privacy policy. They also enter their legal company name and the date. The authorization screen shows your company's contact details and a link to your privacy policy.
- Can I write back to or change anything in a member's accounts?
-
No. Data flows one way, from the member's source to your storage. Connections are read-only, and neither you nor Flatly can move money, edit records or trigger actions in a member's accounts.
- What can members control?
-
Members choose which of their accounts to connect, for example which bank accounts to share during the Plaid step, and can disconnect at any time. Everything else, including datasets, columns and where files go, is set by your policy.
- How do I tell which file belongs to which member?
-
Every file name begins with the member's legal company name followed by a four-character code unique to that member. The code keeps file names distinct when two members enter similar names. If you enable metadata files, they carry the same prefix and identify the member inside the file.
- Which data sources can members connect?
-
Any Flatly data source, including banks through Plaid, QuickBooks Online, Xero, Stripe, Square, Shopify and Gusto. Your policy limits members to the sources you choose. Most programs use one or two.
- Can I limit which fields are collected?
-
Yes. You choose the datasets offered for each source and can restrict each dataset to specific columns. Members cannot add datasets or columns outside your policy, which keeps collection limited to what your engagement requires.
- How often does data refresh?
-
On the schedule set for your program. Each run either writes a new time-stamped file, giving you a dated series, or refreshes the same file in place.
- What happens when a member disconnects?
-
Syncs for that member stop and no further files are written. Files already delivered remain in your storage, since you own that storage.
- How do I know who has connected?
-
Your Flatly account page lists every connected member by legal company name, with a total count. The same name prefix appears on their files in your storage.
- What happens if a member's sync fails?
-
The member sees the error in their dashboard along with a prompt to contact your support team, so they know who to ask. Flatly support remains available to you and to them for connection issues.
- Can an existing Flatly user join my program?
-
Yes, from your sign-up link. Joining a program replaces the account's existing connections and jobs with the program setup, so a member who also runs their own unrelated syncs should keep those on a separate Flatly account.
- How many members can a program have?
-
The program requires a minimum of 10 member seats. Seats can be adjusted at checkout up to 1,000; contact Flatly Support for larger programs.
- Do I need engineers to run this?
-
No. Your setup is connecting one storage destination. There is no API to integrate, no webhook to host and no aggregator contract to sign. Files arrive in formats that spreadsheets, BI tools and scripts read directly.
- Can I test it before committing?
-
Yes. After you connect your storage and contact Flatly Support, you can run the full member flow yourself the same day, from the sign-up link to files in your storage, without any commitment.