Software and accounting guide

Finaloop: ecommerce accounting, inventory and financial reports

Finaloop combines an accounting platform with finance services for ecommerce and consumer brands, alongside inventory and analytics tools.

By Sam Yang · Updated 2026-10-09

How Finaloop supports the workflow

Who this guide is for: Brand owners, ecommerce operators and finance teams comparing channel sales, product costs, inventory and business profit.

Everyday uses

Review profit and loss and other financial reports.
Manage inventory-related financial information in the enabled tools.
Compare business performance with channel, product and customer analytics.

How it connects to accounting: Finaloop can be the accounting system being reviewed, rather than just a sales-data source sent to QuickBooks. Its profit report and customer analytics answer different questions. Compare their definitions and dates. Keep amounts labelled Unallocated visible: they have not been assigned to a report group.

How to connect it and get the records you need

A built-in connection transfers the records its vendor supports. An API lets software read or exchange specific records directly. Browser automation may use the screens and reports your role can access when a direct connection leaves a gap. Its coverage and reliability need checking for the specific workflow. Start with the options available in your account, then check what actually reaches your books.

Documented connection for the specific data

Confirm which records the current account’s documented connections provide. A product integration claim does not prove that a connection can return the particular financial report you need.

Native financial reports

Start with the configured profit-and-loss export and the other reports needed for the question. Keep the filters, report groups and any amounts labelled Unallocated.

Browser assistance

Inspect a report definition, customer cohort or unresolved category. A cohort is a group of customers acquired in the same period; compare groups at the same age.

Start here: Decide whether you are asking about total business profit, inventory cost or customer value, then select the report designed for that question.

Integration options and their limits

An API gives software direct access to supported records. Native reports are the files and reports available inside the product. Browser automation collects through the screens you can access. Choose the route that supplies the missing records, then check that it covers the accounts and dates you need. Reports may contain filters or omit rows. Browser work depends on permitted account access and can fail when screens change. Check record IDs, counts and dates whichever route you use.

Supported API

What it supplies: We did not verify a generally available Finaloop API endpoint that provides the exact financial workbook and customer-group definitions shown in its reports.
What to check first: API availability, permissions, history and customer-group coverage remain unverified for other accounts. That does not mean Finaloop has no API.

Choose it when: An existing supported connection has been checked and provides the required records and metric definitions.

Native export

What it supplies: Current Finaloop help documents configured Excel/Google Sheets financial-report exports and Export history. Active subscription is required for exports.
What to check first: A financial workbook does not prove that all customer-group records were exported or that payouts reached the bank.

Choose it when: You need original financial reports and their saved settings for a period-end review.

Permitted browser

What it supplies: Our dated observations cover the financial-report and Lifetime value screens. An authorized browser can check customer-group filters and retain the full displayed grid.
What to check first: Check the account’s permissions, report version and export controls. An emailed report is still pending until the file arrives.

Choose it when: The existing verified connection does not provide the required report or definition of a customer group.

What to automate and what an accountant should review

Good work for automation

Keep complete report grids and workbooks, compare customer groups at the same age, and check a clearly defined profit calculation without counting cost subtotals twice. Leave future months unavailable.

Keep a person on these decisions

Review missing acquisition history, how costs are assigned to groups, provider estimates and when revenue is recorded. Check the underlying advertising and bank records before deciding to scale marketing.

Lessons from accounting and operations

Known problems and what to check

Is the question about closing the books, unpaid invoices or customer profitability?

Choose the report for the decision. Closing the books needs accounting entries and supporting-source review. B2B collection buckets and DTC cohort economics cannot substitute for a close or for each other. B2B means sales to other businesses; collection buckets group their unpaid invoices for follow-up. DTC means direct-to-consumer sales, and a cohort is a group of customers acquired in the same period.

Evidence basis: Saved product-report guidance and inspected operational-review logic. The reviewed B2B bucket scope is a procedure limitation, not a verified vendor-wide channel exclusion. Source arithmetic verification is distinct from financial accuracy or ledger completeness. Some checks are Level’s own review requirements, rather than observed vendor behavior.

Check which data connections, built-in reports and exports your Finaloop account currently offers. Choose the source that keeps the report definitions and all the financial records needed for the question.

