Forum Discussion
Execel Formula and function
Hi everyone! I need support to display my tracking accounting report which shows profit/loss(net location)f rom side and other side display location & delta beginning cash position
| MY COMPANY | ||||||||||
| [Note: Below are two completely independent accounting | Accounting Report | |||||||||
| reports. Yet, the profit/loss of mailings (bottom left) must equal | Date | 16-Jun | ||||||||
| delta (i.e., the change) of cash position (bottom right). Triple | Page | 1 of 1 | ||||||||
| control: 1) self-proofing 2) accurate profit/loss 3 location of | ||||||||||
| every dollar.] | ||||||||||
| May Mailing Profit/Loss | May Cash Location & Delta | |||||||||
| Net Revenue | Beginning Cash Position | $323,280 | ||||||||
| E-Mailing 24 | ASSETS | |||||||||
| Inventory | ||||||||||
| Total Direct Costs____________$65,229.89 | Brochures | $38,552 | ||||||||
| (131,935 pieces @49.4 cent) | Coupons | $22,848 | ||||||||
| Revenue___________$75,598.60 | Envelopes | $25,081 | ||||||||
| (1,540 orders @$49.09) | Products | $73,703 | ||||||||
| Net_____________$10,368.71 | Total | $160,185 | ||||||||
| E-Mailing 25 | Cash On Hand - Accounts | |||||||||
| Bank of America $(11,718) | ||||||||||
| Valley Bank $(10,623) | ||||||||||
| Total Direct Costs____________$33,805.75 | Total | ($22,341) | ||||||||
| (68,530 pieces @49.3 cent) | ||||||||||
| Revenue___________$30,288.53 | Cash Expected In - Receivables | |||||||||
| (617 orders @$49.09) | MC/Visa | $32,255 | ||||||||
| Net_____________ <$3,517.22> | Club Cards | $12,995 | ||||||||
| Total | $45,250 | |||||||||
| E-Mailing 26 | ||||||||||
| Cash Invested | - Future Mailings | |||||||||
| Mailing 28 | $77,270 | |||||||||
| Total Direct Costs____________$44,249.58 | Mailing 29 | $70,010 | ||||||||
| (89,552 pieces @49.4 cent) | Total | $147,280 | ||||||||
| Revenue___________$47,273.67 | Total Assets | $322,439 | ||||||||
| (963 orders @$49.09) | ||||||||||
| Net_____________ $3,024.09 | LIABILITIES | |||||||||
| Account Payables | ||||||||||
| E-Mailing 27 | Unshipped Orders | ($1,605) | ||||||||
| Invoices | ($15,360) | |||||||||
| Refunds | ($13,290) | |||||||||
| Total Direct Costs____________$17,369.51 | Total Liabilities | ($30,255) | ||||||||
| (35,037 pieces @ 49.5 cent) | ||||||||||
| Revenue____________$25,134.08 | ||||||||||
| (512 orders @$49.09) | Ending Cash Position | $300,119 | ||||||||
| Net_____________ $7,764.57 | CHANGE IN CASH POSITION | |||||||||
| Expenses | (Ending minus Beginning) | |||||||||
| Less General Overhead | $18.17 | Ending | $300,119 | |||||||
| Less General Freelance | $22.63 | (less) Beginning | $323,280 | |||||||
| Profit Loss $ < 23,161 > | Delta $_____< 23,161 > | |||||||||
Looking forward to read from you soon
No RepliesBe the first to reply