Skip to main content

I have questions regarding open items: for annual financial statements we need an open items list. It has to show all outstanding customer payments not yet having been paid, even if closed after this date.

If the path ‘open bill’ - ‘payment’ - ‘external payment’ is chosen, there`s no way either to give in past payment dates. It follows that the accounting ledger report shows items as unpaid as long as ‘external payment’ is done, no matter what the real payment date was.

Hello @Guido

thank you for the great question!

The report you are looking for is Accounting ledger. You can set up the date in the filters on the right side, and the report will show what the ledger looked like on that date. So if you had open past bills (open past revenue column) open on that date, they will show in that list, even thought they might be closed at this very moment. 

I hope this helps :) 


Hello Alzbeta,

thanks, I knew the report before. Problem remains with those bills as of December, that have been paid in Banking account at the end of December, but where the clerk closed the case in January. Thus, the report says as of Dec. 31: ‘unpaid’.

Guido


Thanks, but the report for December 31st has the problem that bank payments that were settled before the this date only appear with the current date if <payments>, <external payments> is klicked after December 31st, and are therefore not balanced in the list for December 31st.
Guido

Hi Guido, 

I see. Unfortunately, the report shows how the system looked on that date. 

If you received the payments prior but did not post it into Mews until January, the system can not know when the payment was actually received in your bank account, only when it was posted. 

These cases shall be tackled manually.

I hope it helps :) 


Hello Alzbeta,

it helps, lots of thanks. But it was better, if one could fill in the real payment date in

<payments>, <external payments> so that the report fits german accounting principles on behalf of an adequate open items list (“Offene-Posten-Liste”).

Guido


Hi Guido, 

yes, I understand. 

Please feel free to submit this idea on our feedback page here, as I believe more users would agree with you, and it would also give us some more visibility and perspective on how important feature this may be :) 

Have a great day!


okay, thank you! Just been posting it there.

Guido


Reply