MySF Forums / MySF - The Application / Bugs and Fixes

Attachments being attached to the wrong transactions.

PP Super — Wed, 13 Feb 2008 00:11:02 GMT

After not being too happy with some of the work arounds given to correct errors, I decided to write off my first years input as a learning experience and started afresh.

All is generally going well - it is a lot easier the second time round!! and so far (touch wood) I haven't made any input errors.

However I have discovered one bug that is, well, really bugging me.

I decided to take advantage of the fresh start to attach supplementary documents to transactions (eg contract notes, dividend statements, members contribution forms, ETP statements etc, etc).

Then I had reason to check a few transactions and found that attachments were not being attached to the right transactions.

Eg a listing of members contributions where I had attached a contribution form (MCF) to each transaction was now showing some transactions with 3 or 4 attachments and others with none. The same with some rollovers where 2 ETPs would be attached to some transactions and none to others.

I found that I could remove the wrongly attached documents then re-attached them to the right transaction - and so far they seem to be staying put.

However, I now find I'm losing confidence in the integrity of the database - how can stuff-ups like this happen?

At least with the attachments it is relatively obvious when there is a problem (well, at least if you go and check every transaction). But if fund allocations wander around like this it would obviously be a real problem.

How is the link between the transaction and the attached file maintained - what sort of problem would result in these links being corrupted - and what other problems might this indicate.

I'm now really getting behind with all this so your response is needed urgently.

Withholding tax not processed correctly on Quick Dividend Screen

reebuck — Thu, 20 Oct 2011 22:04:49 GMT

When processing a dividend receipt with withholding tax deducted, there is supposed to be a box to select at bottom of page to distribute the gross amount. This is missing from my screen. If I take the option to enter details later or use other receipts and select dividends, I get a slightly different screen but it works OK.

MySF can't see an external drive in Windows 7

scott — Tue, 12 Jul 2011 02:41:40 GMT

Hi,

I sent you an email for some instructions on how to install a fresh copy of MySF in Windows 7 on an Apple Mac running parallels. This is my new computer.

I had no trouble downloading and installing the program but when I try to restore my files from an external hard drive, the program can't see the drive. I have already right clicked on the desktop icon ticked "run as an administrator" as suggested.

If I go to My computer from the Start menu, the drive is accessible but MySF says the drive is on a different network . How do I get MySF to see the drive?

On rereading your notes I see that I am suppossed to copy the entire fund folder. Is that necessary if I am starting on new computer or can I restore from a backup file?

Regards

'Print' button does nothing in the reports

mysf — Fri, 24 Jun 2011 08:20:08 GMT

Hello,

