To get started, you will access the following:Īccess to your Stripe account with an admin or analyst permission Skip to Step #5 if you are one of the lucky ones using a CRM or donor management system like Breeze that makes it easier to run the reports that show the Stripe gross sales and fees taken out of each transaction in their platforms.įor the rest of us using CRM systems that don’t make it easier and require you to do extra steps in recording your data in QuickBooks Online, start from Step #1. Note that the same method can be applied to any other merchant account/payment gateway systems you use such as PayPal, Vanco Give+, etc. In this tutorial, I will walk through my process to record and reconcile Stripe transactions in QuickBooks Online. If you only record the net sales amount that shows up on the bank feeds, you are understating your revenue and expenses. I have seen many users get confused about recording revenue transactions from Stripe in QuickBooks Online.
#IMPORTING TRANSACTIONS INTO QUICKBOOKS VIDEO PRO#
If you need to import transactions into QuickBooks Online we recommend exporting to Excel and then using Transaction Pro Importer to import into QuickBooks.Do you host your website on Squarespace and collect donations or sell products? Are you using a donor management system or a CRM that uses Stripe as the payment gateway? If you answered yes to any of these questions, this tutorial is meant for you. QuickBooks Online does not support IIF files for importing transactions. (Note: These steps are for QuickBooks 2012 - the exact steps may differ for other versions). Find the IIF file on your computer and import. Go to File > Utilities > Import > IIF Files. To import your files open your QuickBooks company file. If there is an error, it will be easier to delete a couple transactions than all of your transactions.ģ. The first time you import an IIF file to QuickBooks, begin by testing with one or two transactions to make sure it is working correctly. You can enter them manually in QuickBooks or you can export your customer list in IIF format and load into QuickBooks.Ģ. Make sure that customer accounts exist in QuickBooks for all of your customers in TutorPanel. After uploading transactions you can apply payments to invoices.ġ. IIF files to not contain linkages between payments and invoices. Create a backup of your data before importing since there is no "undo" on the import function.ģ. There is no preventative method in QuickBooks to prevent the same IIF file from being imported more than once which would result in duplicate transactions.Ģ. General Guidelines from QuickBooks about IIF filesġ. Read the instructions below before you begin. Once you've generated IIF files from TutorPanel you're almost ready to begin uploading. Part II - Importing IIF Files into QuickBooks Select a time period for your IIF file and click export. Make sure your general QuickBooks settings have been entered. Under the Accounting tab go to the Export to QuickBooks option. Use the IIF file to import your invoice totals into QuickBooks. Select the month or a custom date range and then click the Export Invoices button. To export your invoice totals from TutorPanel in IIF format, go to the Invoices section on the QuickBooks page in your TutorPanel account. The IIF file generated in TutorPanel currently exports invoice totals only - to view line items on an invoice, your clients should refer to the original invoice from TutorPanel.ĥ. Invoice totals in QuickBooks cannot be negative - if the invoice total in TutorPanel is negative the invoice will be exported to QuickBooks as a Credit Memo.Ĥ. QuickBooks invoices do not include payments as line items on invoices so you should not include payments when you create invoices in TutorPanel.ģ. QuickBooks invoices do not carry forward starting balances so you should not check the option to include starting balances when you create invoices in TutorPanel.Ģ. TutorPanel provides more flexibility than QuickBooks when it comes to invoices so there are a couple things you should keep in mind when generating invoices if you plan on exporting those invoices to QuickBooks.ġ. Use the IIF file to import your customers into QuickBooks. Under the Customers section of the QuickBooks page, click the button to Export Customers. You can do this manually or you can generate an IIF customer file in TutorPanel and import it into QuickBooks. You will need to enter the account names from QuickBooks for your sales, received payments and the service item name for your tutoring services.īefore importing any transactions into QuickBooks you need to make sure that customer accounts exist in QuickBooks for each customer in TutorPanel. Under the Accounting tab enter the general QuickBooks settings.