I’ve taken the steps a number of times to try to determine where things are falling down. I’ll paste screen shots here and maybe you can see something I’ve missed.
I re-instated an old product I no longer sell which had it’s own account in chart of accounts. That way I can see the month when (which month) the payment is made.
I created an invoice for that product on a 30 day end of month option (I use the date paid and account etc that you mentioned all the time… great and useful feature!).
Then, I paid the account. The payment was mad in the month after the order was placed and shipped (validated).
I registered the account in the ledger and noticed the date of this is the invoice date and not the payment date. No ability to change this though…
This is how it appears in the bank journal…
Finally, I looked at the month the payment occurred in reporting section of Accounting and it appears in the month of invoice (July) and not month of payment (August)
Anything you can see that I’ve missed would be of great assistance. Using ‘Reporting by personalized groups’ is perfect for my accountant to use when I give him a snapshot of my accounts, but unfortunately it’s not accurate ATM.