For a while now we've been trying to find a simple fix for an issue many of you have had with 64-bit Windows where the reports could not be printed. Basically the report button in the top left of the report viewer window doesn't actually do anything when clicked as outlined in the following forum thread:
[url=http://www.mysf.com.au/members/Topic4369-24-1.aspx]www.mysf.com.au/members/Topic4369-24-1.aspx[/url]

We've found an updated version of Crystal Reports that will fix this issue but unfortunately it's not a simple "download and install" and there are a couple of steps required. Don't worry, we'll walk you through it!

[i]Note: You only need to do the following if you're running a 64-bit version of Windows Vista or Windows 7.[/i]

[b]1. [/b]Download the new Crystal Reports file via the following link:
[url=http://www.mysf.com.au/downloads/CRRedist2005_x64.msi]Download 64-bit Crystal Reports[/url]

[b]2.[/b] Once the download has finished, navigate to your Windows Control Panel via the Start button and go to 'Programs and Features'.

[b]3. [/b] In the list of Programs you should see "Crystal Reports for .NET Framework 2.0 (x64)". You need to update that program with the new version you downloaded in step 1 so please select it from the list.

[b]4.[i](a)[/i][/b] What you should first try to do is uninstall it by clicking the 'Uninstall' link at the top of the screen. Usually the installation will fail because we believe there is a compatibility issue between it and recent versions of Windows. If it fails, don't worry, move on to 4.(b) below. If it uninstalls and is no longer listed in the programs list, please move on to step 5 below.

[b]4.[i](b)[/i][/b] Now you need to repair the installation by clicking the 'Repair' link at the top of the screen. This will prompt you for a file called "CRRedist2005_x64.msi" which is the file you downloaded in step 1 so browse for that file and click Ok.

Once it's repaired you still need to uninstall Crystal Reports so that a fresh installation can take place and overwrite the report module files on your computer. Please repeat step 4.(a) now.

[b]5.[/b] Please double-click the file you downloaded in step 1 to install the updated version of Crystal Reports.

[b]6.[/b] After installation is complete, please run MySF Manager again and confirm when you run a report that the print button now brings up the print dialog.

If you are still having issues, please reply to this post or send us an email via [email]info@mysf.com.au[/email]

Regards,

MySF

Deferred Income and Asset Revaluations

sjcarlsen — Sun, 12 Aug 2007 14:14:47 GMT

I received deferred income in FY2005/06, which MySF has correctly deducted from the asset cost base. However, when calculating unrealised gains at year end, MySF uses the cost base prior to the deferred income deduction. Also, the balance sheet report seems to calculate the market value of shares as the aggregate of cost plus revaluation (instead of quantity x closing share price). The net effect of all this is that the balance sheet under-reports the market value of shares, by an amount equal to the deferred income, and yet intuitively, the deferred income amount should have no affect on market value.

In FY2006/07, I sold all the units that related to the deferred income amount, but the discrepancy in the market value of shares has carried forward to the new year FY2007/08. From what I can work out, it looks like that at the end of the year in which the asset was sold (FY06/07), MySF reversed the deferred income amount from the unrealised CG account. However, as stated in the first paragraph above, MySF did not include the deferred income amount in the revaluation in the prior year (FY05/06). Which means there is now a permanent under-reporting of unrealised CG, which in turn is causing a permanet under-reporting of shares in the balance sheet, even after the shares have been sold.

The Asset Summary report shows the correct details. However, I have to explain to my auditor why the market value of shares in my balance sheet differs to the market value of shares advised by my broker. Am I missing a trick here?

Member gender not reflected in Member Statements

tgilbert — Sat, 01 May 2010 21:37:45 GMT

Hi,

The member gender is recorded in the Business Cards.

However, whenever the Member Contribution Statement is generated, the gender is always presented as "unknown". Could this be pre-populated please - I'm guessing it doesn't change often! ;)

Whilst on the topic, is there a reason that the Employer details are not kept from one statement to the next? Please consider storing them. I don't know about others, but sometimes I roll the year end several times before satisfaction, but I must complete the MCS properly each time, and refilling the Employer details seems like something that the computer could do for me!

Cheers,
TonyG

Integrity Check changes values

tgilbert — Sat, 30 Oct 2010 22:47:12 GMT

Hi,

I've found an anomaly that caused lots of headscratching, but now I am certain that the integrity check is changing values in my fund without notifying me. This is quite disconcerting.

Steps to reproduce:

Create a Distribution that consists only of Tax Deferred income.

For instance, in the sample fund, DFA, $567 distribution, allocated totally against Tax Deferred.

Run a Distribution report and you will see funds allocated as $0 to unfranked, and $567 to Tax Deferred.

Close the fund and reopen it, causing the integrity check to run.

Re-run the Distribution report and you will see $567 allocated to unfranked and $567 allocated to Tax Deferred.

Now, to prove this is not correct, enter a similar distribution, but allocate $0.01 to unfranked and $566.99 to Tax Deferred.

Run a distribution report to confirm the allocations.

Close the fund and reopen it, causing the integrity check to run.

Re-run the Distribution report and you will see $0.01 allocated to unfranked and $566.99 allocated to Tax Deferred.

This causes me to conclude that when the integrity check finds a distribution with 0 in the "regular" allocations, it totals the "irregular" allocations and changes the unfranked total.

My questions:

1. How can I disable the integrity check?

2. How can I know when the integrity check wantonly changes my carefully managed data?

3. Does the integrity check create a journal transaction for the values that it changes?

Regards,

TonyG

01¢ rounding error processing Incomplete Distributions

tgilbert — Fri, 30 Apr 2010 21:05:29 GMT

Hi - I tried uploading a screenshot, but the Insert Image button is giving an "access denied" error to the D:\intepub\mysf\members\Uploads... tree.

I find that when I am trying to process Incomplete Distributions, I get a "Transaction Adjustment" message that contradicts what MySF is showing me on the screen.

For instance, I have a Total to Alllocate of $491.68 (composed of four, quarterly transactions). MySF shows that I have allocated $491.68 (Total Distrbution Received) and the Balance Amount Under/Over says $0.00, yet when I click Save, I get a dialog saying

This transaction contains a total amount which is $0.01 more than what was posted to the Asset Account. This amount will be posted to Dividends Receivable ...

and asking if I want to continue. Choosing No gives me an opportunity, but no method, to resolve the issue. Is this expected?

Regards,
TonyG

Predefined Transactions don't persist all data.

tgilbert — Wed, 28 Apr 2010 19:31:26 GMT

Hi,

I've found that Predefined Transactions are of limited use (and keep causing me mistakes) due to what I believe are a few minor bugs. Here are the steps to reproduce in the Sample Fund.

In the Sample Fund:

Add a second bank account (New_Bank) then

Click on Cash & Bank Accounts | Predefined Transactions
(to get the Predefined Transaction Manager)

Highlight “Cash Payment”

Click Add New

Select “Cash Payment” as the Transaction Type

Give the name (bug_test) and click “Enter Details”

Select “New_Bank” as the Paying From value and define a transaction to pay $100 to Jeremy Audit from New_Bank and allocate it Asset “Factory” and Account “5125 – Auditor’s Remuneration”.

Click Create.

In the Proceed? Window you will be prompted to confirm

CR New_Bank: 123 $100.00
DR 5125: Auditor’s Remuneration.

Click Yes.

Now highlight the Cash Payment in the All Predefined Transactions Tree, and click “View and Process”.

You will see that the Paying From is “CBA: 12345” not “New_Bank” as expected.

In addition, if you navigate through the fields using the TAB key (I find a mouse very cumbersome for data entry) to reach the SAVE button, you will see that the Account field loses its value during what I imagine is the OnLoseFocus event and becomes "-None-" instead of 5125. (This latter also happens on the equivalent Record Receipts dialog. *)

Obviously not a high priority, but here's hoping you can tidy this in a maintenance release some time. (And an accelerator on the Save and Exit buttons would be welcome everywhere! )

Regards,

TonyG

*The Receipts dialog fails to maintain the Asset selection of the predefined transaction too! For instance, define an Interest receipt with CASH as the asset and try to process it.

Report Error - Crashes MYSF for Asset Listing Rpt

amsweeting — Wed, 20 Jan 2010 06:59:26 GMT

Following happens when running an Asset Report and this is the following log :

(Running MYSF on Windows 7 Home Premium 64 bit)

****************** Error Occured on:Wednesday, 20 January 2010 ******************
The type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocument' threw an exception.
at CrystalDecisions.CrystalReports.Engine.Reportdocument..ctor()
at RptAssetListingCommonOnly..ctor()
at FrmReportTool.LnkPreviewAssetReport_LinkClicked(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
-------
An error has occurred while attempting to load the Crystal Reports runtime.

Either the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.

Please install the appropriate Crystal Reports redistributable (CRRedist*.msi) containing the correct version of the Crystal Reports runtime (x86, x64, or Itanium) required. Please go to http://www.businessobjects.com/support for more information.
at CrystalDecisions.CrystalReports.Engine.Reportdocument.CheckForCrystalReportsRuntime()
at CrystalDecisions.CrystalReports.Engine.Reportdocument..cctor()
-------

"Total change in value of assets from cost base" year end report

ross133 — Wed, 02 Dec 2009 02:34:43 GMT

This year end report may be wrong. 2009 is the first year end I have completed. My opening balances were loaded with the Adjusted cost base as reported by my previous fy returns and the asset were added with the original purchase price and aquisition costs.

When I review the year end report for Total change of assets from cost base, the start values are the Original Purchase price etc - any cost base journal adjustments during the year due to distributions etc. I expected the start values to be the Opening Balances - any cost base journal adjustments during the year due to distributions etc.

capital gains adjustments report

katfish2 — Wed, 28 Oct 2009 22:25:19 GMT

Hi
I've just done year end for 2009 and when i try to print the capital gains adjustments report i get an error message saying "MYSF has encountered an error. This may have affected some data, and the program should be restarted. Exist MYSF now?" What do i do?
Kat

Export a Balance Sheet Report

bksc — Wed, 22 Jul 2009 03:53:06 GMT

I'm using version 7.0.3 and everytime I print off a balance sheet and try and export it , MySF freezes and I need to restart it.

Any ideas?

Year end rollover bugs and problems

PP Super — Sat, 02 May 2009 03:51:44 GMT

Last year I rolled over the 2006-2007 year using MySF version 4.0. This year I rolled over the 2007-2008 year using version 7.0.1.

I can see there have been several changes to both the rollover procedures and the year end reports. Some of the rollover changes, eg. provision for future CGT on increase in market value, are very welcome and some of the report reformatting makes for clearer reading.

However, the changes also seem to have introduced a number of bugs/problems:

1) Profit distribution

The income and profit of the fund essentially fall into two categories:
Member specific - eg contributions
Fund general - really everything that isn't member specific

When doing the profit allocation, obviously the member specific items are first allocated to the relevant member and then the fund general components split according to the member allocations. With last years (version 4.0) rollover the member specific contributions and contributions tax were correctly applied and the remaining items split according to the member allocations. On the balance sheet, this could be seen in the members equity with the profit split going to account 3300 Share of Profit and the Contributions tax going to account 3620 Members expenses.

After this years (version 7.0.1) rollover however, account 3620 Members expenses still just shows last years contributions tax amount and a calculation check shows that this years contributions tax (which is actually attributable to just one member) has been split according to the member allocations and incorporated into the profit split going to account 3300 Share of Profit. This is obviously incorrect.

2) Tax deferred liability on change in market value of assets

