QuickBooks Integration: Importing and Reconciling Bank Deposits
Use a configured TUIO export and SaasAnt to import bank deposits into QuickBooks, then review the accounting entries and bank-feed matches.
Overview
This workflow uses a configured Bank Deposit custom export from TUIO and SaasAnt Transactions to import deposit records into QuickBooks. Review the export scope, GL accounts and importer mapping before posting.
The result:
- Import deposit records using your configured GL mapping.
- Review suggested bank-feed matches in QuickBooks.
- Investigate differences before completing reconciliation.
🟢 Available exclusively to schools on the Professional package.
Before You Begin
- Confirm your package
- This feature is available on the Professional plan.
- If your school still uses the legacy Starter plan, contact support@tuiopay.com to discuss moving to Professional. Starter has been phased out and is not available for new subscriptions or switches from Professional.
- Book your setup session with TUIO Support
- Before you can generate the export, our team will schedule a short setup meeting with you.
- During this session, we’ll:
- Configure your GL accounts in TUIO.
- Enable the Bank Deposit custom export.
- Walk you through the initial Saasant mapping (see Step 2 below).
- Once setup is complete, the export becomes self-serve in your account. You can generate it anytime directly from TUIO.
Step 1 – Generate Your Export in TUIO
After setup, you can generate your own QuickBooks-compatible export anytime.
- Log in to your TUIO admin account.
- Go to Invoices and select Custom Export.
- Select the Bank Deposit template configured for your school.
- Choose the date range and export the file.
Wait 7 calendar days after the end of the reporting period before reconciling. This allows time for settlement, but does not guarantee that every payment has settled or that no later return or adjustment will occur. Review pending transactions and the processor activity for any differences.
About Saasant
SaasAnt Transactions is a separate third-party subscription. Choose the edition for your version of QuickBooks, then check the current plan limits and required import features.
You can create your Saasant account using one of the links below:
- SaasAnt for QuickBooks Online. Review current Online plans.
- SaasAnt for QuickBooks Desktop. Review current Desktop plans.
💡 Tip: If you’re unsure which version of QuickBooks your school uses, check with your bookkeeper or accountant before selecting a plan.
The account-creation links above are TUIO affiliate links.
Step 2 – Import into Saasant
Use the import type and mapping configured for your TUIO Bank Deposit template. The following workflow applies to SaasAnt Transactions Online; controls in the Desktop edition may differ.
- Open SaasAnt Transactions Online and start a Bulk Upload.
- Select Bank Deposits as the entity and choose your TUIO export file.
- Select or configure the mapping for your export. Check the deposit account, date, line account and amount fields.
- Use Preview Mapping and review the transactions before uploading. Recheck the mapping whenever your export columns or GL accounts change.
- Upload the reviewed records and check the import result before retrying any failed rows.
Step 3 – Review in QuickBooks
Once imported, your deposits will appear in your accounting system.
- Open the bank transactions for the receiving account in QuickBooks Online.
- Review each suggested match against the imported deposit, including its date, amount and account.
- Select Match when the existing record is correct. If necessary, use Find other matches to locate it.
- Avoid adding a second deposit for a bank-feed item that has already been imported.
When Deposits Don’t Match Exactly
Check the export date filter, payment-method restrictions, receiving account, pending transactions and bank posting dates first. Processor returns or balance adjustments can also explain a difference. Review the Processor activity report for the relevant period.
If a difference remains unexplained, contact support@tuiopay.com with the deposit reference, date and amount.
FAQ & Troubleshooting
Q: I don’t see the Bank Deposit export in TUIO.
Contact support@tuiopay.com to have it enabled and to schedule your setup session.
Q: My file failed to import into Saasant.
Make sure you’re using the Bank Deposit import type, not Journal Entry or Invoice import. If this persists, contact support@tuiopay.com.
Q: Some deposits didn’t match automatically in QuickBooks.
Review the date, amount and bank account, then use Find other matches to look for the existing imported record. Check the import result before creating another entry. A suggested match still needs your review.
Q: Can I edit my GL codes later?
Yes. You can update your GL accounts directly in TUIO, and these changes will apply to new invoices issued afterward.
For existing invoices, you can update GL codes individually or in bulk in TUIO.
For the Saasant import mapping, TUIO Support helps you set that up once. You can then reuse your saved mapping for future imports.
Need Help?
For setup or mapping assistance, contact support@tuiopay.com.
Our team will walk you through the setup and mapping. After that, it’s all self-serve.
Maintain a separate custom export template
Open Custom export, then open the Export template list and choose Manage custom export templates. Open the three-dot menu beside the template and choose Duplicate.
When you need a variation of an existing custom export, use its Duplicate action. Give the copy a clear name and choose the destination organization offered by the dialog, if applicable. Only choose an organization you are authorized to manage.
Review the copied template's filters, columns, date selections and GL mappings before using it. A copied template does not validate the destination organization's accounting setup or the importer mapping. Keep your established export unchanged until the copy has been checked.
For more detail, see Exporting transactions and reconciling deposits. The ordinary invoice Excel export serves a different purpose from this Bank Deposit custom export.