Inside my deposit workbook are daily deposit sheets with the customer's checks broken down into detailed columns. i.e. deposit amount, taxable merchandise, taxable shipping, sales tax, non-taxable merchandise, etc...
The majority of time one check will pay multiple invoices with each invoice amount different. I presently use a calculator to total the amount for each cell, then enter that amount into the appropriate cell under the appropriate column. Is there a formula that I can utilize that will allow me to do the math in the cell itself? I am not at all familiar with macros but if one is required I would surely make use of it. I would very much appreciate it if someone could help me with this. Anyone familiar with QuickBooks will know what I am talking about.
Bookmarks