Has been incorrectly calculated - I have already raised this in a recent post: [url]http://www.mysf.com.au/members/Topic4264-24-1.aspx[/url]

3) Member allocation calculation

Does not adjust for contributions tax on deductible contributions - again I have detailed this in a reply to another post: [url]http://www.mysf.com.au/members/Topic4263-24-1.aspx[/url]

4) Profit and loss report: profit/loss section

Since the actual fund income tax is split between instalments paid and provision for income tax (ie an increase in instalments paid will decrease the provision for tax) the item [i]Less: Tax Instalments Paid[/i] should be applied as part of the [i]Equals: Profit After Tax calculation[/i] - so that the full fund income tax is deducted from profit - otherwise the instalment payment is incorrectly increasing the profit after tax (by decreasing the Provision for Income Tax).

5) Members Position Report

I was glad to see that the bottom line members positions now matches the balance sheet figures. However there seems to be a problem with the allocation of Provision for tax.

Ignoring for the moment the profit distribution error noted in 1), I can see that the amount at [i]Provision for profit[/i] less the amount at [i]Provision for tax[/i] is equal to the increase in [i]Share of Profit[/i] (from last year) shown on the balance sheet - which all makes sense and balances out.

Ignoring for the moment the problem with the member allocation calculation noted in 3), the calculated percentages for our fund are (rounded) 97.8% to me and 2.2% to my partner. The [i]Deferred tax liability[/i] has been correctly split on the Members position report as per these percentages, however the [i]Provision for tax[/i] has been split 31.1% to me and 68.9% to my partner - these figures are just nonsense and haven't given a problem with the bottom line - the error seems to be balanced by the [i]Provision for profit[/i] (actually a loss this year) which ends up being split 105.5% to me and -5.5% to my partner! (ie the fund makes a loss, my partner gets a profit and I get a bigger loss than the fund- again just nonsense but canceled out by the tax allocation nonsense!

I am still wading through all the various reports, so there may be other issues but at this point it seems to me that:

Items 1) to 3) are actual errors in calculation in the accounts.

Item 4 is a error in the logic of how the profit and loss report calculates the profit after tax rather than any problem in the actual accounts.

Item 5 is an error in how items in the Members position statement are calculated rather than any problem in the actual accounts.

I am desperately trying to finalise the 2007-2008 figures for audit so I would appreciate your feedback on these items as soon as possible.

Regards,

Capital Losses

atkins12 — Sat, 21 Mar 2009 00:44:50 GMT

Hello

In the settings window I have selected the option "Realised capital losses should flow through to equity and cause a reduction in equity". Under release 6 when I ran the EOY wizard the capital loss I had for an investment fund, that was wound up during the year, was brought to account in the Income section of the Profit & Loss statement. It was also reported in the balance sheet as a reduction in member's equity via "Share of Profit" (3300 accounts).

When I reran the EOY wizard under release 7 there is a change in what happens. I have not changed the setting for how to process realised capital losses. Now the capital loss appears on the balance sheet as a liability under the heading Carried Forward Capital Losses Summary. Under Member's Equity it is being reported as a Members Expense.

It would seem that in release 7 MYSF is ignoring the option I selected NOT to carry capital losses forward to the next financial year. I know that some aspects of how capital losses were to be treated changed in release 7, but is this apparent decision to ignore the setting I selected intentional, a bug or have I missed something?

Regards ...... Ron

Profit & Loss Report

PP Super — Wed, 27 May 2009 00:13:23 GMT

Hi,

I originally mentioned this in a multi-subject post. In hindsight, that was a mistake and it is much clearer to use separate posts for these items.

