Running Etsy Deposit Balance Tie-Out
Equali tracks your Etsy Payment Account deposit balances and held funds reserves so every bank disbursement in FreeAgent reconciles to the penny.
Stop sorting Etsy monthly CSV statements by hand. Equali posts Etsy sales, listing fees, processing charges, and VAT into FreeAgent with 20% off.
Link your Etsy shop and FreeAgent account, then check the payout records and mappings.
Choose Connect on the Etsy tile during setup, sign in to Etsy so Equali can verify your open shop, and link FreeAgent.
Complete the guided profile step to set your VAT registration details and FreeAgent categories for shop sales and Etsy fees.
Inspect each Etsy disbursement's reconciliation status and post the categorised breakdown straight to FreeAgent.
Etsy keeps a running Payment Account ledger that subtracts listing renewals, transaction fees, regulatory operating fees, and held funds reserves from your shop earnings before disbursing cash. Equali reconciles every deposit for FreeAgent.
Equali tracks your Etsy Payment Account deposit balances and held funds reserves so every bank disbursement in FreeAgent reconciles to the penny.
Break out 20-cent item listing renewals, transaction commissions, payment processing charges, and regulatory operating fees into clean FreeAgent categories.
Save 20% on every Equali plan automatically when you run your Etsy shop accounting on FreeAgent.
Monitor earnings withheld in your Etsy Payment Account reserve until Etsy releases the cash to your bank.
Uses the tax figures reported by Etsy on orders and seller fees, or applies your confirmed tax profile rate.
Once an Etsy disbursement is sent to FreeAgent, Equali locks that deposit ID so it can never post twice.
A practical review before posting: Keep the Etsy payment-account activity beside the deposit you are reviewing. Identify sales, refunds and the individual fee descriptions in that report. Compare its dates and currency with the bank receipt; a deposit can cover activity from more than one trading day. Review the FreeAgent account mapping for each supported line rather than treating the net deposit as gross revenue.
“Thanks to Equali, we are able to control in detail the end-to-end flow of all transactions processed, giving us greater visibility and enabling us to detect any potential leaks or anomalies along the way.”
£15/mo£12/mo
+ VAT/sales tax where applicable
Not available at this volume
£30/mo£24/mo
+ VAT/sales tax where applicable
Not available at this volume
£75/mo£60/mo
+ VAT/sales tax where applicable
Not available at this volume
£Custom
+ VAT/sales tax where applicable
Scalable enterprise solutions for more complex requirements
| Feature | LiteStart trial | ProStart trial | PremiumStart trial | EnterpriseBook a demo |
|---|---|---|---|---|
| Sales & Payment IntegrationsIncludes eCommerce platforms (e.g. Shopify, Amazon) and payment providers (e.g. Stripe). May require additional setup. | 1 | 3 | Unlimited | Unlimited |
| Accounting IntegrationsIncludes accounting systems (e.g. Xero). May require additional setup. | ||||
| ERP IntegrationsIncludes ERP platforms (e.g. NetSuite). May require additional setup. | Enterprise Only | Enterprise Only | Enterprise Only | |
| Data Update FrequencyHow frequently payment and order data is refreshed via API (where available). | Every 15 minutes | Every 15 minutes | Every 15 minutes | Every 15 minutes |
| Historical Data (On Setup)Amount of past payment/order data processed during initial setup (via API where possible). | 1 month | 6 months | 12 months | 12 months |
| Upload FilesUpload and map CSV, XLS, XLSX or TXT files directly in the Equali dashboard. | - | - | ||
| Multi-Currency SupportReconcile and report on transactions in multiple currencies. | ||||
| Multi-Entity SupportManage and reconcile data across multiple legal entities, subsidiaries or stores in one account. | - | |||
| Custom IntegrationsBespoke API connectors or custom development for proprietary or unique systems. | Enterprise Only | Enterprise Only | Enterprise Only | |
| Custom WorkflowsBespoke workflow setup for your specific use case. | Enterprise Only | Enterprise Only | Enterprise Only | |
| Categorisation & Tagging For Journal EntriesRevenue sub-ledger with categorised breakdowns for posting to specific journals (revenue, fees, etc). | ||||
| Journal Entry PostingDirectly post categorised journal entries to your linked accounting system. | ||||
| Link Journal Entries To Orders/PaymentsTrace and link posted journal entries back to the original order or payment record. | ||||
| Settlement ReconciliationReconciles settlements vs individual payments and related entries. | ||||
| Payment ReconciliationMatches payments from providers with orders from eCommerce platforms, including refunds and chargebacks. | - | - | ||
| Payment SearchSearch for any payment or order using several data points directly from the dashboard. | ||||
| Advanced Reconciliation ToolsBrowse reconciliation results, review reports, resolve breaks and understand why they occurred. | - | - | ||
| Custom Reconciliation RulesCustomisable reconciliation rules, including rule suppression, tolerance thresholds and more. | Enterprise Only | Enterprise Only | Enterprise Only | |
| Cross-Platform ReconciliationsReconciliations across platforms e.g. Shopify store orders reconciled with Stripe payments. | Enterprise Only | Enterprise Only | Enterprise Only | |
| Reconciliation Approval WorkflowA second approver reviews and authorises reconciliation changes before they take effect. | - | - | - | |
| CASS ReconciliationsSpecialised reconciliation workflows for CASS 15 safeguarding reconciliation and reporting. | Enterprise Only | Enterprise Only | Enterprise Only | |
| Split Settlements At Month-EndSplit a settlement that spans a month end so each period's figures are accurate. | - | |||
| Customisable Analytics DashboardCustomisable analytics dashboard with advanced filtering, KPIs and reconciliation breakdown. | ||||
| ReportingStandard and customisable scheduled and on demand reporting. | Standard | Standard | Custom | Custom |
| Scheduled ReportsAutomated reports delivered on a chosen cadence (daily, weekly or monthly) via the dashboard. | Monthly | Daily, Weekly or Monthly | Daily, Weekly or Monthly | Daily, Weekly or Monthly |
| Ad-hoc ReportsGenerate custom reports on demand without waiting for a scheduled run. | - | - | ||
| Flexible Custom FieldsAdd customisable metadata fields to reporting data for better filtering and reporting. | Enterprise Only | Enterprise Only | Enterprise Only | |
| Manual Financial EntriesAdd one-off financial entries directly, outside the automated feed, for cases the connectors don't cover. | - | - | ||
| Tax ItemsMapping and categorisation of tax rates and items from sales channels and payments, for accurate tax reporting and journals. | ||||
| Transaction ViewBreakdown of each transaction, showing all financial entries associated with the order, including sales, refunds, fees and tax. | ||||
| CASS DashboardDedicated view and analytics for CASS reconciliation. | Enterprise Only | Enterprise Only | Enterprise Only | |
| Help and supportAvailable support channels and documentation. | Help centre & support chat | Help centre, support chat & Slack | Help centre, support chat, Slack & phone | Help centre, support chat, Slack & priority phone |
| Accountant AccessDedicated read-only or restricted logins for accountants and external advisors. | ||||
Ready to get started?14-day free trial on self-serve plans | PremiumStart 14-day trial | EnterpriseBook a demo | ||
Explore technical guides and architectures for automated reconciliation and accounting.
Journal entry automation turns source transactions into accounting entries for review. Preparation, reconciliation and delivery to the ledger are separate steps, with different checks.
Should you build automated reconciliations in-house or buy an off-the-shelf specialist product? The factors to weigh, from opportunity cost and complexity to maintenance.
A four-step guide to moving from manual, spreadsheet-based payment reconciliation to an automated process that matches every payout to its orders and posts the journal entries for you.
A useful reconciliation record explains what was checked, which source records supported it and what happened to any difference. Use these questions to review your evidence with finance and compliance colleagues.
The reconciliation models finance teams use, from fully manual spreadsheets to a purpose-built platform, and the trade-offs of each depending on the scale and complexity of your payments.
Processing payments is not risk-free. We outline the top payment risks online businesses face, from processor outages to incorrect settlement and fraud, and how to manage each.
For Etsy and FreeAgent in Equali, start with a sample payout. Check the source account and the ledger it should reach. Review the sales, fees and refunds before setup.
For Etsy in Equali, review the descriptions in the source records and keep identifiable fee types separate during investigation. The available report detail and account mappings determine how they can be represented in the accounting output.
For Etsy in Equali, a held balance concerns funds not yet paid out; a fee concerns a charge. Use the payment-account statement and relevant dates to establish the difference before choosing the accounting treatment.
For Etsy tax in Equali, check the source detail against the intended FreeAgent entry. Review the rate and tax type. Missing or unexpected tax needs review before you post.
For Etsy and FreeAgent in Equali, check the sale dates as well as the payout date. Review which period each line belongs to before posting. The payout date alone may not define the split.
For Etsy posting to FreeAgent in Equali, check the status before trying again. No reply does not mean no entry. Check the ledger record to avoid sending the same entry twice.
Bring payment and settlement records together. Review differences and prepare accounting entries with the source detail in view.