Making the Switch: From Document-Based Export to Journal Entry Integration in ServiceTitan

Jun 2

Switching from document-based exports to journal entry integration in ServiceTitan is more than a checkbox change; it's a shift in accounting workflow, mindset, and system behavior. If you've recently made (or are considering) the switch, you're probably grappling with journal entry quirks, unexpected duplicates, or questions about undeposited funds.

I had an in-depth call with ServiceTitan’s accounting specialist, Hrayr Hovakimyan, during which we dissected the transition, uncovered edge cases, and discussed practical solutions. Here’s what I learned and what you need to know to avoid costly mistakes.

📌 First: What’s Changing?

With document-based export, you manually export batches (invoices, payments, deposits) into QuickBooks.

With journal entry export, transactions are synced automatically as journal entries, creating a more “touchless” integration that links invoices, payments, and deposits directly into your GL accounts.

🔧 Key Setup Considerations

❓Do you process 99% of your payments within Service Titan?

If the answer is no, Journal Entry Accounting probably isn’t for you, and here’s why:

Scenario: You made 12 mobile deposits through your bank, which appear as 12 individual deposits in your bank account.

With Document Base export, you can add all 12 payments in a batch from the Batch/Export Transactions section of the accounting tab, and it would take you 30 seconds to a minute to complete the export preparation.
Journal Entry Accounting requires creating a deposit for each deposit that clears your bank, with the payments comprising the deposit. To do this, you have to navigate to multiple screens to create a single deposit. We found that the time we spent on our clients' A/R increased significantly when we switched to Journal Entry.

✅ Clean up before switching

Before enabling journal entry integration:

Make sure your accounting section is squeaky clean.
Post or export all existing batches.
Ensure no unexported payments or invoices are hanging out in limbo.
Go to Customer Payments> Ungrouped Payments> Put all payments that have cleared your bank and ungrouped payments in a bypass deposit. This will remove all payments that have already cleared, so you can keep an eye on what hasn’t.

❗ Changing your journal entry start date after enabling can create duplicates. Syncing will include any transaction dated after that start date, even if it was already exported as a document.

🚨 Common Pitfalls and Troubleshooting

1. Duplicate Entries

This happens when:

An invoice was already exported as a document
Later edited to a date after the journal entry start date
The system now sees it as eligible for journal entry export

🛠️ Solution:

Never change the journal entry start date once set.
Instead, adjust the invoice date back (if acceptable) or manually export the missing invoice.
Use the "Exclude from Sync" button to prevent duplicates from being sent to QuickBooks.

2. Payments Not Exporting

By default, journal entry sync does not wait for deposits to occur. Payments are synced independently, which can be problematic if you want payment exports to align with your deposits.

🛠️ Options:

Manually filter and sync only those payments you know were actually deposited.
Group unprocessed payments into deposits manually in ServiceTitan.
Use the "Ungrouped Payments" view to review payments still sitting in undeposited funds.

3. Undeposited Funds Confusion

Payments are synced to undeposited funds even if they’re invalid or mistakenly created. For cash-basis businesses, this can overstate income and create tax issues.

🛠️ Best Practices:

Review and delete erroneous payments weekly.
Understand that even deleted or edited payments will automatically “backsync” and update/delete journal entries in QuickBooks.

4. Customer Deposit Workflow Confusion

If enabled, the customer deposit workflow:

Sends every payment, even those tied to invoices, into the Customer Deposits GL.
Then, it creates a second journal entry to apply that credit to AR.

🧩 This double-entry approach helps track unapplied funds but adds complexity and can confuse users, especially in smaller companies with limited accounting experience.

💡 If you don’t need this liability-based workflow, disable customer deposits in settings to keep it simple.

5. Deposit Matching Confusion

All transaction journal entries will show up to match when you try to match the deposit to the journal entry deposit in the transaction section in QBO.

The journal entry without a name is the deposit

💡 Helpful Tips to Keep in Mind

Set sync to real-time: This helps ensure changes (edits/deletes) reflect immediately in QuickBooks via backsync.
Use "Exclude from Sync" on journal entries to prevent bad data from hitting your books.
Understand your transaction types:
- Payment journal entries debit undeposited funds and credit customer deposits.
- Applied payment entries, debit customer deposits and credit AR.
Don’t rely on transaction “exported” status for journal entry exports; that status is only used for document-based syncs.** You may still see “Pending” even if a journal entry has synced.
For payroll/tax reporting that depends on export status, use batch posting or close the accounting period to mark transactions as "exported".

🧠 Final Thoughts

In theory, Journal Entry Accounting should streamline your workflow, reduce errors, and give you real-time financials. But if implemented carelessly, it can cause serious reconciliation issues, misstate income, or mislead business decisions. Even if you do everything perfectly, some incorrect information will still be sent over, and it will be up to you to sift through the journal entries to find out what went wrong.

The key? Don’t switch to Journal Entry

But if you insist, be methodical:

Start with a clean slate
Understand the implications of every transaction type
Leverage filters and syncing tools wisely
And when in doubt, ask for help before syncing

If I struggled to roll this out, you’re not alone. Hopefully, this post helps clarify the hidden mechanics and gives you a solid starting point for cleaner, smarter accounting in ServiceTitan.