I originally posted:[quote]Profit and loss report: profit/loss section

Since the actual fund income tax is split between instalments paid and provision for income tax (ie an increase in instalments paid will decrease the provision for tax) the item Less: Tax Instalments Paid should be applied as part of the Equals: Profit After Tax calculation - so that the full fund income tax is deducted from profit - otherwise the instalment payment is incorrectly increasing the profit after tax (by decreasing the Provision for Income Tax).[/quote]

and you replied:[quote]Tax installments paid is already part of the tax liability calculation so adding it again would cause it to be double counted. You can see how the software caclulates income tax expense by ticking the 'Show detail' and 'Show income tax calculation' options on the Report Tool screen. The full breakdown of the calculation is usually located on the last page of the report, under the heading "Income tax expense calculation"[/quote]

You rather missed my point here, I don't have a problem with the MySF accounts or the way that they are calculated - just the way the P&L is reporting this.

Let me put it this way - imagine two funds that are identical except that due to previous years tax have been raised very different PAYG installments - to keep it simple lets say that this years returns are identical and both have $100k taxable income and are liable for $15k tax. Both have no non-assessable income, non-deductible expenses or non-distributable amounts. The only difference is that fund A has paid no tax installments and fund B has paid $15k tax installments - leaving fund A with a current tax liability of $15k and fund B with a current tax liability of nil.

Now I would say that both have a taxable income of $100k, a profit after tax of $85k and an Amount available for distribution of $85k.

The current MySF P&L report would agree for fund A - however for fund B, since the provision for income tax is $0 (already covered by the installments) it would say that the profit after tax is $100k before deducting the $15k installments paid to give the same $85k Amount available for distribution.

My point was just that the real tax to be subtracted to give the profit after tax should include both the tax already paid (installments) and the tax still to pay.

I was not suggesting that the tax installments paid be added in twice or double counted - just that they should be applied before the profit after tax is totaled rather than after. The amount of tax that has been pre-paid as an installment does not actually change the total tax for the year or the profit after tax - but under the current P&L format it does change the reported profit after tax.

Members Position Report

PP Super — Wed, 27 May 2009 18:51:43 GMT

Hi,

I originally mentioned this in a multi-subject post. In hindsight, that was a mistake and it is much clearer to use separate posts for these items.

I originally posted (references to other issues removed):[quote]I was glad to see that the bottom line members positions now matches the balance sheet figures. However there seems to be a problem with the allocation of Provision for tax.

I can see that the amount at Provision for profit less the amount at Provision for tax is equal to the increase in Share of Profit (from last year) shown on the balance sheet - which all makes sense and balances out.

The calculated percentages for our fund are (rounded) 97.8% to me and 2.2% to my partner. The Deferred tax liability has been correctly split on the Members position report as per these percentages, however the Provision for tax has been split 31.1% to me and 68.9% to my partner - these figures are just nonsense and haven't given a problem with the bottom line - the error seems to be balanced by the Provision for profit (actually a loss this year) which ends up being split 105.5% to me and -5.5% to my partner! (ie the fund makes a loss, my partner gets a profit and I get a bigger loss than the fund- again just nonsense but canceled out by the tax allocation nonsense![/quote]

and you replied (again references to other issues removed):[quote] The tax allocation is not nonsense, it is based on the amount of tax payable by the fund and the amount of taxable income to the fund for which each member is responsible. If we took this out then members who make no contributions may be slugged with an extra large tax bill because of another member who makes a sizeable taxable contribution. The allocation of profits is made based on the formula selected or whatever overriden figures are entered at the time of the rollover. The allocation formulas are also discussed in the other post linked from your original. You can of course choose to use a different formula or override the figures manually. I accept that the 105% to -5% allocation does not sound correct at the end of the day, but if you have tax liabilities from your own contributions and the fund is in a loss overall then the fall in your equity after accounting for tax liabilities may be higher than the original loss itself. We will seek additional information on this and post it as it becomes available.[/quote]

You may have misunderstood my point here. I am not talking about the allocation percentages that MySF has calculated - as you say, we have discussed that in the other post. Neither am I talking about the problem I see in how MySF has actually processed the split, which is also covered in my original post here: [url]http://www.mysf.com.au/members/Topic4267-25-1.aspx[/url]. My problem is just with the figures included in the members position report which do not seem to reflect the actual calculations MySF has performed and the actual percentages MySF has calculated. I now notice that the problem can also be seen on the member information report - though only in the tax split, the profit split here (being after tax) is OK.

I will try and clarify my point:

If I look at the P&L it gives the Amount available for distribution as $196,044.90, during the rollover I saw that the member funds subtracted were $288,391.85 leaving a net $-92,346.95 available to be split and allocated. The P&L also shows a provision for income tax of $5717.60.

MySF has calculated the allocations as member 1: 97.781450%; member 2: 2.218550% and if I look at the Member Information report I can see the profit of $-92,346.95 being split as member 1: $-90,298.19; member 2: $-2,048.76 - which is according to the member allocation expenses, so that makes sense.

However, when I look at the $5717.60 provision for income tax it is split as member 1: $1191.85 (31.07%); member 2: $3941.15 (68.93%) - I cannot see how this can possibly be correct.

You say that:[quote]The tax allocation is not nonsense, it is based on the amount of tax payable by the fund and the amount of taxable income to the fund for which each member is responsible. If we took this out then members who make no contributions may be slugged with an extra large tax bill because of another member who makes a sizeable taxable contribution.[/quote] and [quote]if you have tax liabilities from your own contributions and the fund is in a loss overall then the fall in your equity after accounting for tax liabilities may be higher than the original loss itself.[/quote]I accept that you have to account for the member specific contributions tax on taxable contributions, however it is not the reporting of the fall in members equity I have a problem with here (other than the issue covered in the other post) and in our case it is member 1 who has made the sizeable ($100k) taxable contribution while member 2 has made no taxable contributions so, if anything, this would slew the tax percentages higher for member 1 and lower for member 2.

