When using Funbutler together with third-party payment providers (such as Adyen, Stripe, or Qvickly), it is essential to reconcile sales, prepayments, liabilities, and payouts correctly in your accounting.
This article explains how to retrieve the correct accounting data from Funbutler and your payment provider, using a simplified and scalable reconciliation approach.
Recommended Reconciliation Method
Funbutler recommends performing reconciliation on a batch (period) level rather than per individual transaction.
Why batch-level reconciliation:
Simplifies accounting and reporting
Reduces complexity and risk of discrepancies
Scales well for high transaction volumes
Developed in collaboration with large venues and accounting consultants
1. Identify Outstanding Liabilities for Future Bookings (Prepayments)
Bookings that are paid in advance but scheduled for a future date should be recorded as liabilities (unearned revenue) in your accounting.
How to find this value in Funbutler
Open the Funbutler menu
Go to Reports → Day Sales
Locate the column for payments for upcoming bookings
Accounting recommendation
At period close (monthly, quarterly, or yearly):
Ensure this amount matches the liability recorded in your books for prepaid, not-yet-consumed bookings
2. Identify Prepaid Bookings Within the Reporting Period
Next, determine how much of the sales within your selected period relates to prepaid bookings.
How to find this value in Funbutler
Open the Funbutler menu
Go to Reports → Sales
Select the desired reporting period
Click the reload icon (small circle) to refresh the report
Scroll down to view the total for prepaid bookings
Usage
This value is used to reconcile payment provider sales data with booked revenue
3. Retrieve Sales and Payout Data from Your Payment Provider
Finally, retrieve the official financial figures from your payment provider. These values are used for bookkeeping and bank reconciliation.
Adyen
Log in to Adyen
Navigate to Finance → Sales to Payouts
Open Payouts
Select the reporting period
At the top of the page, you will find:
Sales
Sales – refunds
Transaction costs
Payouts
These are the figures that should be submitted to:
Your accounting system
Your accountant or bookkeeping partner
Stripe and Qvickly
Reporting structure and terminology may differ between providers.
Recommendation:
Refer to the official documentation of each platform
Ensure the report includes:
Gross sales
Refunds
Fees
Net payouts
Important Information (Disclaimer)
This article describes a general recommended approach for preparing accounting data when using third-party payment providers with Funbutler.
The method is based on practices validated with Funbutler accounting consultants
Local accounting rules, tax regulations, and chart of accounts may vary
It is always the customer’s responsibility to ensure compliance with local laws and accounting standards
When in doubt, consult a certified accountant or auditor.
Read more
Sales data for accounting
Sales report
Day sales report