Mar 20 2022 10:39 AM
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