With regard to the member position report, the tax split is shown the same as the member information report. The Provision for profit however is before tax and is equal to the sum of the profit split + the tax split ie $-86,629.35 ($-92,346.95 + $5,717.60) split as member 1: $-88,521.74 (102.18%); member 2: $1892.39 (-2.18%).

You may notice that these percentages (profit, not tax) are different from my original post, which may give some clue as to what is happening - the difference is that when I reversed the rollover, since my original post, I also entered the liability for the $3836 tax installment paid after 30 June. The result was that the total amount to be split and allocated remained unchanged but the provision for tax dropped by $3836 and the provision for profit (before tax) as reported on the member position report increased by $3836. When MySF did the split it used the same 31.07%/68.93% split on the provision for tax - so whilst the provision for profit changes by the same (but opposite) [u]amounts[/u] as a [u]percentage[/u] this changes.

Finally, you say[quote]We will seek additional information on this and post it as it becomes available.[/quote]
That would be good, I would really appreciate you explaining just how MySF arrives at the provision for tax split that it puts into these two member reports - as I say, I cannot see how they can be correct but, if you still believe this to be correct, at least a clear explanation would help me to understand where these figures come from.

MySF has encountered a problem and has to close

scott — Tue, 19 May 2009 03:57:58 GMT

Hi,

I'm trying to do my end of year roll. I get through most of the jornal entries when the program throws up a box saying it has encountered a problem and has to close. What do I do now? Everything seems to rolling along nicely till it blows up.

Regards

Problem after downloading Version 7

mdorourke — Sun, 12 Apr 2009 22:40:33 GMT

After downloading Version 7.0 I have been unable to enter transactions involving Shares - both dividend receipt and purchases.

On opening the fund the following message is displayed "MYSF has encountered an error. This may have affected some data and the program should be restarted".

After restarting ( several times) the same message occurs.

Proceeding to 011 - Shares, the list of assets in the right box is empty. Selecting "Exchange" brings up no prompts eg ASX. On entering a "Code" the same message is repeated. Similarly after entering "date". After selecting "View and Manage Asset Allocation Table" the following message is received - No Asset Selected -" Please add new Financial Asset or select from the list on the right". When selecting bank accounts none are shown.

The existing share assets can however be listed using the Reports Tool - eg Trial Balance and asset Summary, and when using System Setup -View and enter Asset Cost Base.

I can enter transactions for bank transfers, contributions, interest, payments etc.

I have reinstalled MYSF using my original 3.1.1 DVD. The problem did not occur after doing this. However after downloading and updating to Version 7.0 the same problem reoccurred.

So the problem is either with my downloading software are there is a bug in Version 7. Do you have any advice or suggestions. I am using Windows 2000.

Michael

End of year report totals don't match

remp — Fri, 06 Mar 2009 23:41:11 GMT

Hi,

When reviewing reports at an end of year rollover, the report "Change in Market Value of Assets-Shares" this total value matches my share statements. Though when i review the Balance Sheet Report- Item "Increase in Market Value of Shares 011" this value is not the same. This larger value throws out my asset account balance by the difference.

Can you help me find where the item "Increase in Market Value for 011- Shares" is obtaining this added value?

Share units Balance sheet error

remp — Sat, 21 Feb 2009 00:10:10 GMT

Hi
After end of year roll over and checking my Balance sheet,Financial assets 011- shares were i have several holdings, the initial purchased number units of two holdings is incorrect. I have checked the share holdings under edit financial assets and the number of units here is correct.I have rolled over several times, ever rolled over two back ups but the incorrect number of units keeps coming up.

Can you suggest how I can correct this issue?
Thanks

Bank Reconciliation

John F — Sun, 01 Feb 2009 01:06:58 GMT

I have just run a bank reconciliation which shows the Bank Statement Balance as $23549.02 and the MySF Account Balance with the same figure of $23549.02, yet the difference is showing as $59063.93.

However when you select the reconciled items and tick them as correct, the difference shows up correctly as $0.00!

Can you please explain?

Transaction Reporter

John F — Sat, 31 Jan 2009 00:16:30 GMT

I searched for a journal entry in Transaction Reporter - Whole Fund - General Journal under Journal Types - Neither and could not find what I was looking for. I then repeated the search under All Journal Types and this time, found what I was looking for. I then viewed the journal entry and noticed that its Journal Type was Neither, so I repeated my search under Journal Type - Neither, but once again the journal entry could not be found!

As this is obviously a bug, I thought I should bring it to your attention. Also would you add to the wish list an option to print the journal entry after viewing it!

Regards

Johnj

Foreign income dividends & distribution transaction filtering

PP Super — Sat, 10 Jan 2009 01:42:34 GMT

We now have NWS shares and I understand that, as an American company, the dividends are foreign income (account 4170?) and the 15% US tax withheld is a foreign tax credit (account 4175?) so I was looking at the best way to record that. Looking at the cash receipt options, the normal dividend selection only applies to Australian shares with no options for foreign share dividends so the only applicable choice seems to be distributions - which then gives me the option to input foreign income and foreign tax credits.

I tried that out on the sample fund and it seemed to give the correct journal entries, ie:

Dividend: credit 4170 Foreign Income, debit 1101 Bank account
US tax withheld: credit 4175 Foreign Tax Credit, debit 2220 Foreign Tax Rebate

Since the payment is strictly a foreign share dividend, rather than a fund/trust distribution, it would be nicer if there was just a "foreign dividend" receipt type - however if this was the only niggle I would live with it.

The problem comes if you do a search in the Transaction reporter - the transaction is not showing up under either the dividend or distribution filters. To be more specific:

- I inputed a couple of distributions against a share asset - One using "Quick Add Distribution" and the other using "Cash Receipts", receipt type "Distribution"
- I did a report on "Whole Fund", "Cash Receipts", "All Transactions" and both transactions were correctly listed as:
CR00xx: Distributions: Distribution received for xxxx
- However, I did a report on "Whole Fund", "Cash Receipts", "Distribution" and neither transaction showed up
- A report on "Asset", "Cash Receipts", "Distribution" however, DOES list the transaction.

