Hi,

I have an old account that I have imported from Quicken, I just closed it in my bank and I just wanted to do a full report on this account.

I find it strange when the report Total show that the account was in negative instead of zero as it should be (and as it is written in the register).

After some investigation I found that the very first line of the register (the initialization of the account when I switched from paper to Quicken) don't show in the report, hence the difference in the total.

How can I correct that ?

Thanks

Hello,

Once you've opened the report you might want to start by clicking on the 'Configure' button then check the date tab, often the reports default to the current year.

You can edit this date range to before the earliest transaction in your account.

I have not set any date, the report is configured as "All dates" (if I translate right)

The opening transaction date is 1st September 2005, the report shows columns from September 09 to May 2011 (month of the last transaction on this account)

If I select from January 2005 to today, the problem is still the same.

The opening transaction is quite strange as it is define as a Transfer. Maybe that is the problem (remember that this come from a Quicken import).

Ok, that sounds about right, it was just a thought.

Does the opening transaction which shows as a Transfer have a payee (or 'Pay To')?

If not there is another option in report configuration on the Payee tab called 'Select transactions without payee'. I haven't used this option myself but try running the report with it enabled and see if there is any difference.

The transaction doesn't have a Payee.
If I select this option in the Payee tab, the report becomes blank (no transaction at all, only 2 lines with zeros).

BTW, thanks for your help on that.

I can only think of a couple of other things:

1. Check the opening date of the account using Account...Edit Account and make sure it is correct
2. Edit the first transaction and give it a Payee

Try one at a time, run the report and see if either help.

Opening date of the account was 01/01/1995, I set it to 1st sept 2005, same problem.

I add a Payee to the transaction, same problem.

This is very strange...

Oripy wrote:This is very strange...

You are not wrong!

Ok, my final guess.

I just imported my latest bank statement and notice that transactions which do not have a category i.e. show in the ledger as '*** UNASSIGNED ***' do not appear on reports.

Does your opening transaction have a category? It should be assigned to 'Opening Balances' but it might not because you imported the data from Quicken.

The category is "Solde d'ouverture", which mean "Opening Balances" in french, so I gess it's a translated string.

Well, that looks to be ok.

I'm out of ideas, sorry. BTW which report are you looking at?

Just a custom report: Only one account selected, All dates, Monthly report, transfers included, all categories, all payees.

I'm probably stating the obvious but have you tried any of the default reports to see if they show the missing transaction(s)?

It looks like you are both correct. The income/expense report does not include the initial balance nor unassigned categories. This is a bug in my opinion.

zebulon wrote:It looks like you are both correct. The income/expense report does not include the initial balance nor unassigned categories. This is a bug in my opinion.

Actually that is the way it should be. An opening balance is not an income/expense it's a transfer from an equity account into the account that is being open. The 'Opening balances' is not an income/expense account which makes sense because you already own that balance.

Transactions without assigned categories are not transactions from income/expense accounts. The usually appear in you asset/liabilities accounts and don't have the other end set (the destination account). So why should they appear in your income/expenses report? After all the unassigned transaction could be a transfer to another account as much as it could be an income/expense. KMyMoney has no way of knowing what it is until you actually assign an account to it.

Oripy wrote:Just a custom report: Only one account selected, All dates, Monthly report, transfers included, all categories, all payees.

So in which report category does your custom report falls? Opening and closing balance are only provided in transaction reports. Check the standard report "3. Transaction reports/Transaction by account" which shows opening and closing balances for each account. These numbers should match the figures shown in the ledger.