How can I download a list of what expenses have been allocated against what payments

Question asked by Michael Martin 7 months ago

My bank is asking me for a list of ultimately what expenses have been allocated against the payments. I can’t find anywhere in Clearbooks how to do this except going through each payment one by one and noting the expenses which is incredibly laborious and time consuming. Is there another way? Or a report/export I can download that does this?

5 Replies

Hi Michael,

Thank you for this. I will feed this back to our Product team for review.

And no problem at all, we really appreciate the detailed feedback!

Tommy

Hi Michael,

Unfortunately, we do not have an export for this. You will have to click into each payment to see which transaction this is allocated to. Alternatively, you can click into the expense and view the payment allocated.

Tommy

Thanks for the reply. That’s very laborious. Where is this on the roadmap? Kind of surprised Clearbook’s doesn’t have this feature tbh. Regards.

No problem! And currently, this is not on our Product Roadmap. However, we will reach out to you to better understand your business requirements and see if this could be implemented in the future.

Tommy

The business requirement is quite simple. Bank says to you “in order to keep your account open, we need to see receipts for every payment you’ve made” (feel free to change bank to HMRC) over x years

Now one has to look at 100+ payments and 800+ receipts. Where one could just have downloaded a csv of every expense allocation one can already download the list of payments, and a list of expenses, so shouldn’t be too hard to expose the expense allocation table.

I’ll write something with a screen scraper for now but I consider this to be necessary functionality in any accounting software that has an expense management capability.

Hope that helps and thanks for taking the time to reply, good to know that Clearbook’s listens.

Hi Michael,

Thank you for this. I will feed this back to our Product team for review.

And no problem at all, we really appreciate the detailed feedback!

Tommy

Reply to this question

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are