This is very dangerous - if I have a number of dividend statements, and I am not sure which one I have already put in, I would tend to do a report on "Whole Fund", "Cash Receipts", "Dividends" then "Whole Fund", "Cash Receipts", "Distribution" and then input anything that isn't listed - if I have already input something but it doesn't show up under the appropriate report it will get duplicated - BAD, BAD, BAD!

Another problem I had was I wanted to add a memo to the foreign income dividends. I worked out that I couldn't do this with "Quick Add Distribution" but I could do it with using "Cash Receipts", receipt type "Distribution". The trouble is that there seems to be two separate memo fields associated with the transaction - if you just "View journal entry" the screen has a memo box which just shows the standard dialog "Distribution received for xxx" and it is only if you choose "View additional information" that you get a screen with a different memo box showing the memo you have entered. This seems counter-intuitive - unless you remember you have put in a specific memo (in which case, you hardly really need the memo!) you won't go looking in another screen for it. It is also different from the dividends where, if you put in your own memo, it shows up in the memo box on the main "View journal entry" screen (and also appears as the same memo in the memo box on the "View additional information" screen).

This would not normally be a problem - I often use "minor edit" to add or change memos without reversing transactions - however it does not seem possible to edit dividend or distribution transactions!

So, to summarise:

1) The bug: the "distribution" filter in transaction reporter lists distributions only if searching by individual assets - not if searching by "whole fund"

2) The inconsistency: distribution transactions have two separate memo fields - the default entry in the memo box on the main "View journal entry" screen and the user input entry in the memo box on the "View additional information" screen whereas dividend transactions keep these two memos the same and allow user input into it - which is how it should work for the distributions as well IMHO.

3) A question: is the best way to enter foreign income dividends to use "distribution" or is there a better way that I missed (I realise I could always use general journal transactions - but that seems cumbersome and easier to make account selection errors).

4) A request: allow editing of dividend and distribution transactions - particularly a "minor edit" to just be able to change/add memos.

5) Another request: include "foreign income dividend" as a specific cash receipt type - similar to the regular dividend but so that the dividend defaults to the foreign income account and tax withwithheld defaults to the foreign tax credits account. (ie similar to the distribution but without all the extraneous distributions specific categories).

I should say that I only tried the distribution entries on the sample fund (I didn't want to replicate the problem on my main fund) - but I assume the problem would not be specific to the sample fund.

I should also say that I am currently running version 4.01. The reason for this is that I tend to input my fund info in large chunks and hadn't fired it up all through the 5.** versions so when I fired up it shows me that version 6.0.1 is available (which I have downloaded) - however the forums currently show there is still at least one unfixed bug (members position report) so I don't really want to update to 6.** till that is fixed (the various 5.** versions do not seem to be still available).

If any of this has been fixed/changed in the subsequent versions please advise.

Regards

Bank reconciliations - transactions missing

PP Super — Wed, 13 Feb 2008 17:31:38 GMT

I don't know if this is related to my attachment problem (previous post), ie another symptom of a corrupted database, but here's the problem.

I had done 8 bank reconciliations on three different bank accounts. All reconciliations went fine - all transactions showed up and were reconciled and all balances matched.

Then I decided to use the "view past reconciliations" feature - to see how a reconciliation printout would look. Here's what I found:

Account 1, four statement reconciliations:

Statement 1: fine, all four transactions shown
Statement 2: only one of six transactions shown (last one)
Statement 3: fine, all four transactions shown
Statement 4: first says "no records for this reconciliation" then, if you repeat, it shows two of three transaction and, if you keep repeating, it alternates between the "no records" and showing 2 of three.

Account 2, three statement reconciliations:

Statement 1: only five of eleven transactions shown
Statement 2: fine, all eight transactions shown
Statement 3: fine, all three transactions shown

Account 3, two statement reconciliations:

Statement 1: only four of fourteen transactions shown
Statement 2: fine, both of two transactions shown

In every case (whether the reconciliation shows correctly or not) the correct bank balance and zero difference is shown.

Also if you show reconciled transactions - all the transactions show up - its only when you use the "view past reconciliations" that the transactions get lost.

Again, I am getting increasingly worried about the integrity of this software/database - the whole reason for getting it was for reliable records and reporting and this is my second major problem in as many days.

I have now invested a lot of time in setting up the fund and inputing data and I urgently need to finish up the accounts for audit - so a speedy reply would be greatly appreciated.

Members Position Report

atkins12 — Thu, 18 Dec 2008 22:33:46 GMT

Since upgrading to version 6.0.1 there seems to be a problem with the members position report. The report shows the correct opening balances, then does not report any activity for the reporting period, eg contributions, income or expenses. The closing balance is incorrectly reported to be the same as the opening balance.

Regards .... Ron

Notes to the Accounts

blue-sky — Sat, 18 Oct 2008 15:12:59 GMT

The Asset Revaluation Notes to the Balance Sheet quotes revaluations at 30 June 2003. This appears to be hard coded. Can it be changed? Can the software be changed to update the information each year.

Is there another fix.

NB This is one example, there are possibly others

GST on brokerage

sjcarlsen — Tue, 12 Jun 2007 16:33:31 GMT

I included brokerage in the Purchase Shares Screen and used the tax code GST-PC. All the capitalised brokerage and non-refundable GST has been capitalised. And the refundable GST has been credited to GST paid. So far so good.

In the GST processing screen it shows the GST inclusive brokerage amount as the expense and the reduced GST paid as the GST amount. But they are on the same line. The system has not separated out the GST that was capitalised. Therefore there seems to be no way to calculate the correct correct GST amount in the GST report. I can either tag the whole transaction as G15 and report no GST, or I can tag the whole transaction as G11 and over report the GST.

I can't download updates or connect to your forums from MySF

scott — Sun, 05 Oct 2008 02:54:32 GMT

No matter what I try I can't seem to connect to you for updates or forums. I run Norton 360 and have tried turning off the firewall but it makes no difference at all. When I open MySF it hangs as a grey screen for several minutes and then opens but the dashboard says it couldn't establish an internet connection. I can't download updates and the default box says it may be a program is blocking it and if I try to connect to your forums from the dashboard it says establish an internet connection first. I'm afraid I'm running out of ideas. Is there some "techy" type of rule I can check for somewhere as something seems to block just this program?

Regards

Report Tool Error

mdorourke — Sun, 05 Oct 2008 20:07:11 GMT

Since downloading 5.02 (which may be coincidental) each time I have tried to generate a report using the Report Tool an error message appears suggesting to close MYSF as there has been an error which may effect the data. I have tried a range of things including restarting the computer, as well as closing and reopening MYSF as per the error message. I also receive the same error message when I checked using an old file. I have tried installing 5.02 again and also tried the repair option in the installation program. Any suggestions ??

Regular transaction manager - description not carried across

bruceb — Mon, 14 Jul 2008 13:08:42 GMT

Why doesn't the description for a regular transaction get carried across to the confirmation window when the transaction is due ?

userid / password asked for on startup

bruceb — Mon, 14 Jul 2008 13:11:19 GMT

I have disabled the need for userid/password, which is working fine.

The next time I started the software after removing an asset it asked me for my userid/password.

thanks
Bruce

error removing financial asset

bruceb — Sat, 12 Jul 2008 16:12:52 GMT

Hello

I mistakenly coded a sale of a share as a purchase (shouldn't be doing this early on a Sunday!)

So I reversed the txn, then removed the asset.

The error message which came up was

:"the account for this asset has a balance of : $0.00 remaining, or has one or more system references"

It cannot be removed automatically.

members position - rollover problem

PP Super — Fri, 07 Mar 2008 03:17:46 GMT

Because of ongoing problems (covered in other posts) I held off doing the year end rollover until the last upgrade was released. It got very tight but we still got the fund audited and the return in by the 28th (the last hour of the 28th!).

Then I saw Ron's posting on the members position problem and your fix. I applied the fix and the members position report now will run, as Ron reported.

Unfortunately, the year end rollover was obviously done after upgrading to version 4 but before the bug was reported and the accounts modified.

I now have the following situation:

1) If I go to the year end reports and select Members position, I just get a blank report - the headings are there but absolutely no information - not even the members names.

2) If I go to the members tab and put in the dates for 1/7/06 to 30/6/07, I get the full layout but every field is zero except for "provision for profit" and these figures seem to have no relevance to any of the actual members allocations and are much less than the actual allocated profit for the year.

