Hi, can anyone advise if there is a way we can match bank payments to invoices either offline in excel or as a batch on sage 50 accounts?

We currently run high volume payrolls on sage payroll, and make the payments through sage payroll. We then import the data to sage 50 accounts, and this generates hundreds of small supplier invoices on sage accounts. We then have to match the bank payments (one large payment for several hundred invoices). This takes days, literally, every week.

Is there anything that can be done to make this process less painful?

We have to bring the individual's data across to sage 50 accounts, as we have to deduct CIS from the individuals, this is done on sage 50 accounts with the CIS bolton, as sage payroll does not manage CIS.

I am hoping there is a way to bring the payment information across from sage payroll, or match the payments to the invoices off line in excel, or work with a sage developer to give us the facility to either bring the matched data across from sage payroll, or match it all in bulk on sage accounts. The way the team here do it now is so time consuming, there has to be a better way!

Many thanks in advance for any help or guidance.