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 product/service item
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 and Payment Details reports in TFC (the "billed at" or "payment 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/Service Items in QuickBooks by selecting Sales > Products and Services. If you wish to create new Product/Service Items, 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.
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