3) If I repeat this but use the date range 1/7/06 to 7/3/08 (today) I again get the full layout but now every field is zero.

4) If I repeat this but use the date range 1/7/07 to 7/3/08 (today) I again get the full layout now with the correct opening balances for the 07-08 year and the correct members position (no relevant entries have been made yet for this year)

Now (4) seems correct to me - but anything covering the 06-07 year is gabage - presumably because the documented bug caused a problem with the rolled over data that the reports reference.

So what do I need to do to produce correct members position statements for 06-07.

Backup doesn't always work

BugHut — Fri, 21 Mar 2008 15:08:10 GMT

After entering my data I always backup my file. I use the menu Housekeeping, and select Create Backup. Mysf tells me the backup has been created. When I look at the backup directory, I sometimes see the zip file with size 1KB and the mysf file with 0KB. If I go back and do the backup again, it then works ok and gives me correct files. The way I became aware of this was I wanted to try a new transaction, so I created a backup, entered the transaction, wasn't happy with it, so I immediately did a restore from backup, and ended up with a live file with 0KB, ie, lost everything. Fortunately I had an external backup from the day before and could restore from it.

Year rollover "out of balance" error

remp — Sun, 23 Mar 2008 02:22:39 GMT

Hi.

I have entered all my transactions from 1/7/2005 up to 29/2/2008 then reconciled with bank accounts.When i rolled over to year 2006 an error " out of balance " appeared This error seem to have come from an entry entered 22/8/2007, To correct balance I use the decrease button then continued with rollover.

I next rolled over to year 2007 and an out of balance error appeared again this time it seem to have come from an entry entered 31/8/2007.

Can you tell me what's happening and how to correct this?:unsure:

Thanks

member allocations - rollovers ignored

PP Super — Sun, 09 Mar 2008 01:25:39 GMT

First off - I realise that this is not a bug as such in that, strictly speaking, MySF does make the member allocations according to the formulas as stated:

[quote]Formula 1 (this is the default selection)
Member Opening Balance+ 50% of Contributions for the member divided by Total Opening Balance of the fund + 50% of Total Contributions.
In this first formula the use of the 50% value averages the contributions made over the year.
Formula 2
Member Opening Balance + 100% of Contributions for the member divided by Total Opening Balance of the fund + 100% of Total Contributions.
Each formula will give a slightly different result.[/quote]

However, for our fund I found that this actually gave a very unfair allocation because I hadn't realised that for the purposes of the member allocations rollovers from other super funds are not included as "member contributions" in the allocation formula.

Using the example of our fund to illustrate the problem:

The first year of our fund - so all opening balances are zero - so either formula 1 or formula 2 will give the same result, ie member allocations are directly in proportion to member contributions. So I did the year end rollover and left it at the default formula 1.

Our fund is a two member fund with one member (me) using it as my sole fund, whilst my other half uses it as a secondary fund to her (work)government super the result is that our respective fund balances are around 98.5% to 1.5%. So I didn't initially notice that the allocations calculated were inappropriate at around 99.7% and 0.3%.

After we completed the accounts, we sat down to see how our fund had been doing and I was quite pleased to calculate that the fund had returned 22.9% over what had been only around 9 months of operation. (Based on profit distributed as a percentage of the total input of contributions and rollovers).

