EFARLEY PRODUCTIONS©

SYSTEMS OF PROCESSING

 

ACCOUNTING DATABASE

 EFPS | #1002| Last Updated May 30, 2015

Select and register system number in Database

 

 

System Description  This system has been created to ensure that we have accurately recorded all funding in association with Efarley Productions. Follow the steps closely to ensure that we have accounted for everything.

 

 

REGULAR MONTHLY ACCOUNTING | UPDATING

 

  1. In the Paypal account Print the reporting month (Detailed)

 

  1. In the Client Database click on EFS15

 

  1. Regular monthly reoccurring items are preset in the lower database fields to make starting a new month cycle less time consuming. Count the number of preset items, and open enough new rows on the tracking log section to paste a new copy of these lines.

 

  1.  Select the pre-typed items, copy, and past them into the next available lines in the tracking log.  

 

  1. Once items have been copied to the tracking area, update all fields as appropriate for the current month.  (Dates /Invoice No. Etc)

 

  1. Remember to check report for other items sold in the reporting month.

 

  1. Clear all totals in the total lines (Column E through Column P) Rundown totals on newly added items only. (Gray Fields)

 

  1. Update the reporting month to the appropriate month

 

  1. Input all totals into the reporting fields at the bottom of the form.

 

  1. After all updates are made, Clear all totals in the    total line,  (Column, E thru Column P) Recalculate all items and match totals.

 

  1. Update the (Last Updated Date) at the top right hand corner

 

  1. Hide all lines between heading and reporting area

 

  1. Print Report

 

  1. After the report has been printed, unhide lines

 

  1. Remove Gray background on non bus purchases

 

  1. Gray out all items that are closed and completed.

 

  1. DATA SORT BY:  RM |SALES STATUS | ITEM |ASSENDING

 

  1. Save

 

 

ACCOUNTING AMENDMENTS | UPDATING

 

  1. In the Client Database click on EFS15

 

  1. Update the report month below with YTD Info

 

  1. Type an amendment note below report

 

  1. print the latest report showing amendment note

 

  1. Last updated field

 

  1. Save

 

All updates must be notated, buy changing the “Last Updated” date above, and emailing the newly updated system to

larryefarley@efarley.com