Why Your Treasury Balance in Puzzle Doesn't Match Your Account

If your treasury or investment account balance in Puzzle doesn't match what you see in your actual account, the most likely cause is how Set Balance is configured. This article explains what Set Balance is, why the discrepancy happens, and how to resolve it.
​

Set Balance is a Puzzle feature that automatically posts journal entries to adjust your treasury or investment account balances to match the actual balance received via API from your financial institution. This is found in Accounting > Settings > Automation > Data Ingestion.
​

When there's a difference between your ledger and your actual account, Puzzle posts a placeholder entry to one of these accounts:

These are intended to be temporary placeholders — once you add the actual transaction details (manually or via CSV), the Set Balance entries are automatically removed.
​

The discrepancy typically comes down to which option is active:
​

Option 1: Set Balance is ON Puzzle automatically adjusts the account balance in real time using placeholder entries. The balance will look correct on your balance sheet, but missing transactions may go unnoticed since they won't show as a discrepancy.
​

Option 2: Set Balance is OFF No placeholder entries are posted, giving you full manual control. However, the account balance will appear incorrect between reconciliations.
​

If you want full control and an accurate ledger without placeholder entries:

If Set Balance was previously on and you need to clean up placeholder entries:

💡 Tip: If entries aren't appearing during reconciliation, make sure you've reconciled through the correct time period. Unapproving and revisiting the reconciliation can surface hidden entries.