Accounting · File-based
QuickBooks Online
A journal CSV in the layout QuickBooks Online's journal entry import expects.
Data exchanged
- Date, account, debit and credit per line
- Class or location from department and entity
- Memo with traveller, supplier and booking reference
- Service fees on their own lines
| Type | File-based |
| Direction | silentVIP → QuickBooks Online |
| Frequency | On demand, for any period. Most clients export monthly after the invoice is issued. |
| Support | Your silentVIP account team, or support@silentvip.com |
Setup
Map your expense accounts to silentVIP categories (air, hotel, rail, car, fees)
Map departments to QuickBooks classes and entities to locations
Download the journal file from Integrations
Import it in QuickBooks Online (Journal entries → Import)
When something fails
Before a file is produced, every charge in the period is checked for an entity, department and account mapping. If any are missing, the export is recorded as failed, the problem rows are listed with links to fix them, and the failure stays at the top of the Integrations page until someone marks it resolved.
See it with your own data
Bring a sample from your system and we'll show the file it receives.