I don’t use BACS but I would find it very useful to have a PDF or CSV report of payments to make on my banking system.
I currently go through the ‘money you owe’ link from my dashboard and tick the boxes for invoices for a particular supplier so that I can get a total to pay. If I could go through all of these and tick the ones I wanted to pay, then press a button for ‘Export payment list’ that would then group or sort by supplier, with sis total, that would be really helpful.
Of course one issue with this is that it doesn’t include any credit notes on a suppliers account, so you would have to be aware that there might be a credit to deduct before you pay (or perhaps you could include credit notes on this screen as this is the true figure of what you owe).
If you select the suppliers you want to pay then click ‘More Options’ you can then get a CSV export of these. The only thing missing is, as you say, any part payments already made or credit notes applicable.
Hi
Would like to kindly request a Company Month end BACS or cheque run Report, including Tags as per Thread link below.
Purchases>>Outstanding Purchases, and ticked SHOWTAGS,
then exported into Excel
Sorted by Supplier Name
Then Outline Subtotal on change in Supplier Name, sum, Add subtotal to, Total Amount.
This will then tell us what we owe our suppliers and any invoices that we don’t want to pay yet. We would then normally use this report to create a BACS payment schedule within our Online Banking.
@ChrisatIIOnline - I’ve merged your post into this thread which I’ve found, and updated to the title to reflect cheques too.
We can certainly investigate this further if there’s enough interest in this, so we’ll keep an eye on this thread and let you know if anything changes.
I’m pleased to say we’ve added a new report to allow you to export supplier payments and bank details in just a few clicks. You an find the blog post below:
Hi just wanted to say thanks for quick implementation, this feature helps us a lot, and I hope others.
Could you possibly add the TAGS as well to the EXPORT BATCH PAYMENT LIST, Detailed breakdown by Supplier.
We TAG our purchase invoices with TAG such as, DO NOT PAY, WAITING CREDIT NOTE, ITEM FAULTY, IN DISPUTE, etc. this is important as it stops us just paying the outstanding balances if we have any purchasing issues.
Minor request also list supplier in Ascending alphabetical order?
Thanks for this, seems to be all there, however we have 2 scenarios with this months BACS run,
We have been given a,
1.) Supplier Credit note on Account
2.) Supplier Credit note against a Purchase Invoice
Both of which are not shown on the Export Batch Payment List?
Can this be added to this Report or if not how do we generate a clear Payment Report to show what we should pay a Supplier?
(Note: I have noticed that,
Dashboard - Supplier Management, Invoice Balance only shows Purchase Invoice Total and not actually what we owe the Supplier?
Dashboard - Supplier:, Account Balance at a Glance, Total does actually show what we owe, but I can’t generate a Report/List of Purchase Invoice/Credit notes to show clearly what to pay?
The View Outstanding excludes the Refund/credit? )
We make a distinction between invoice balances and prepayments (i.e. payments held on account). The batch payment report will not extend to prepaid balances on account. You would therefore need to assign these prepayments to your invoices before running that batch payment report.
The same situation applies in the the Supplier Management view, it will show your invoice balances in one column, you can then choose to display another column to show any separate prepayments.
If you believe that the batch payment report is running contary to what I’ve mentioned above we’d be more than happy to look into this if you could send a PM on the forum to @QFSupport or to me.
1.) Are you able to fix the column alignment on the Detailed Report - Supplier Totals, as they are one column out I,J,K, should be J,K,L ?
1.) Can you add date filtering before the report is run so we can run Batch payment detailed Report for only due invoices (we have 30 days end of month terms) and need a report once a month.
2.) Also what are you using to generate these reports ?
3.) Is this report tool available to the user?
4.) Can this report Tool be implemented as an online browser tool?
5.) What other functions and Fields do you have availble to generate these reports post csv?
6.) can you add CNxxxxx’s (credit notes) data to the report for unpaid invoices?
7.) If we can’t add CNxxxxx’s (credit notes) is there a way to produce a report that mimics our Suppliers paper statement that shows, Payments/Invoices/Credit notes/opening balance/closing balance. This would allow our account department to have a tick list to use with the physical paper invoices and credit notes we have sent to us, this would then give us the reassurance we are paying the correct amounts to our suppliers.
Just to let you know our current Cheque run involves over,
18 Suppliers
100+ invoices
7 credit notes, relating to both Unpaid and Paid Purchase Invoices
and a significant amount in £’s
Currently its taking all day to figure out if we are paying the correct amounts and streaching our confidence as to whether we are paying the right amounts.
This will be fixed in the next release (later today)
Building a web UI may be possible but it’s not a quick task I’m afraid. The original intent with this report was to create a machine readable output that could be fed into another system for automating the BACs run. The current reports are generated by our application, it’s a simple CSV output.
It’s a hard-coded module that produces 2 different reports, there are no means to tweak. Although you can do a fair bit of ordering and formatting in Excel.
See 2.
Can you please clarify?
6,7. This would involve a significant overhaul so I’m afraid we can’t commit to that right now. The report is designed to output the outstanding balance across all supplier invoices. If an invoice has a credit note attached that reduces the balance, that figure is included in the totals (on both the abbreviated and detailed report). Showing the invoice gross amount then itemising and deducting the credit notes would involve significant redesign that we aren’t able to commit to at this time.
This shouldn’t be the case. If you have credit notes against any invoices they should be factored into the balances on both abbreviated and detailed reports. Those aggregate balances should reflect what is owed to the supplier, with the exception of prepayments on account, but in such cases you’d need to assign the prepayments to first then run the batch payment report.
Yes unfortunatley we are manually adding to this CSV,
date filtering
adding CNxxxxx’s (Credit notes)
add a running balance column,
and subtracting Balance from GBP_Total column which creates a Red -ve number if it has a Credit note assigned to it to help us see that it has had a credit note assigned.
I’m in the process of looking at marcos or importing to a excel template, but want to get as much POST formating options sorted with your good selves first.
After reformating the CSV, we check against our supplier paperwork and statements. We would not pay a supplier 1000’s of £’s without tallying PO’s and credits they have issued.
I would be happy with the balances on the reports if, either I could see how the total has been derived (what QF’s and CN’s are included) or guarantee our staff enter Credit notes against Unpaid PO’s correctly, but at the moment we are having to manually check if the credit or credits are included especially if more than one credit is issued to a PO.
In the CSV process what other fields can you export?, i.e. at the moment you are using,
SUPLLIER_NAME,
ID,
PURCHASE_NUMBER
etc,
So are there other Fields you can add in a column?, such as PURCHASE_CREDIT_NUMBER, and if so what fields are they?
What other Functions can you do before generating the CSV?
Example can you create a running Balance column as per my origianl post picture above?
Can you do maths or logic?
Finally can you interrogate the accounts “Database”, (I assume the accounts are a database?) directly from Excel, simular to the way there used to be for SAGE using there Excel Integrated Reporting for
Sage Line 50 ODBC (Open Database Connectivity) driver?