The owner wants overdue B2B receivables

Review eligible Open invoices and their due dates separately from Draft or Voided records. The reviewed procedure scoped this bucket to B2B invoices; it did not verify Shopify or marketplace coverage.

The owner wants to know when a customer group recovered its acquisition cost

Compare the same platform and customer-group age, with the same prediction setting. Check which marketing costs and returns are included before comparing older and newer groups.

Start with an API, connection or built-in report that your account offers and you have confirmed. An authorized browser session may collect records those routes leave out; test its coverage for the workflow. Still check the totals against the books and confirm that all relevant costs are included.

Pitfalls and when to pause

Uncached formulas, repeated hierarchy codes and missing history require review. Export inspection is separate from ledger import. B2B (business-to-business) customer reports do not establish DTC (direct-to-consumer) customer-group economics. Cohort profit recovery is separate from cash recovery. Verify included acquisition spend, estimates and returns in the current methodology. Keep download settings stable while a file is being delivered.

How a plausible answer can go wrong

A report can add up correctly while entries or supporting records are still missing. A profitable customer group also does not prove cash has returned to the bank.

Pause if you cannot confirm the account, permission, reporting dates or completeness of the records. Return the missing evidence for review. Do not fill the gap with an invented record, a balancing entry or an assumed zero.

When the result does not make sense

The newest customer group looks worse than older groups

Check: Compare groups at the same recorded age instead of using Overall. Check unavailable cells and gaps in acquisition history.

Resolve the question: Rebuild the same-age comparison. Keep limits caused by incomplete early history visible.

LTV multiplied by buyers does not match the monthly P&L

Check: Check the order month used by the customer view, the period in which the company records revenue, fixed overhead and which marketing costs each report includes.

Resolve the question: Explain the differences in definitions and dates. Do not force the customer view to equal the financial statements.

A customer group recovered its acquisition cost, then fell below it

Check: Inspect later returns, estimates replaced by actual results and revised costs.

Resolve the question: Show when the group first recovered its acquisition cost and its latest result separately. Sustained payback still does not prove cash is available in the bank.

Collect the records and check nothing is missing

Original general-ledger and trial-balance workbook: Keep every sheet, company, period and accounting basis. If a formula has no saved result, do not treat that cell as a known total.
B2B invoice and customer records: Preserve status and due-date definitions. A difference between these records and the books requires investigation, not an automatic error label.
Lifetime-value report for customer groups: Label recorded results separately from predictions. Recovering costs in a profit calculation does not establish that cash has reached the bank.

Select the correct company, report, period and accounting basis (cash or accrual). Keep the original Excel workbook (XLSX) and every sheet. For an emailed general ledger (GL, the detailed entries in the books), wait for the actual file. Keep checksums that identify the original and any processed files. Check formulas and which dates the report includes. For customer-group analysis, verify the current lifetime-value report and its definitions. These groups contain customers acquired in the same period. Compare the same store, platform, report period and group age with the same prediction setting, keeping the complete grid. Request an emailed export only when the collection authorization explicitly allows it; otherwise leave it pending for the account owner to obtain.

Checks before using the records

Retain report, period, accounting basis and every workbook sheet.
Identify formulas without cached results and preserve original versus derivative files.
Keep platform, observed cohort age, predictive state and cost definitions explicit.

Fictional collection example

A fictional young cohort (customers who first bought in the same month) has observed M0 (its first month) and M1 (the next month), but no observed M3 (its fourth month). Return M3 as unavailable, not zero. A workbook formula without a cached value also requires review. A cohort whose cumulative profit once exceeded its acquisition cost can fall back below it after returns. That does not establish that cash returned to the bank.

Invented teaching scenario, not a customer result or a reproduced vendor defect.

Capture the setup with the evidence

Company, legal entity or account, report name, period, cash or accrual accounting basis, currency and timezone.
Selected filters, status, page count, original record identifiers, record counts and totals used to check completeness.
Collection time, source route and authorized role. Record browser and automation versions when using a browser.
Original files and exceptions. Keep credentials, customer identifiers and financial artifacts private.

A browser version helps reproduce an interface issue. It does not validate the financial conclusion.

Practical workflows

