Skip to main content

How to Reconcile Your Kitchen Payments Using TFC Reports

Use The Food Corridor's built-in payment reports to reconcile your kitchen's revenue — whether you're entering monthly totals into accounting software, matching Stripe payouts, or tracking revenue by category.

Written by Gnomes
Updated yesterday

The Food Corridor automatically generates bills for bookings, plans, storage, fees, and credits — which means there's no need to recreate invoices in your accounting software. Instead, you can use TFC's payment reports to pull the numbers you need and enter or import them on your own schedule.

This article walks you through which reports to use, when to run them, and how different kitchens put them to work.

💡 Note: If you use QuickBooks Online, you can connect it directly to your TFC account to export paid bills automatically. Learn why the integration is helpful and how to get started. The steps below are helpful if the integration isn't available to you or if you prefer a manual process.

When to Reconcile

Most kitchens reconcile their books after the 1st of the following month. This ensures all billing data for the prior month is complete before you start.

Keep these timing factors in mind:

  • Stripe transfers funds to your bank account after 2 business days (3 days for Canadian kitchens; PAD payments may take a bit longer).

  • ACH payments can fail and be reversed within a day or two after initially processing. Learn more about ACH processing here.

⚠️ Important: Reconciling before the 1st of the following month may result in incomplete data, since some payments may still be processing or could be reversed.

Where to Find Your Reports

All payment reports are available in the Reporting tab of your TFC account and can be downloaded as CSVs.

To access your reports:

  1. Log in to your Food Corridor account.

  2. Go to the Reporting tab.

  3. Open the Payments section

  4. (Optional) Filter your reports by a specific date range.

  5. Click Download CSV to download the data.

The Payment Reports

The Food Corridor uses cash-based accounting meaning that revenue is only recognized once payment is actually collected, not when they were originally due.

👉 Example: A booking from May that went past due and was finally paid in July will appear in your July totals — not May's.

Monthly Revenue by Type

Best for: Entering monthly revenue totals into your accounting software by category. It shows monthly totals for each charge category that has been successfully billed, declined payments and unpaid amounts are not included.

Revenue categories included:

  • Space Booking

  • Storage Rent

  • Billing Plans

  • One Time Fee

  • Monthly Fee

  • Overage

👉 Example: You built new storage in May, this report can give you quick insight how that increased your storage revenue.

Monthly Revenue

Best for: Getting a high-level monthly summary of gross revenue, taxes, TFC platform fees, and net revenue.

Like the Monthly Revenue by Type report, charges are grouped by when they were actually received. Use this report to get a quick snapshot of your net revenue for the month.

Payment Details

Best for: Reconciling individual client payments against Stripe transactions or bank statements.

This report shows the full picture for each client payment. Because many client bills include multiple charges (e.g., storage + monthly plan + booking), this report rolls them up into a single payment line — making it easier to match against what you see in Stripe or your bank.

Each row in this report includes:

  • Bill number and creation date

  • Amount owed vs. amount paid

  • Payment status

  • TFC platform fee and tax

  • Net revenue

  • Payment date and Stripe payment ID

  • Payment type

  • Stripe payout date

  • Notes on any manual payments

Billed Line Items

Best for: Verifying specific charge types, amounts, and billing dates per client.

This report breaks down every individual line item on every bill — useful when you need to investigate a specific charge or reconcile at a more detailed level.

Each row includes:

  • Month and year associated with the charge

  • Bill number and creation date

  • Client name

  • Charge type and description

  • Billed-at date

  • Bill status

  • Stripe payment ID

⚠️ Important: Line items are grouped by the month they're associated with, not when they were collected. To see what was actually billed in a given month, sort by the "Billed At" column.

Custom Report Fields

If you need to tag clients for additional tracking — such as assigning a QuickBooks customer ID — Custom Report Fields let you add that metadata to client records and pull it into reports.

Common Reconciliation Approaches

Approach 1: Monthly Totals by Category

This is the simplest approach and what most kitchens use. At the end of each month:

  1. Go to the Reporting tab and open the Monthly Revenue by Type report.

  2. Filter to the prior month.

  3. Note the totals for each revenue category (kitchen time, storage, fees, etc.).

  4. Subtract TFC platform fees to get your net revenue per category.

  5. Enter those totals into your accounting software as a split transaction.

👉 Example: One kitchen classifies all revenue as either "kitchen rent" or "storage rent" in QuickBooks each month. They use the Monthly Revenue by Type report to pull those two numbers, enter them as a split transaction, and call it done.

Approach 2: Transaction-Level Reconciliation

Some kitchens need to track revenue at the individual client or transaction level. Here's how:

  1. Import Stripe transactions into a general ledger account in your accounting software.

  2. Go to the Reporting tab and open the Payment Details report.

  3. Match each Stripe payout to the corresponding TFC bills and clients.

  4. If you need more detail on a specific charge, cross-reference with the Billed Line Items report.

  5. Confirm everything after the 1st of the following month to ensure billing is complete.

👉 Example: One kitchen posts Stripe transactions to a general QuickBooks account, then uses the Payment Details report to confirm and attribute payments to specific clients. When a charge needs more investigation, they switch to the Billed Line Items report for a line-by-line breakdown.

FAQs

Why don't my TFC report totals match my Stripe payouts exactly?

Stripe batches payouts and may combine multiple TFC payments into a single transfer. Use the Payment Details report and sort by the Stripe Payout Date column to match transfers to their corresponding bills.

A payment is showing up in the wrong month — why?

Reports group charges by when they were actually collected, not when they were originally due. A past-due payment collected in July will appear in July's totals, even if the original charge was from May. This is consistent across all revenue reports.

Where do I find TFC platform fee deductions?

Platform fees are broken out in both the Monthly Revenue report and the Payment Details report. The Monthly Revenue by Type report also shows platform fees as a separate line item.

Can I download these reports?

Yes — all reports in the Reporting tab can be downloaded as CSVs for easy sorting, filtering, and importing into your accounting software.

I use QuickBooks Online — is there a faster way to do this?

Yes! The TFC + QuickBooks Online integration lets you export paid bills directly to QuickBooks and map each charge type to the account of your choice. Learn more here.

💡 Note: The QuickBooks integration is available for QuickBooks Online only (not Desktop) and is limited to US accounts.

Have questions about a specific report or reconciliation scenario? Reach out to our support team — we're happy to help.

Did this answer your question?