Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am a treasurer for one HOA and have just become treasurer or another HOA. The second one is small with only 27 members, but it was run using Excel, a checkbook, and dropbox for some record keeping. In my other HOA, In my other HOA, I prepare 87 annual dues invoices giving them a future due date. A lot of members prepay and the payments are recorded correctly. On the new HOA the invoicing is not working correctly and driving me nuts.
I create a dues payment without problems. I use the receive payments icon and the dues invoice appears and I apply the payment. So far OK. Then I reconcile for the month and find not only the payment in the deposits section BUT the invoice listed as an expense!
I have tried everything I can think of.
Solved! Go to Solution.
Hello there, cthomas38.
I can help you troubleshoot the unusual display of transactions when reconciling an account within your company file.
If you used the Billable Expense feature which are expenses that are incurred by you on behalf of your customers, the expense transaction such as bills or checks will show up as an expense on your books and when you reconcile. It will show as income when invoiced, as you see in the Deposits and Other Credits section on your reconciliation window.
However, if you're not using the billable expense process, the unexpected behavior may have been caused by data issues within a company file. You can run a well-data checkup to make sure your company file is error-free. Let me show you how:
You can continue to the steps to Rebuild Data to correct the problem.
Here's a link that provides more information on how to record common customer transactions and in reconciling an account in QuickBooks Desktop:
Keep me posted on how this works. Any additional information such as a screenshot of your reconciliation window is much appreciated. Have a great day!
Thanks for getting back to us here, @cthomas38.
I have some information about recording the bank service fee. You'll want to create an expense account for your bank service fee. This way, you can use this account to record the fee when you reconcile.
To create an account:
After that, go to Banking and then Reconcile. Enter the fee in the Finance Charge or Service Charge section and make sure to select the expense account you allocate for the service fee. See the image below.
See this guide for details: Reconcile an account in QuickBooks Desktop.
Additionally, here's a link that covers all the tasks you can do when using the banking feature. Just look for a topic that'll fit your concern.
I'll be around if you still have questions about your accounts. Don't hesitate to reply. Take care and stay safe.
Hello there, cthomas38.
I can help you troubleshoot the unusual display of transactions when reconciling an account within your company file.
If you used the Billable Expense feature which are expenses that are incurred by you on behalf of your customers, the expense transaction such as bills or checks will show up as an expense on your books and when you reconcile. It will show as income when invoiced, as you see in the Deposits and Other Credits section on your reconciliation window.
However, if you're not using the billable expense process, the unexpected behavior may have been caused by data issues within a company file. You can run a well-data checkup to make sure your company file is error-free. Let me show you how:
You can continue to the steps to Rebuild Data to correct the problem.
Here's a link that provides more information on how to record common customer transactions and in reconciling an account in QuickBooks Desktop:
Keep me posted on how this works. Any additional information such as a screenshot of your reconciliation window is much appreciated. Have a great day!
The issue was actually a design issue. For this one, I picked the Homeowners/Condo preset. After a week's frustration and starting over with new companies, twice, I decided to try one of the "Income/Expense" presets. The problem went away. Someone needs to take a close look at real-world HOA/Condo accounting.
I still have a nasty little problem. This preset won't allow me to enter the bank service fee in the normal reconciliation. I have been using journal entries for the 5.95 monthly fees, but I have a small mess.
Any help would be appreciated before I start to build the 2021 monthly data.
Thanks for getting back to us here, @cthomas38.
I have some information about recording the bank service fee. You'll want to create an expense account for your bank service fee. This way, you can use this account to record the fee when you reconcile.
To create an account:
After that, go to Banking and then Reconcile. Enter the fee in the Finance Charge or Service Charge section and make sure to select the expense account you allocate for the service fee. See the image below.
See this guide for details: Reconcile an account in QuickBooks Desktop.
Additionally, here's a link that covers all the tasks you can do when using the banking feature. Just look for a topic that'll fit your concern.
I'll be around if you still have questions about your accounts. Don't hesitate to reply. Take care and stay safe.
Re: Billing Fee Issue
Perfect. I just deleted all the journal entries, extraneous reconciliation errors and went back 7 months anrd reconciled right through to the end of 2020 in less than an hour. It was so obvious I missed it.
Thank you for the quick response.
cthomas38
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