Skip to main content
Solved

Open items list for annual closure


  • Superstar Apprentice

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.

Best answer by alzbeta skrabalkova

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 :) 

View original

alzbeta skrabalkova
Mews Employee
Forum|alt.badge.img+5

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 :) 


  • Superstar Apprentice
  • June 5, 2023

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


  • Superstar Apprentice
  • June 7, 2023
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

alzbeta skrabalkova
Mews Employee
Forum|alt.badge.img+5

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 :) 


  • Superstar Apprentice
  • June 7, 2023

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


alzbeta skrabalkova
Mews Employee
Forum|alt.badge.img+5

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!


  • Superstar Apprentice
  • June 7, 2023

okay, thank you! Just been posting it there.

Guido


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings