I am looking for a solution to two apparent reporting limitations in Xero.
We issue clients a single invoice each year which they have the option to pay in 12 monthly instalments. We don’t currently use a direct debit payment platform, and the clients pay directly into our bank. Each month one or two of them fail to pay.
We have not been able to find a way in Xero to create monthly reporting on whether any of the payments due that month are missing.
We have also not been able to find a way to create a report of accrued income – a forward view of monthly payments that are coming due each month for the next year.
This currently creates a substantial bookkeeping burden of keeping a manual spreadsheet of monthly payments made and due outside of Xero.
I would like to find a solution to automating these reporting needs, and I don’t imagine that I’m the only person that has this need.
I would welcome offers to solve this problem. I am open to using 3rd party software if that is necessary.
Mac Excel Gantt Chart Builder Category: Data Visualization, Excel, Excel Macros, Excel VBA, Microsoft 365, Microsoft Access, Visual Basic, Visual Basic For Apps Budget: £20 - £250 GBP
17 Feb 2026 11:00 GMT
Lead-Focused Meta Ad Management Category: A / B Testing, Advertising, Analytics, Digital Marketing, Google Adwords, Internet Marketing, Lead Generation, Sales Budget: ₹1500 - ₹12500 INR
SEO & Speed Optimization for Perfume Website Category: Digital Marketing, Google Analytics, Internet Marketing, Link Building, PHP, SEO, Web Development, Web Services, Web Design, Website Optimization Budget: ₹1500 - ₹12500 INR
17 Feb 2026 10:53 GMT
Dynamic Multi-City WordPress Pages Category: CSS, HTML, Page Speed Optimization, PHP, SEO, Web Services, Web Design, Web Development, Website Optimization, WordPress Budget: ₹600 - ₹1500 INR
