Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHello all. Hopefully someone can help!
I'm a small business manager who has taught himself Quickbooks/Accounting from scratch for the past year or so.
I didn't realise however, that bank reconciliation was a vital part.
I'm trying to reconcile now but have an issue.
In my books I have my main bank account linked, which updates transactions and I record them accordingly.
I also have a "Subsistence" account on my books, which I created, into which I transfer x amount every week or so. This is a tax free allowance for traveling as part of my job.
I expense day to day items which aren't exclusively business expenses from this account. The issue is when reconciling, the reconciliation process only sees the total transfer and not the individual expenses so the balance is off.
When I run a reconciliation from the company beginning date to the most recent statement date, it pretty much matches the balance of my subsistence account, so I'm confident all transactions and amounts were entered correctly, only the reconciliation won't balance.
If someone understands all that, are there any suggestions as to what to do?
Thank you for any help.
I've got some information and steps to help you, @EOB1985.
You can add individual expenses to the reconciliation process by recording them as checks or expenses. Here's how:
To know more about this process, you can check out this article: Pay for personal expenses from a business credit card or bank account in QuickBooks Online.
You can also refer to this article whenever you need guidance in doing or fixing a reconciliation: Learn the reconcile workflow in QuickBooks.
I'm always available to assist with further reconciliation concerns. Just hit the Reply button. Stay safe!
Is this a bot response?
Yes, do not trust any QB employees on this one. It's beyond their ability. It's obvious that their performance is rated on the quantity of responses, not the quality. Or they're AI-generated.
This "subsistence" (this allowance is known as 'Per Diem') account - is this just an account you have set up in QB but that does not actually exist at your bank? If that's the case, you cannot reconcile the account unless both the deposit and payment are coming from it. And, really, there is no need to have a separate Per Diem expense account. The proper way to do this is to make payments out of your main checking account and record them as Per Diem Expense. That records the payment made from the checking account and a corresponding amount to your Per Diem Expense account. Also, as I'm sure you're aware, non-business expenses paid for with the per diem allowance is considered income to you.
Im in Ireland. The subsistence is a tax free allowance claimed due to traveling for work.
The reason I set up the separate account was to track the balance so I didn't over spend.
"Im in Ireland. The subsistence is a tax free allowance claimed due to traveling for work"
Got it. Yes, we have the same thing here in the US and it's called a per diem. Since you posted your question on the US forum, I just assumed you were located in the US.
"The reason I set up the separate account was to track the balance so I didn't over spend."
That is what the expense account is for. This should be tracked outside of QB. There is really no preemptive accounting entry that can be used to track this.
So I tried transferring the subsistence account balance back over and then reconciling, didn't work. Obviously the reconciliation is only up until the last statement date so any changes I make presently won't affect it right?
So I backdated a transfer from subsistence back to main account and the difference dropped right down to €30. Not bad after 14months with no reconciliation! How big of an "adjustment" can I input for year end?
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here