Unfortunately, when we did the same calculation for our individual situations, my other half was far from impressed to find that my return was 23.2% whilst hers was 3.5%!!

The reason for this was found in the breakdown of the funds paid into the super, which was (rounded to 0.1%):

My rollovers: 36.9%
My personal contributions: 61.6%
Her rollovers: 1.4%
Her personal contributions: 0.1%

In other words nearly all her balance had come from funds rolled in - whereas over 60% of my balance had come from personal contributions.

I think, as a minimum, you need to make it clear that rollovers from other super funds are not included as "member contributions" in the allocation formula. However, it seems to me that logically an equitable allocation must take into account funds rolled in as well as personal contributions, in fact it would not be unusual for funds rolled in to exceed personal contributions. If you do not think it is appropriate to just change your formulas to include funds rolled in then at least offer them as an option, eg:

[quote]Formula 1 (this is the default selection)
Member Opening Balance+ 50% of (Contributions + Transfers in) for the member divided by Total Opening Balance of the fund + 50% of Total (Contributions + Transfers in).
In this first formula the use of the 50% value averages the Contributions & Transfers in made over the year.
Formula 2
Member Opening Balance + 100% of (Contributions + Transfers in) for the member divided by Total Opening Balance of the fund + 100% of Total (Contributions + Transfers in).
Each formula will give a slightly different result.[/quote]

Taking this further, the formula should really allow for outward rollovers also - though typically this would be more unusual so a case could be made for making this optional rather than default.

I realise that you always have the option to override the default formula to account for anomalous situations - it just seems to me the default formula should better account for the fairly normal situation of significant rollovers into (or out of?) the fund.

By the way, I have restored domestic harmony by promising to make a personal contribution for my other half of somewhat more than we shortchanged her!

Members Position Report

atkins12 — Mon, 03 Mar 2008 23:23:24 GMT

Hello

Since updating to version 4 I have not been able to successful run a Members Position Report. Each time I run the report an error message "There are no records for this report" appears.

Just in case my file may have been corrupted, I restored an earlier version of the file, from which I had, under the previous versionof MYSF, successfully run the report. No joy, the error message still appeared.

Regards .... Ron

End of year rollover errors

PP Super — Sun, 17 Feb 2008 04:33:16 GMT

I am trying to finish off the 2006/2007 accounts, but all that I seem to do is come up against bug after bug in MySF :(

I have just done the end of year rollover (luckily making sure I have an unrolled copy to revert to in case of problems).

The rollover seemed to go OK. But then I went to generate the end of year reports and there are MAJOR ERRORS - and they are not just display problems with the report generator but some are actual transactual errors.

The main, and most obvious error is in the end of year share revaluation and writing to the increase in market value:

If I look at the "revaluations" report I can see that for all the shares I purchased by off-market transfer, the "Start Value" is given as the cost of the shares, as it is for the TLSCA installment receipts purchased by cheque. However all shares purchased on the ASX through Commsec show a "Start Value" of zero.

The "End Value" is correctly shown in all cases with the result that the "Difference" is correct for all the shares showing the cost as start value but for all the ASX purchases, the "Difference" is shown as the full market value of the shares on 30/06/2007.

Consequently I have an error in excess of $300k in the increase in market value. This also flows on to the balance sheet so that the fund assets are inflated by the error.

Interestingly, If I now do an asset listing summary for 30/06/2007 it correctly shows the cost for ALL assets. However the transaction reporter shows me that the actual end of year transaction posted is the WRONG inflated increase in market value.

I have double checked the original purchase transactions and the only difference I can see between the correctly processing OMTs and the ASX purchase giving the problem is that the ASX transactions have brokerage and so give 3 line transactions rather than the simple 2 line credit/debit of the OMTs.

I know the splitting of the purchase into price/brokerage lines should not make any difference - but the problem is clearly limited to the ASX purchases and that is the
only difference that I can think of.

The other problem is with the profit and loss statement, taking the 6 sections in turn:

Income: Seems OK
Expense: Seems OK
Profit/Loss: Seems OK until the "plus non assessable income" and therefore subsequent profit (see next)
Non-assessable Income: Lists ALL income, ie non-assessable income that SHOULD be included plus all the assessable income already listed under "Income" also has the WRONG value for 4210 Increase in Market Value.. as discussed above.
Non-deductible Expense: Lists ALL expense, which in my case was all deductible and already listed under "Expense"

However, the totals shown under Non-assessable Income & Non-deductible Expense do not reflect the figures listed above them.

For the Non-deductible Expense, the total is correctly shown as zero below a listing of three line items with costs that were incorrectly shown (having already been shown at "Expense"

Similarly for Non-assessable Income, although ALL income is listed, the total represents only the non-assessible component - though in error due to the increase in market value error.

What on earth is going on here?

I got this software because it was supposed to make all this stuff simple, reliable & accurate - I'm really starting to question the wisdom of that decision.

HELP please! I'm really running out of time here.

Rounding errors (limitations) in 'at market' sales

lawrie — Tue, 27 Mar 2007 05:42:28 GMT

I recently sold several share holdings 'at market' price, and consequently sold various parcels of the complete holding for a range of discrete prices. The contract not for these sales showed the average sale price displayed to 6 decimal places. Beacuse MySF rounds to 4 decimal places, the journal entry created for the sale posts incorrect amounts to the bank account and profit/loss.Is there some way around this, other than to create an additional journal transaction to adjust the (incorrect) sale entry? This approach leads to a lot of small entries in the bank account that never match any real transaction on the bank statement!While you get to view the details of the sale entry to be recorded, there is no way to alter it at that time. I attempted to manually adjust the general journal after it was saved, but this fails becuase the share (asset) has been sold and MySF will not permit changes to transactions on assets that are no longer current.This leads to a second issue ...If a dividend payment is received after a share has been sold, the cash receipt cannot be recorded against it because it is no longer an asset - there needs to be a way to enter these dividends/distributions without having to reverse the sale first.