Execel Formula and function

Copper Contributor

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 equalDate16-Jun 
 delta (i.e., the change) of cash position (bottom right). Triple Page1 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.09LIABILITIES    
           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.57CHANGE 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

 

 

0 Replies