# Reconciliation problem

**URL:** <https://forum.manager.io/t/reconciliation-problem/26784>\
**Category:** Uncategorized\
**Created:** [February 8, 2020, 7:58am UTC](https://forum.manager.io/t/reconciliation-problem/26784 "2020-02-08T07:58:27Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![JAV](https://avatars.discourse-cdn.com/v4/letter/j/b2d939/32.png) [@JAV](https://forum.manager.io/u/JAV)\
**Post date:** [February 8, 2020, 7:58am UTC](https://forum.manager.io/t/reconciliation-problem/26784/1 "2020-02-08T07:58:27Z")

</div>

I have attempted to reconcile one of my bank accounts.  
Master says there is a discrepancy, exactly the same as the opening balance.  
Why is this ? And how do I fix the situationAnd how do I fix the situation ? WhatWhat

---

<div class="post-metadata">

**Author:** ![JAV](https://avatars.discourse-cdn.com/v4/letter/j/b2d939/32.png) [@JAV](https://forum.manager.io/u/JAV)\
**Post date:** [February 8, 2020, 8:00am UTC](https://forum.manager.io/t/reconciliation-problem/26784/2 "2020-02-08T08:00:17Z")

</div>

Apologies for the mistakes that were not mine !

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [February 8, 2020, 8:30am UTC](https://forum.manager.io/t/reconciliation-problem/26784/3 "2020-02-08T08:30:23Z")

</div>

Can you post some screen images of what you are trying to do?

You need to give more detail of the problem - what you have said so far is not enough to help.

It seems like you have not followed the instructions as outlined in the guides - either in setting up your business or in doing the reconciliation

---

<div class="post-metadata">

**Author:** ![JAV](https://avatars.discourse-cdn.com/v4/letter/j/b2d939/32.png) [@JAV](https://forum.manager.io/u/JAV)\
**Post date:** [February 8, 2020, 10:10am UTC](https://forum.manager.io/t/reconciliation-problem/26784/4 "2020-02-08T10:10:38Z")

</div>

OK I will have a go

---

<div class="post-metadata">

**Author:** ![JAV](https://avatars.discourse-cdn.com/v4/letter/j/b2d939/32.png) [@JAV](https://forum.manager.io/u/JAV)\
**Post date:** [February 8, 2020, 10:15am UTC](https://forum.manager.io/t/reconciliation-problem/26784/5 "2020-02-08T10:15:17Z")

</div>

Image deleted

Image deleted

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [February 8, 2020, 1:43pm UTC](https://forum.manager.io/t/reconciliation-problem/26784/6 "2020-02-08T13:43:35Z")

</div>

First, it appears you have created custom control accounts for all individual bank accounts. Is that correct?

Next, show a screen shot of both the Edit and View screens for the last reconciliation of this bank account.

Finally, did you follow the Guide–[Reconcile bank accounts | Manager](https://www.manager.io/guides/9235) —and drill down on the discrepancy figure in the Bank Reconciliations listing and then follow through the process?

---

<div class="post-metadata">

**Author:** ![Hosea\_Leonard](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/hosea_leonard/32/19915_2.png) [@Hosea\_Leonard](https://forum.manager.io/u/Hosea_Leonard)\
**Post date:** [February 8, 2020, 1:56pm UTC](https://forum.manager.io/t/reconciliation-problem/26784/7 "2020-02-08T13:56:21Z")

</div>

hello @JAV from the screen shot it show you have not created bank account but you have created bank account controlled by another accounts. as @Tut said above post edit screen of one of the accounts . take example easy stret CU account, post its edit screen

---

<div class="post-metadata">

**Author:** ![JAV](https://avatars.discourse-cdn.com/v4/letter/j/b2d939/32.png) [@JAV](https://forum.manager.io/u/JAV)\
**Post date:** [February 8, 2020, 11:47pm UTC](https://forum.manager.io/t/reconciliation-problem/26784/8 "2020-02-08T23:47:14Z")

</div>

Re account 3863/9113 CBA  
No custom control on any accounts that I am aware of.  
Yes I did read & follow the guide. I checked all the entries, calculated the discrepancy figure with the final figure at the bottom of the reconciliation page.  
The $466.11, the discrepancy figure, is the starting balance of that account. It should have been taken into account during the reconciliation.  
I will add screen shots of the Edit & View screens of 3863/9113 CBA account, on a separate post.

---

<div class="post-metadata">

**Author:** ![JAV](https://avatars.discourse-cdn.com/v4/letter/j/b2d939/32.png) [@JAV](https://forum.manager.io/u/JAV)\
**Post date:** [February 9, 2020, 12:06am UTC](https://forum.manager.io/t/reconciliation-problem/26784/9 "2020-02-09T00:06:31Z")

</div>

Image deleted

Image deleted

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [February 9, 2020, 4:06am UTC](https://forum.manager.io/t/reconciliation-problem/26784/10 "2020-02-09T04:06:25Z")

</div>

It looks like you have created ordinary accounts with the names of your bank accounts in addition to the actual bank accounts in the Bank Accounts tab. And I think you are somehow entering receipts and payments without properly posting them to the real bank account. So when you perform a reconciliation, you are reconciling an actual bank account that has no transactions to it against your bank statement. Do the following:

- Show a screen shot of the Edit screen for the bank account itself from the Bank Accounts tab.
- Show a screen shot of the Edit screen for a receipt or payment that has been entered for this bank account.
- Show a screen shot of your chart of accounts from the Settings tab. You only need to show the Assets section.

---

<div class="post-metadata">

**Author:** ![JAV](https://avatars.discourse-cdn.com/v4/letter/j/b2d939/32.png) [@JAV](https://forum.manager.io/u/JAV)\
**Post date:** [February 10, 2020, 5:21am UTC](https://forum.manager.io/t/reconciliation-problem/26784/11 "2020-02-10T05:21:50Z")

</div>

OK I will do that in about 30 minutes.

---

<div class="post-metadata">

**Author:** ![JAV](https://avatars.discourse-cdn.com/v4/letter/j/b2d939/32.png) [@JAV](https://forum.manager.io/u/JAV)\
**Post date:** [February 10, 2020, 6:18am UTC](https://forum.manager.io/t/reconciliation-problem/26784/12 "2020-02-10T06:18:58Z")

</div>

Image deleted

Image deleted

Image deleted

---

<div class="post-metadata">

**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\
**Post date:** [February 10, 2020, 7:56am UTC](https://forum.manager.io/t/reconciliation-problem/26784/13 "2020-02-10T07:56:56Z")

</div>

@JAV looks like you intended to create control accounts without understanding how to create them. there seems to be no link between the accounts in Bank accounts tab and the accounts created in your chart of accounts.

1. in your chart of accounts, you should edit _3863/9113 CBA_ and enable control accounts made up of _Bank accounts_.
2. then in you _Bank Accounts_ tab, you should edit _3863/9113 CBA_ and set the control account to the above account in first step.

follow the above steps for all your other similar accounts you have created.

also, from the second screenshot in your above post, it is evident that you are trying to transfer funds from one of your bank accounts 3863 to your another bank account 6625. using _Receipts & Payments_ tab for this is not the right method. you need to enable and use _Inter Account Transfers_ for the same. read the guide [Transfer money between bank and cash accounts | Manager](https://www.manager.io/guides/9650)

i would recommend you to read and understand the guides section completely to avoid such mistakes in future. Manager is easier to use only when the user is aware of how the program functions. [Guides | Manager](https://www.manager.io/guides/)

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [February 10, 2020, 12:59pm UTC](https://forum.manager.io/t/reconciliation-problem/26784/14 "2020-02-10T12:59:36Z")

</div>

@JAV, @sharpdrivetek has explained the source of your problem. This is what I feared you were doing and why I asked to see the screen shots I did.

In summary, you created your bank accounts as regular bank accounts—that is, as subaccounts of _Cash at bank_. Then you created non-bank-account accounts with the same names and are trying to enter bank transactions with these non-bank-accounts.

From the portion of your chart of accounts shown, it looks like you are doing the same thing with fixed assets in various categories. And you are probably using tax codes incorrectly. There are Guides covering all these things.

---

<div class="post-metadata">

**Author:** ![Mark](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mark](https://forum.manager.io/u/Mark)\
**Post date:** [February 10, 2020, 4:47pm UTC](https://forum.manager.io/t/reconciliation-problem/26784/15 "2020-02-10T16:47:44Z")

</div>

Sorry for the off-topic but JAV, don’t you think you should blur personal data? (Maybe Staff should prevent users to publish personal data?).

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [February 10, 2020, 4:57pm UTC](https://forum.manager.io/t/reconciliation-problem/26784/16 "2020-02-10T16:57:09Z")

</div>

I have deleted @JAV’s images showing personal bank account information. They are no longer useful for diagnosing the problem.

@JAV, please read [FAQ - Manager Forum](https://forum.manager.io/faq).

---

<div class="post-metadata">

**Author:** ![JAV](https://avatars.discourse-cdn.com/v4/letter/j/b2d939/32.png) [@JAV](https://forum.manager.io/u/JAV)\
**Post date:** [February 12, 2020, 12:57am UTC](https://forum.manager.io/t/reconciliation-problem/26784/17 "2020-02-12T00:57:00Z")

</div>

No one told me to do that ! Thanks for the info.

---

<div class="post-metadata">

**Author:** ![JAV](https://avatars.discourse-cdn.com/v4/letter/j/b2d939/32.png) [@JAV](https://forum.manager.io/u/JAV)\
**Post date:** [February 12, 2020, 1:22am UTC](https://forum.manager.io/t/reconciliation-problem/26784/18 "2020-02-12T01:22:57Z")

</div>

Hello, When creating Master for me, I followed the guides, every step. I did not create any ‘control accounts’. I created what I thought were ‘headers’, BUT did NOT designate them as control accounts.  
I did look at the guide about control accounts, and decided I did not need them, because I wanted ‘control’, not another account.  
What does a Control account control ?  
In your above Step 1, you suggest I " enable control accounts made up of Bank accounts\* I can’t work out what this means.  
Made up of what bank accounts ?  
I dont want Cash at Bank. I don’t need it, unless you can tell me its use. I tried to rename it and then delete it, and it would not do either,.  
If it is a control account , nothing has told me that.  
I followed the instruction in Set up, which stated I should first create my chart of accounts, which I did. Nothig told me the Chart of accounts were Control accounts … if that is what they are.  
So for me to commence correcting the mistakes, please tell me what this part of your above Step 1 means - " enable control accounts made up of Bank accounts\*  
A sincere thank you for your assistance.

---

<div class="post-metadata">

**Author:** ![JAV](https://avatars.discourse-cdn.com/v4/letter/j/b2d939/32.png) [@JAV](https://forum.manager.io/u/JAV)\
**Post date:** [February 12, 2020, 2:00am UTC](https://forum.manager.io/t/reconciliation-problem/26784/19 "2020-02-12T02:00:51Z")

</div>

Looking again through the guides and looking at my Chart of accounts, my bank accounts on line, etc etc I still cannot work out why all the figures in Master are incorrect…  
I need an example please of the Step instruction, the part i cannot understand. I dare not change anything untill I know exactly what I should be doing.  
I am feeling desparate, because in 9 days time, I need to submit a Business Activity Statement to the Aus Taxation office !!  
I need an example please of the Step instruction, the part I cannot understand.

---

<div class="post-metadata">

**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\
**Post date:** [February 12, 2020, 4:06am UTC](https://forum.manager.io/t/reconciliation-problem/26784/20 "2020-02-12T04:06:13Z")

</div>

the following extract from the guide on chart of accounts [Build a chart of accounts | Manager](https://www.manager.io/guides/9181)

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/6/26e180714bcdf0b3c21c7e9b9e2693eead50d03e.png)

the following extract form the guide on creating bank accounts [Set up a bank or cash account | Manager](https://www.manager.io/guides/11367)

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/6/a69dbed4e8989467e4acfbfd47673489101fef94.png)

as per above, the _Cash at bank_ is the default control account which reports the total balance of all your bank accounts. this is also highlighted in the guide on custom control accounts [Add custom control accounts | Manager](https://www.manager.io/guides/9256)

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/b/fb012c0884721e2a32a7948a3ad634a6a356a3ba.png)

now your requirement is to segregate and show the balance of each individual bank accounts you have created which would act as subaccounts of the main account _Cash at bank_. for this purpose you need to link the relevant accounts to the main account which was the process I explained earlier.

[Next page](https://forum.manager.io/t/reconciliation-problem/26784.md?page=2)
