Organising Aged Payables

Question

Hi,&nbsp;I am trying to organise the Suppliers on the Aged Payables (simple) report to make it easier for a) the owner of the business to see which bills need to be paid vs which bills are direct debit and don't need to be actioned, and b) myself so I can see which bills can be paid electronically and which bills (BPAY) need to be paid manually.&nbsp;Since the payables is sorted by name, I wanted to re-import our suppliers with the payment type added to the front so it is grouped accordingly, e.g:'BPAY SUPPLIER1''BPAY SUPPLIER2''DC SUPPLIER 3''DD SUPPLIER 4'&nbsp;The issue with this is when putting invoices on the system, you can't allocate cards by searching partial supplier names - it has to be the supplier's name in full from the beginning.&nbsp;Is there any simple way of organising the payables and splitting between the different payment types? I know there would be some way of organising the Aged Payables (detail) but we need the simple report so the owner can make decisions without being overwhelmed by a breakdown of each individual bill for each supplier, we need just the snapshot&nbsp;Thanks,

mike_james · Answer

Hi ChrisLear&nbsp;, welcome to the forum.&nbsp; I don't recommend your suggested approach.&nbsp; What you could do is add identifier values to all the supplier records,&nbsp; eg B for Bpay and D for direct credit,&nbsp; then I believe you can filter the report accordingly. The editing can be done via export- import,&nbsp; take a backup before any major import.&nbsp;&nbsp;I'd also recommend using the reconciliation versions of the aged payables and receivables reports,&nbsp; where the date is a true cut off. People are often confused when eg April invoices appear on their "March" aged payables.&nbsp;

chrislear · Answer

Hi Mike, thanks for the quick reply. Is there any way to keep all of the outstanding bills in the same report rather than filtering by identifier values and generating 3 separate reports?

EDIT: Also from what I can tell, using the identifier values won't help in us knowing which bills are BPAY and which can be paid electronically. Currently I can tell because if we go into pay bills -> and tick electronic payment, if the statement text is "Payment xxx" then we don't have bank details saved in their card and it will be BPAY but I want it to be as simple and visually obvious as possible

Thanks again

mike_james · Answer

Hi ChrisLear&nbsp;, I don't think the report can be grouped by identifier,&nbsp; and usually applying a filter means the report is just for one value.&nbsp;&nbsp;I'll think about your other query.&nbsp;

mike_james · Answer

Hi ChrisLear&nbsp;, I'm wondering whether you can set up different payment methods for each supplier, and add that as a field to the payables report.

mike_james · Answer

Hi ChrisLear&nbsp;, drew a blank there, payment method is not a field that can be added to the payables reports, pity that!

Forum Discussion

Organising Aged Payables

Looking for something else?

Related content

Customer aged payables report

Dates on Aged Payables

Aged Payables Summary

AGED PAYABLES OUTSTANDING PURCHASE ANALYSIS

Super payable portal

Aged Payables or Aged Sales reports AS AT date selections

Unable to Pull Aged Receivables and Payables report with back date/period

Currencies" filter for Ageing Receivable [Summary] and Ageing Payable [Summary] reports