danhendo888
Board Regular
- Joined
- Jul 15, 2019
- Messages
- 167
- Office Version
- 365
- Platform
- Windows
https://1drv.ms/x/s!AvjBsEPEq12ngR1M8FneK-3B1Ew7?e=1pqHkd
Hey guys,
Let me explain my setup.
This workbook is what I use to manage invoices that we pay to other companies.
Company (1) sends us invoices. We'll pay them.
Each week, Company (1) will send us a statement with a list of overdue/unpaid invoices.
I will copy and paste the invoice numbers from the statement onto the sheet called Company (1).
Then the formulas in Columns G to Columns U will populate. The formulas look at the data in Sheet2.
The populated results tell me:
- which invoices have been booked
- which invoices have been paid
- the date it was booked
- the date it was paid
Sheet2 is where I paste the data. I usually delete all the rows and paste the updated again every day.
There are approx. 20,000 rows.
I have 20 more sheets (in the same workbook) that look identical (same column, formulas) to Company (1) representing the other companies' accounts.
Total file size is ~ 14 MB.
Looking for ways to improve this process (however big or small the change), I would love to hear your thoughts, opinions, what would you do differently, what would you change etc.
Hey guys,
Let me explain my setup.
This workbook is what I use to manage invoices that we pay to other companies.
Company (1) sends us invoices. We'll pay them.
Each week, Company (1) will send us a statement with a list of overdue/unpaid invoices.
I will copy and paste the invoice numbers from the statement onto the sheet called Company (1).
Then the formulas in Columns G to Columns U will populate. The formulas look at the data in Sheet2.
The populated results tell me:
- which invoices have been booked
- which invoices have been paid
- the date it was booked
- the date it was paid
- how many entries were made to book the invoice
(e.g. was a $100 invoice booked as $100 once, or was it booked two times: $60 + $40 = $100
- the internal reference number of the booking entry
- the total amount of that booking entry(e.g. was a $100 invoice booked as $100 once, or was it booked two times: $60 + $40 = $100
- the internal reference number of the booking entry
Sheet2 is where I paste the data. I usually delete all the rows and paste the updated again every day.
There are approx. 20,000 rows.
I have 20 more sheets (in the same workbook) that look identical (same column, formulas) to Company (1) representing the other companies' accounts.
Total file size is ~ 14 MB.
Looking for ways to improve this process (however big or small the change), I would love to hear your thoughts, opinions, what would you do differently, what would you change etc.