I would like some guidance on how to enter invoice data in a spreadsheet.
Example has been copied below.
Some vendors only send an invoice once per month which would work perfectly with this type of layout. But some of the other vendors send multiple invoices per month. I would like some suggestion on how I can input multiple invoices into a chart while keeping all the other vendors' invoices in an organized manner. I would greatly appreciate the help.
Thank you.
| VENDOR | Invoice # | Date Coded | Date Approved |
| Staples | | | |
| Hamster | | | |
| Imperial | | | |
| Barocco | | | |
| GFL | | | |
| CBSC Capital Inc. | | | |
| Canon | | | |
| Rogers | | | |
| Tyco | | | |
| National Leasing | | | |
| Pitney Bowes Leasing | | | |
| Pitney Works Postage | | | |
| B.Zee Brokerage | | | |
| Swift2Go | | | |
| FedEx | | | |
| Extreme Reach | | | |
| Iron Mountain | | | |
| Beck Taxi | | | |
