cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Values are wrong during reconciliation of MZN currency accounts

When doing a Reconcile of a bank account in currency MZN (Mozambican Metical), the amounts that show in the “Checks and Payments” side are incorrect. It seems that for smaller amounts, the numbers are multiplied by 100 (for example, 47.50 in the transaction shows up as 4,750.00), and larger amounts are divided by 1000 (for example, 33,600 in the transaction shows up as 33.6 and 35,000 shows up as 35).

But the bottom left section showing the total selected “Checks and Payments” recognizes the real numbers (like the 47.50). And the bottom right section showing the difference between the Ending and Cleared Balance does the calculations using the real numbers, so I can go ahead and Reconcile the account. It seems like it’s simply formatting the amounts incorrectly in the “Checks and Payments” side since everything else seems to work fine.

In the “Deposits and Other Credits” side, the numbers are shown correctly, exactly as one would expect.

Once I figured out how to read the numbers (either divide by 100 or multiply by 1000), I can reconcile, so it’s not a show-stopper. I don’t know if this is happening because of something I’ve done incorrectly, especially since I don’t remember seeing this issue before this version (I use Desktop Premier Nonprofit 2018). But I suspect that there are not too many users using the MZN currency, so there’s a possibility that it’s a QuickBooks problem and nobody has reported it yet. This could be left over from the old MZM currency that was replaced by MZN in 2006 by dividing everything by 1000.

Has anyone else seen this behavior?

Two examples:

Solved
Best answer 02-26-2019

Accepted Solutions
Moderator

Re: Values are wrong during reconciliation of MZN currency accounts

Hello there, @eusdybo.

 

Thank you for joining the Community. I'd be happy to help share some insights about the values shown on the reconcile page in QuickBooks Desktop.

 

Yes, you're correct. Mozambique redenominated the metical at a rate of 1000:1. However, you can change the decimal separator format so that the amounts on the Checks and Payments are the same.

 

Here's how: 

  1. At the top menu, select the Lists tab.
  2. Select the Currency List.
  3. Double click the Mozambican Metical currency.
  4. Click the Change Format button. 
  5. From the Decimal separator drop-down, select Period
  6. Click OK.
  7. Click OK to close the Edit Currency window. 

I've attached a screenshot and article about this for additional reference: Set up and use Multi-currency.

 

 

For additional help, feel free to reach out to our Customer Care support. They have tools that can help you get this resolved quickly. 

 

Here's how you can reach them: 

  1. Sign in to your QuickBooks Desktop company.
  2. Select QuickBooks Desktop Help.
  3. Click Contact us.

These resources should help to get you on the right track for reconciling your MZN currency accounts. 

 

Drop me a comment below if you have any other questions about MZN currency or reconciliation in QuickBooks Desktop. I'll be happy to help you out. 

2 Comments
Moderator

Re: Values are wrong during reconciliation of MZN currency accounts

Hello there, @eusdybo.

 

Thank you for joining the Community. I'd be happy to help share some insights about the values shown on the reconcile page in QuickBooks Desktop.

 

Yes, you're correct. Mozambique redenominated the metical at a rate of 1000:1. However, you can change the decimal separator format so that the amounts on the Checks and Payments are the same.

 

Here's how: 

  1. At the top menu, select the Lists tab.
  2. Select the Currency List.
  3. Double click the Mozambican Metical currency.
  4. Click the Change Format button. 
  5. From the Decimal separator drop-down, select Period
  6. Click OK.
  7. Click OK to close the Edit Currency window. 

I've attached a screenshot and article about this for additional reference: Set up and use Multi-currency.

 

 

For additional help, feel free to reach out to our Customer Care support. They have tools that can help you get this resolved quickly. 

 

Here's how you can reach them: 

  1. Sign in to your QuickBooks Desktop company.
  2. Select QuickBooks Desktop Help.
  3. Click Contact us.

These resources should help to get you on the right track for reconciling your MZN currency accounts. 

 

Drop me a comment below if you have any other questions about MZN currency or reconciliation in QuickBooks Desktop. I'll be happy to help you out. 

Highlighted
Not applicable

Re: Values are wrong during reconciliation of MZN currency accounts

Thank you.  That's exactly the information I needed.

Need to get in touch?

Contact us