About
Applies to: Finaloop Accounting
Finaloop reconciles your sales end to end: it matches each online order to its payment processor payment and then to the payout in your bank, so your sales, payments and payouts stay fully aligned. Because ecommerce data comes from multiple systems and doesn't always arrive at the same time, reconciliation requires more than simply recording sales when they happen.
Here's how Finaloop reconciles sales from the moment an order is placed, through payment collection, and all the way to the bank deposit. You'll also see how Finaloop handles timing differences, what happens when orders or payments can't be matched, and why you might see a sales line named after a payment processor, such as Sales - PayPal, in your P&L.
1. How sales are usually recorded in Finaloop
Normally in Finaloop, your sales in the Profit & Loss (P&L) statement are categorized by sales channel, like Shopify, Amazon, eBay, Etsy or Walmart, for example Sales - Shopify.
The three-way reconciliation process
Finaloop uses a three-way reconciliation process to accurately track your sales and payments from order to payout.
Here's how it works:
Order data: We sync your order data directly from your connected sales channels, like Shopify.
Payment processor identification: We automatically detect the payment processor used for each order, like PayPal, Stripe, or Afterpay, and reconcile the payment with the related order. We record the amount in an Undeposited funds account for that payment processor on your Balance Sheet. Undeposited funds are payments you've already received from customers that haven't been deposited into your bank account yet.
Bank payout reconciliation: When the payout is deposited into your bank account, we automatically match and reconcile it, reduce the Undeposited funds for that payment processor, and tie the payment back to the correct orders and sales channel.
This process keeps your sales, payments, and bank deposits fully aligned.
Reconciliation in process
Because order data and payment data don't always arrive at the same time, temporary timing differences can occur.
For example, a payment may arrive before the matching order data, or an order paid through a payment processor may arrive before the payment.
This is normal and usually resolves itself automatically as more data is synced.
When this happens, we temporarily record the unmatched amounts in a Balance Sheet account called Reconciliation in process (RIP). This account acts as a temporary holding spot for:
Payments or refunds without a matching order, or
Online sales or refunds without a matching payment.
As new data is synced, Finaloop automatically matches the orders and payments and clears the Reconciliation in process account. Our accounting team reconciles this account on an ongoing basis, and we'll let you know if we need any input from you.
To keep your books balanced at all times, we clear unmatched amounts from the Reconciliation in process account by recording them in your P&L:
A payment without a matching order is recorded right away as sales under the relevant payment processor, like Sales - PayPal. If the matching order arrives later, Finaloop matches the two and reverses that entry, so the sale moves to its sales channel.
An order that still has no matching payment is recorded as an expense called Reconciliation discrepancies.
Some payment processors follow a slightly different flow. If you have questions about a specific processor, reach out to us at [email protected].
The reasons Finaloop records these entries are explained in "When payments are received without a matching order" and "When orders are received without a matching payment".
2. When payments are received without a matching order
If Finaloop receives payment data from a payment processor and there's no corresponding order data available, the payment is cleared from the Reconciliation in process account by recording it as sales under the relevant payment processor, such as Sales - PayPal or Sales - Stripe.
Why do I see Sales - PayPal or Sales - Stripe in my P&L?
A sales line named after a payment processor, such as Sales - PayPal, Sales - Stripe or Sales - Afterpay, instead of a sales channel like Sales - Shopify, means Finaloop recorded sales directly from that processor's payments. This usually happens for one of these reasons:
A payment that couldn't be matched to specific orders yet. This is often temporary. Sometimes payment data arrives before the matching order data, so Finaloop records the payment as a sale, for example in Sales - PayPal. Once the matching order data arrives, Finaloop matches it with the payment and reverses the Sales - PayPal entry, so the sale appears under its sales channel instead.
A charge outside a regular order or invoice. For example, you charged a customer's card directly in Stripe.
Sales from a channel that isn't connected to Finaloop. For example, if you accept PayPal payments through BigCommerce and BigCommerce isn't connected to Finaloop, we don't have the order data, but we still record the sales from the PayPal payment. This way your total sales are fully captured and nothing is missed.
To see which payments make up the line, click Sales - PayPal (or the relevant processor) in your P&L to open its transactions. To have these sales recorded under their sales channel instead, connect that channel in Settings → Integrations.
3. When orders are received without a matching payment
In rare cases, an order may appear in Shopify as paid through a payment processor, but no corresponding payment is actually received.
When this happens, we'll automatically clear the Reconciliation in process account by recording a Reconciliation discrepancies expense in your P&L. This removes any potential overstatement from order data received from Shopify and keeps your financials accurate.
Some payment processors follow a slightly different flow. If you have questions about a specific processor, reach out to us at [email protected].
Related articles
Need help?
If you're unsure about a specific transaction or want help connecting additional sales channels, reach out to us at [email protected]. Include the account name (for example, Sales - PayPal) and the month you're asking about, so we can look into it right away.