Practical checks you can follow

Does customer payback in Finaloop mean the company has recovered its cash?

Finaloop’s customer-profitability view groups buyers by when they were acquired. It can show customer payback without proving that the company has recovered its cash. Compare groups at the same age. Separate recorded results from predictions, then check the company profit and loss statement, overhead and bank movements before deciding to spend more on acquisition.

Compare customer groups at the same age

Identify the acquisition platform and store using their IDs, not the store name alone. Save the report’s calculation method and whether predictions are enabled.
Compare groups at the same age and season. M3 means the fourth calendar month, not exactly day 90. Leave future ages unavailable until those months have been reached.
Check what each metric includes. Lifetime value (LTV) measures value per acquired buyer over time. Finaloop’s True LTV subtracts product and delivery costs; it does not subtract acquisition spending or fixed overhead. Customer acquisition cost (CAC) is acquisition cost per buyer. Its assigned store marketing includes affiliate/giveaway costs and retention campaigns, but excludes marketplace or unassigned spend. Missing assigned spend does not mean acquisition was free.
Separate recorded cumulative profit from predictions. The current method assigns actual returns to the orders they reverse. For recent months whose returns are not yet final, it estimates returns using store results from months with settled returns. Later updates can move a group back below its acquisition cost after it first appeared to pay back. Check the latest result before calling the recovery sustained.
Check how much acquisition history is available and which buyers can be identified. Store filters select where buyers were acquired; later eligible purchases in other stores can remain in that group. The weighted Average combines groups with different histories, taking their relative sizes into account. It does not represent one customer lifetime observed for the same length of time in every group.

Bring to the review: A comparison of acquisition groups at the same age, with customer counts, metric definitions and labels distinguishing recorded results from predictions.

Then decide: Check the underlying acquisition spending and buyer history before treating the reported payback as confirmed.

Review company profit and available cash separately

Collect the configured profit and loss statement (P&L), accounting transaction detail and trial balance, which lists balances for the accounts in the books. Use the same company, accounting basis (cash or accrual) and period. Keep all workbook sheets. Distinguish formulas from saved calculation results.
Walk from net sales through delivery costs, variable marketing, overhead and financing. Keep amounts labelled Unallocated visible: these costs have not been assigned to a report group. Do not silently assign them yourself.
Explain the change from opening to closing bank cash using actual bank transactions. Show funds still in transit, card debt, loans and owner distributions separately where relevant.
State which check passed. Downloading a file, reproducing its arithmetic, collecting all required records and matching the accounting balances are separate checks.

Bring to the review: A step-by-step company profit calculation, plus a separate explanation of the bank-cash change supported by bank records.

Then decide: Investigate balances without support and uncertain cost categories before using the report to approve spending.

Worked example

Fictional first crossing reversed by a later report revision

All records and amounts below are fictional teaching inputs. CSV files are spreadsheet-compatible text files. This example demonstrates the calculation, not a customer outcome or a reproduced software defect.

CAC is 300 / 10 = 30 per buyer. The first month-one report shows 34 profit per buyer; the revised report of the same month-one cell shows 28 after later return and cost revisions. Both reported values concern the same M1 cohort-age cell, in different snapshots. The 280 less 300 revised net amount is -20 before fixed overhead. No bank data is included.

What the CSV columns mean

cohort: fictional acquisition-month label
age: cohort age, M0 acquisition month, M1 following month
buyers: fixed cohort count
cumulative_profit: teaching USD before acquisition and fixed overhead
acquisition_spend: repeated cohort constant; sum only baseline snapshot
report_date: fictional report snapshot date, not a later cohort-age cell
snapshot: baseline, first_m1, revised_m1 report labels

CAC per buyer: 30 USD; Acquisition spend divided by the fixed ten-buyer cohort.
First month-one report profit per buyer: 34 USD; First illustrated crossing, before acquisition and fixed overhead.
Revised month-one report profit per buyer: 28 USD; Later observed value below CAC.
Revised cohort profit after acquisition: -20 USD; 280 less 300, excluding fixed overhead and cash timing.

Inspect finaloop-cohort.csv

