imaginethis
New Member
- Joined
- Feb 5, 2022
- Messages
- 2
- Office Version
- 2021
- Platform
- Windows
I hope everyone is healthy and doing well, I have been tracking my accounting invoices/payments into an excel spreadsheet up until recently using Excel 2003 entering all the raw data and manually doing the totals, I just got Excel 2021 and would like to automate the process as best as possible and would appreciate anyone who could assist.
My header columns are as follows;
BANK DATE - INVOICE DATE - CHEQUE DATE - INVOICE # - CUSTOMER / SUPPLIER - CATEGORY - PRODUCT / DESCRIPTION - QUANTITY - $PRICE PER UNIT - $SUBTOTAL - $SHIPPING - $FEE EBAY - $FEE PAYPAL - $GST - $HST - $PST - $TOTAL - CURRENCY - BANK ACCOUNT - BANK BALANCE
I would like to add formulas to the spreadsheet that will generate monthly & yearly totals based on CATEGORY and other columns like CUSTOMER / SUPPLIER and PRODUCT / DESCRIPTION.
I really appreciate any help that would make my spreadsheet far more automated/useful for tracking then it currently is very tedious/manual.
Thanks!
My header columns are as follows;
BANK DATE - INVOICE DATE - CHEQUE DATE - INVOICE # - CUSTOMER / SUPPLIER - CATEGORY - PRODUCT / DESCRIPTION - QUANTITY - $PRICE PER UNIT - $SUBTOTAL - $SHIPPING - $FEE EBAY - $FEE PAYPAL - $GST - $HST - $PST - $TOTAL - CURRENCY - BANK ACCOUNT - BANK BALANCE
I would like to add formulas to the spreadsheet that will generate monthly & yearly totals based on CATEGORY and other columns like CUSTOMER / SUPPLIER and PRODUCT / DESCRIPTION.
I really appreciate any help that would make my spreadsheet far more automated/useful for tracking then it currently is very tedious/manual.
Thanks!