Now for each customer I have spreadsheet with list with such columns
1. Data when invoice is issued or payment made
2. Sum of invoice
3. Sum of payment
4. Number of invoice or number of payment document
5. Date of payment (date,
I take bank statement where is written what invoices are paid with certain payment.
Then in row where is recorded sum of issued invoice, I write date of payment from bank statement.
If with one payment are paid several invoices and sum of invoices and paid sum does not match, then I must filter by date of payment to check which payment does not match.
Can someone advice more effective, simple and faster way? Which software is more suitable?
