Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
November 2021
November 2021
Hello,
Have started to use the above report available in the browser version of MYOB AccountRight, and it may be very useful for our not-for-profit organisation Board Reports to summarise cash movements.
A board member has queried how the 'VARIANCE" amount is calculated for The OPENING BALANCE and CLOSING BALANCES on the report.
I have printed off 7 years of CASH MOVEMENT REPORTS and cannot understand how the VARIANCE balances are calculated.
Any thoughts or suggestions ?
Kind regards
Roy Gardner
New Norcia Services
Solved! Go to Solution.
December 2021
December 2021
Hi @ROY
Sorry to see that no one has replied to you yet. My test file is also showing a strange amount in the varience column for the opening and closing balances. I've passed this on to the product specialist team to investigate.
I'll update you when I have further information.
Cheers,
Tracey
Previously @bungy15
MYOB Community Support
Online Help| Forum Search| my.MYOB| Download Page
Did my answer help?
Mark it as a SolutionHelpful? Leave a to tell others
December 2021 - last edited December 2021
December 2021 - last edited December 2021
Thanks for the support reply Tracey.
I have managed to reverse calculate how the Opening and Closing variance balances are calculated and am now confident to use and present the report data in Board Reporting. The opening and closing variances for one month reporting is clear and understandable.
If the report is run for longer than a one month period, then the variances for the opening and closing balance is a monthly cumulative total, and no longer directly related to the opening and closing balances reported on the report.
Attached spreadsheet shows the actual Opening Cash from 1 March to 30 November, with a difference of $2,036,530. The variance on the report is $41,618,553. The variance on the report is actually each monthly variance from March through to November, see tab 2 on the spreadsheet for the monthly report totals.
Thank you for your assistance
1
|
153
|
|||
1
|
590
|
|||
1
|
359
|
|||
32
|
856
|
|||
26
|
1056
|