cohort,age,snapshot,report_date,buyers,cumulative_profit,acquisition_spend
demo,M0,baseline,2026-01-31,10,220,300
demo,M1,first_m1,2026-02-28,10,340,300
demo,M1,revised_m1,2026-03-31,10,280,300

Download this CSV

Next decision: Verify revisions between report snapshots of the same cohort age, and separately check bank cash; this is not a projection.

Expected results and calculation checks Download the reproduction code

Run the example locally

Save the CSV files, expected-results.json and reproduce.mjs in one folder. With Node.js installed, run the command below. It calculates the checks from the CSV bytes and rejects a changed input or expected result.

node reproduce.mjs expected-results.json

No software login, customer records or API key is required.

AI prompt for collecting records without changing them

Replace the bracketed scope before use. This prompt collects evidence; it does not permit edits, approvals or accounting execution. Requesting an emailed report is a separate account action and requires explicit authorization.

Collect read-only evidence for Finaloop to answer [financial question]. Confirm [company], [account/entity], [period], [basis], [currency] and [allowed reports]. Select the correct company, report, period and basis; retain native XLSX and every sheet. For an emailed GL, wait for the actual file. Preserve original and derivative hashes; inspect formulas and cutoff. For cohort analysis, verify the current native lifetime-value report and its definitions. Compare the same store, platform, period and predictive setting, retaining the complete grid. Retain original files, complete record IDs, counts, filters, collection timestamp and exceptions. Uncached formulas, repeated hierarchy codes and missing history require review. Export inspection is separate from ledger import. B2B customer reports do not establish DTC cohort economics. Cohort profit recovery is separate from cash recovery. Verify included acquisition spend, estimates and returns in the current methodology. Keep download settings stable while a file is being delivered. Stop if the source or scope is uncertain. Do not post, match, reconnect, delete or change settings. Return the evidence for financial review; do not claim the books are correct. Request an emailed export only when the collection authorization explicitly allows it; otherwise leave it pending for the account owner to obtain. Do not approve, submit payroll, pay, transfer, refund, send messages, invite users or accept terms. Stop at any login, MFA or credential prompt and hand back to the account owner. Store files only in [approved private location]. Do not paste customer artifacts into public tools. Use only preauthorized collection actions. Request an emailed report only when its delivery is explicitly authorized; otherwise ask the account owner to supply the file.

Next decision

What can you decide from these records?

State which report and records support the decision. Explain whether you checked the download, the arithmetic, all required book entries or financial accuracy. One passed check does not establish the other three.

Compare the same records, accounts and reporting dates. List costs or payments you cannot yet verify before using the result for pricing, cash planning or month-end review.

Read the next finance check →

References behind these workflows

Each product reference supports only the features and limits described beside that source. Level's checks and fictional calculations are separate from what the vendor documents.

Read the product and workflow references with their scopes and review dates Explore the financial diagnostic examples

Sources and scope

Base product-reference scopes were reviewed 2026-10-07. No end-to-end dated native UI walkthrough is published for this software. Individual source rechecks are dated with their citations. Operator decision guidance was reviewed 2026-10-09. The references below support their stated product scope, not every observed interface detail. It is not a vendor capability certification, a measured customer result or an independently reconciled account. Verify current features and what your plan includes in the account you use.

Finaloop lifetime-value methodology
Product reference: Cohort lifetime-value methodology.
Product reference: Same-age cohorts, acquisition filters, recent-return estimates and differences from P&L. Definitions checked on the review date. Reviewed 2026-10-07.
Workflow reference: Same-age cohorts, acquisition filters, recent-return estimates and differences from P&L. Definitions checked on the review date. Reviewed 2026-10-07.
Finaloop: Reading your Profit & Loss (including exports and Export history)
Product reference: Report center, financial reports and export history.
Product reference: Configured exports, profit ladder and Unallocated segment amounts; not independent proof a customer's books are reconciled. Reviewed 2026-10-07.
Workflow reference: Configured exports, profit ladder and Unallocated segment amounts; not independent proof a customer's books are reconciled. Reviewed 2026-10-07.
Finaloop current product overview
Product reference: Accounting platform and finance-service offerings for consumer brands, inventory and analytics; no guaranteed accuracy or universal connection claim. Reviewed 2026-10-08.

Content revision history