When you integrate with QuickBooks Online and run an export in The Food Corridor, your clients' bills will be created in QuickBooks as Sales Receipts, deposited to Undeposited Funds.

Each Sales Receipt includes:

  • TFC bill number

  • Payment ID in Stripe (or manual payment method)

  • Your unique products/services

  • Charge information, less the TFC platform fee (if applicable)

  • Payment information, including the client name

  • Stripe link (if applicable)

  • "TFC Customer" as the QB Customer

See below for detail on each of these fields.

Amount

The total amount is the same as the Stripe deposit (or manual deposit) for that payment in your bank account, allowing for easy reconciliation. This correlates with your revenue on your clients' statements and the Bill Amount on your Payment Details report in TFC.

Sales Receipt #

The bill number in The Food Corridor. This bill number correlates with several reports in TFC, can be found on clients' statements, and is also displayed in the description for that payment in Stripe.

Customer

All exported Sales Receipts are attached to TFC Customer in QuickBooks. The Food Corridor will create this customer upon your first export - no need to create it yourself in QuickBooks.

Sales Receipt date

This is the date the bill was fully paid. Meaning either: the date of credit card/ACH payment, the date the bill was marked as fully manually paid in TFC, or the date the bill was completed (i.e. no longer had a due amount). This date correlates with your Billed Line Items report in TFC (the "billed at" date), the payment date in Stripe, and the date on your clients' statements.

Reference no.

The bill number in The Food Corridor. This bill number correlates with several reports in TFC, can be found on clients' statements, and is also displayed in the description for that payment in Stripe.

Deposit to

All Sales Receipts are deposited to Undeposited Funds in your QuickBooks. When you receive the payout from Stripe and/or have confirmed the payments have been deposited in your bank account, you may reconcile your Sales Receipts to the appropriate bank account in your QuickBooks.

Product/Service

Your unique Service items for each charge type, tied to your income account(s). These products/services pull from your Mapping Settings you selected in TFC under Kitchen Settings > QuickBooks Online.

You can manage your Product/Services in QuickBooks by selecting Sales > Products and Services. If you wish to create new Products/Services, watch this 20-second video.

Description

Description of clients' charges. These descriptions correlate with the descriptions on clients' statements and in your Billed Line Items report in TFC.

Taxes

A line item is added for the total tax amount on the client's bill. For additional details and tracking of taxes on client bills, refer to any of your Payments reports in TFC.

Refunds issued by TFC

Displayed as 2 line items: the refunded amount as a negative (amount refunded from your Stripe account) and the platform fee as a positive (platform fee refunded to your Stripe account). These correlate with your clients' statements. The amount refunded from your Stripe account correlates with your Billed Line Items report in TFC.

Message displayed on statement

Charge information, including bill number and client name, and payment details. If a Stripe payment, it includes the url to the payment in your Stripe dashboard. If a manual payment, it includes the payment method and notes added by you when you recorded the payment in TFC. If there are multiple payments on a bill, this section will show the payment details for each payment. The charge information correlates with the description in Stripe for that payment.

More questions?

Check out our QuickBooks FAQs

Did this answer your question?