Home

PSL3 User Manual - Cast & Crew Entertainment Services

1. Once the void and or reissue process is complete PSL3 automatically updates the A P transaction s status as follows gt Original A P transaction s is marked with a V for Void gt Reversal A P transaction s is marked with an R for Reversal gt Reissued A P transaction s is marked with a U for Unposted to make any necessary modifications 2011 Cast amp Crew Entertainment Services LLC ACCOUNTS PAYABLE 1 1 5 Chapter 5 6 1099 Reporting Screens PSL3 offers 1099 Screens Reports which are listed below Open gt To access the following 1099 Screens Reports click the A P module then click the 1099 and 1099 ICR sub folders from the menu tree see following screen shot gt These additional 1099 Screens Reports are also located in the Report module under the Vendors sub folder gt You can also access these screens reports by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter ii Setup Y AP a Vendor da AP Entry Ea Checks gg 1099 ZA 1099 ICR 1099 ICR Report ficr1 099 1099 Forms and Report bd1099 ij Pio ij Pic i JE mi PR li GL ii Checks B Budget day Cost 3 Closing ay Recurring Batch 3 Report PSL3 Help EEE EEE EEE EEE To select criteria for the following reporting screens press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted
2. LA El E SAA Y y PSL3 User Manual 2011 Cast amp Crew Entertainment Services LLC All rights reserved No parts of this work may be reproduced in any form or by any means graphic electronic or mechanical including photocopying recording taping or information storage and retrieval systems without the written permission of the publisher Products that are referred to in this document may be either trademarks and or registered trademarks of the respective owners The publisher and the author make no claim to these trademarks While every precaution has been taken in the preparation of this document the publisher and the author assume no responsibility for errors or omissions or for damages resulting from the use of information contained in this documentor from the use of programs and source code that may accompanyit In no event shall the publisher and the author be liable for anyloss of profit or any other commercial damage caused or alleged to have been caused directly or indirectly by this document Compiled and Curated by Virginia R Rios Cast amp Crew Product Support Department Printed November 2011 Contents 5 Table of Contents Part Part Il 0 JO a FPF WD Part Ill Part IV Part V 1 HOW TO USE THIS MANUAL 11 PREFACE cc ER E ioe ctaudcgune A A cotedacecedetaeedeass 12 Audience NA 12 O O AO 12 Cast amp Crew Website Into aida 12 PSL3 System Requirements scsssssssssse
3. Budget Information BudgetName EEE Production rAdd Budget Lines for Account Range From Account first expense account To Account last expense account rFill Budget Lines With Series C a Location Set Currency To select criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 Budget Information e Budget Name Input the name of the budget which can hold up to six alpha numeric characters After entering the new Budget Name PSL3 asks Budget is not in the database Do you wish to create it Select Yes Please note each Budget Name must be unique Immediately to the right of Budget Name input the description ofthe budget which can hold up to 50 alpha numeric characters e Production Press the F2 Key or right click in this field if the Production Code for the budget does not already default Add Budget Lines for Account Range e From Account and To Account First and Last Expense Account to create in the budget To create all account numbers leave both fields blank Fill Budget Lines With e Press the F2 Key or right click in any of these fields Series Location Set and Currency to choose the necessary codes if t
4. Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format O 2011 Cast Crew Entertainment Services LLC 290 PSL3 User Manual Chapter 11 6 Additional Budget Screens PSL3 offers additional Budget Screens which are listed below Open gt To access the following Budget Screens click the Budget module then Maintenance sub folder from the menu tree see following screen shot gt You can also access these screens by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter a Setup a AP a Pio a Pic B JE a PR a GL aj Checks 4 Budget EFC Entry fefcent Variance Entry bdve U E E E t t t t Account Yariance Report bdvar Reference Variance Report bdvep Import a Budget bdint Budgetlisting fhadentn g CopyiMerge Budgets bdmove Create a Budget bdgl Delete a Budget bddel Budget Name Entry bdname a Cost Ea Closing Bj Recurring Batch a Report aj PSL3 Help To select criteria for the following screens press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the
5. NOTE Please note prior to using the Create Establish Recurring Batches rbcre program you must have already created but nof posted the template transaction in the transaction entry screen you plan to use the recurring batch in This template transaction is used to create the recurring batch transaction gt To access the Create Establish Recurring Batches rbcre screen click the Recurring Batch or Setup module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter The screen then appears ii Setup a AP aj Pio a Pic a JE a PR a GL ij Checks ii Budget 5 Cost 3 Closing ER EEE amp amp amp EEE E List rblist 3 Report 3 PSL3 Help t E 2011 Cast amp Crew Entertainment Services LLC RECURRING BATCH sat ee rbcre Establish Recurring Batches SEE 11061010101 151 2410 Batch number Frequency Clear All Daily Number of times to recur O Weekly Monthly Exit Quarterly Help Cancel Enter a valid batch number Selection Criteria e Batch Number Batch Number assigned to the template transaction you wish to make into a recurring batch This Batch Number was entered in the transaction entry programs P O Entry poent A P Entry apte Journal Entry jete etc Batch field Press the F2
6. Open gt To access the Void Open Items apvoid2 screen click the A P module then click the A P Entry sub folder from the menu tree see following screen shot gt Void Open Items apvoid2 is also located in the Report module under the A P sub folder gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter Ea Vendor Ea AP Entry Entry apte Edit List appost Post appost Open Items Report apopenp Modify Open Items apopmod defi Du 1099 a Pio a Pic sa JE sa PR a GL ij Checks aj Budget 5 Cost ii Closing ii Recurring Batch ij Report ii PSL3 Help HEE EEE EEE amp amp The screen then appears 2011 Cast amp Crew Entertainment Services LLC ACCOUNTS PAYABLE 1 1 3 a apvoid2 Void Open Item File Edit Programs Options View Favorites Help 1106101010115 1 5 0 HA Open Item Selection Refernco Number a Preview Edit Reissue Void AIP Print Edit Clear All Cancel EXit Help nter or pick reference numbers to void EE Open Item Selection e Reference Number Reference Number of the A P Open Item s which you want to void To choose multiple A P Open Item s press the F2 Key or right click in the Reference Number field and hold down the Control Key while simultaneously using your mouse to select e Reissue Check mark this option to create a new
7. e Name Input the name of the bank which can hold up to 30 alpha numeric characters e Enter the bank s Branch Address Contact Phone and Account if applicable Check Number Information e Starting and Ending Input the first and last check numbers from the current box of checks for this bank e Last Used Number of the last check used from the current box of checks for this bank Please note once printed the last used check number of the bank defaults in this field Currency Date Information 2011 Cast amp Crew Entertainment Services LLC 28 PSL3 User Manual e Currency Input the Currency Code associated with the Bank Code in which the currency for the checks will print Please note the Currency Code should default in this field depending on what information was specified on the initial database request If the Currency Code doesn t exist in PSL3 you can add it by pressing the F5 Key or selecting the Zoom icon located on the toolbar This zooms into the Currency Code Entry sucur screen in which you can add the Currency Code immediately Once saved press the F1 Key then F option or select the Fetch icon to fetch the currency back to the Bank Code Entry subank screen Date Format Date format in which the checks for this bank will print Press the F2 Key or right click to view and select the Date format options along with their descriptions which are as follows ce Date format Date format De
8. had no distributions posted to them but do have a non zero amount budgeted If checked the report displays these account numbers in the distribution lines 2011 Cast amp Crew Entertainment Services LLC 324 PSL3 User Manual e Open Items as Actual Costs Check mark to indicate if you want Open Items items posted but not yet paid displayed in the Actual Cost column Only P O s will be treated as Commitments e Committed Costs Check mark for the report to display a column for Committed Costs items entered in the database but not yet paid which consist of P O s and Open Items e Sub totals Check mark this option for the report to display Sub total amounts Selections e Press the F2 Key or right click in any of these fields Company Series Location Set Insurance and Free Field s to choose the necessary codes if they don t already default To choose multiple codes for a particular field press the F2 Key or right click in that field and hold down the Control Key while simultaneously using your mouse to select By making a selection this isolates the report to only display items based on the code s selected To display an additional detail column on the report for either the Company Series Location and or Set Code leave these fields blank and check mark the Detail option PSL3 will print a separate line for each account number and code combination selection Please note if you enter in a Company Series Locat
9. 3 PSL3 User Manual ee Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes X exit to menu v To delete an unused Production Code place your cursor in the specific Production Code you want to delete and press the F10 Key or select the Delete icon fu Red strike through lines appear which are deleted upon saving v To search for an existing Production Code press the F7 Key or select the Find icon when the screen is clear All records appear in which you can scroll through using the Arrow icons First Prior Next and Last l l or by pressing the Page Up or Page Down Keys until you find the code needed 2011 Cast amp Crew Entertainment Services LLC SETUP 35 Chapter 2 3 Company Code Entry Use Company Code Entry sucomp to set up a Company Code for your database If your database is associated with more than one company PSL3 allows you to input multiple Company Codes under the same Production Code to easily track separate costs Please note all independent PSL3 database are already set up with a default Company Code usually 001 but you can always change it if needed as long as it has not been used in PSL3 Open gt To access the Company Code Entry sucomp screen click the Setup module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue
10. Blank field Populated field Field Header field field Header field Distribution Transaction Field Result of pressing funetion key Displays command screen Commands shown depend on the accounting task and stage of data entry If available displays a drop down list of possible entries for the field If available displays additional information for the field Creates a new entry ready to be filled in and automatically fills in the reference number Creates a new transaction line ready to be filled in Accesses or adds information from a related program while keeping the Displays a C amp C web page with links to contact information in a blank field that is not entering a search criterion retrieves all the entries related to the program Searches for and retrieves entries from your database You can use search criteria including the wildcard to narrow down the entries retrieved Entering a value in one or more fields and then pressing lt F7 gt that is entering search criteria retrieves only the entries whose value for the fields match the entered values Moves your cursor back to the previous field where you can input data Duplicates the field value from the previous entry Duplicates the field value from the previous distribution line Marks the entire entry for deletion as shown by red lines through all header fields and distribution lines Marks an individual distribution line for deletion
11. JOURNAL ENTRY Secti JOURNAL ENTRY 149 Section 7 JOURNAL ENTRY This section will address the following programs gt Journal Entry gt Post JE Transactions Edit List gt Posted Transaction Item Editor gt G L Transaction Changes Report gt Import an Excel File 2011 Cast amp Crew Entertainment Services LLC 150 PSL3 User Manual Chapter 7 1 Journal Entry A Journal Entry is the recording of financial data in the form of a debit and credit transaction Use the Journal Entry jete program to record J E transactions such as depositing cash in checking accounts replenishing Petty Cash correcting account coding and amounts as well as recording bank charges and interest payments etc Open gt To access the Journal Entry jete screen click on Tab 3 or press ALT and the number 3 Key simultaneously to open the screen gt Journal Entry jete can also be accessed in the J E module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter Post jepost Posted Transaction Editor gif GIL Transaction Changes glfixp Import an Excel File int a PR a GL aj Checks aj Budget 5 Cost ay Closing 3 Recurring Batch ii Report aj PSL3 Help NN EEE ttet The screen then appears 2011 Cast amp Crew Entertainment Services LLC JO
12. e Use Statement Date as Cut off Date Check mark this option for the reconciliation to only include items up to the Statement Date not past it e Include Checks Check mark to include uncleared checks in the reconciliation e Include Deposits Check mark to include uncleared deposits in the reconciliation e One Line per Check Number Check mark to include only one line per Check Number in the reconciliation Check Sort e Date Check Number and Vendor Name are all sorting options available for you to select per your preference Totals Out Clear Outstanding Cleared Number of Checks Outstanding Number Amount of Amount of Cleared Checks Outstanding of Checks Cleared Checks Checks Number of Deposits Amount of Am f Cl Deposits Outstanding Number of Deposits Outstanding oe i Deposits Cleared Deposits Reconciling This field left intentionally Amount of Cleared This field left intentionally blank Items blank Reconciled Items 2011 Cast amp Crew Entertainment Services LLC Balances Beginning Beginning or opening balance since the last Bank Reconciliation For example if the last Bank Reconciliation performed had a balance of 613 83 at the end of June this amount becomes the beginning balance for the beginning of July Please note you are not able to access this field Cleared Cleared amount balance Please note you are n
13. you will receive a prompt notifying you the clearing process is not done If you select Yes you will receive a secondary prompt confirming the clearing process was successful along with the number of checks and deposits cleared and reconciled A Clearing successful 42 checks O deposits 2011 Cast amp Crew Entertainment Services LLC Chapter 10 5 Positive Pay Export and Report Positive Pay Export and Report pospay is a process whereby PSL3 electronically exports the check file of all issued checks to the bank The bank therefore only pays checks listed in that check file register with exactly the same specifications listed in the file check number payee name dollar amount etc When these issued checks are presented for payment at the bank they are compared electronically against the list of transmitted checks When a check is presented that does not have a match in the file it becomes an exception item The bank contacts the client and includes a fax or an image of the exception item to the client The client reviews the image and instructs the bank to pay or return the check This system dramatically reduces check fraud Open gt To access the Positive Pay Export and Report pospay screen click the Checks module from the menu tree see following screen shot gt The Positive Pay Export and Report pospay screen is also located in the Report module under the Checks sub folder gt You can a
14. BI01QIQAIDIAIAILO Report Selection gt RepotiO Period Selection Period 3 StatDate End Date 11 L Account Selection From frst accoun last account Selection Criteria Spreadsheet i To ac je AA rinctude Show F Detail F Series Separation F Inactive Accounts F Location Separation Beg Bal is Activity F Set Separation Multiple Currency Source Currency Al source currency Target Currency U5 Dots o date in range blank for last in database To select criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 O 2011 Cast Crew Entertainment Services LLC 220 PSL3 User Manual Report Selection Report ID Detail Summary or customized Report ID to format the report by To create a customized Report ID use the Report Group Entry surpt screen located in both the Setup and G L modules Please note you must select a Report ID in order to run the report as it is a white required field NOTE Please email a request to support castandcrew com ifyou would like the customized Report ID format imported from a previous PSL3 database Period Selection Period System assig
15. F Budget Amount as Activity F Open items as Actual Costs Committed Costs Subtotals Accounts From pm I Radon Report fore Eigenes Printing F Shading Multi Currency Source Alsourcecurrency Target us Donars Print Combined Report Print individual Report Preview Combined Report Preview Individual Report Spreadsheet Exit To select criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 2011 Cast amp Crew Entertainment Services LLC Pan combines Repon ermano rezos Clear All 322 PSL3 User Manual Budget Information Period Budget Name of the budget For each account number the Estimated Final Cost will be compared to the Budget Amount to determine the Variance To choose multiple budgets press the F2 Key or right click in this field and hold down the Control Key while simultaneously using your mouse to select Please note you must select a Budget Name in order to run the report as it is a white required field If you don t have a budget input yet you can create a Zero dollar budget in the Create a Budget bdgl screen Production Production Code for the Budget Name The Production Code defaults when the budg
16. LLC HOW TO USE THIS MANUAL 15 To log in to PSL3 Please note the User Name and Password are case sensitive fields usually lower case gt Type in your User Name gt Click in the password field or press the Tab Key Type your Password and press the Enter Key or click OK Login Username Your User Name Here Selecting a database Your PSL3 is set up with at least one database If it s set up with more than one if you re working on more than one show you can choose which database to open If you need to switch databases first logout then login and select the new database To have two PSL3 databases open start another PSL3 session in a new web browser window and select the new database To select from among multiple databases Once you have successfully input your login credentials select a database and press Enter or click OK The home screen for your database displays Now you are ready to explore the functions and capabilities of PSL3 da Databases E The Big Feature The Big Show The TY Show 2011 Cast amp Crew Entertainment Services LLC 16 PSL3 User Manual Chapter 1 3 UNDERSTANDING PROGRAMS AND COMMAND SCREENS Program screens allow you to open or close programs enter setup records enter or post transactions retrieve find entries inquire into entries and generate reports As with the home screen you can type on the Keyboard or click the mouse to navigate the screens and comma
17. P Card View Report pcardlp program Please contact Cast amp Crew s Finance Department at pcard castandcrew com or by phone at 818 848 6022 to be setup to use P Cards in PSL3 for your Production Also for information on the administration of the Wells Fargo Commercial Card Expense Reporting CCER system including adjustments to credit limits please contact Cast amp Crew s Finance Department at pcard castandcrew com or by phone at 818 848 6022 Open gt To access the P Card View Report pcardlp click the P C module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC PETTY CASH m Es Vendor Entry pcent Edit pcpost Post pepost Advance Report pear Entry apven Vendor Listing apvenp P CARD View Report pcardlp sy Recurring Batch En Report nj PSL3 Help The screen then appears Card Information O 2011 Cast Crew Entertainment Services LLC 12 PSL3 User Manual e Card Number Valid Card Numbers with purchases made are listed here Press the F2 Key or right click to select a Card Number You can also choose multiple Card Numbers by holding down the Control Key and simultaneously using the mouse to select To select all Card Numbers leave this field bl
18. Positive Pay Export and Report pospay Yoid Checks ickvoid Checks Inquiry ckinq Check Register Summary ckolcr Check Register Detailed ckreg Check Register History ckdetcr Bank Reconciliation ckrbs Checks Inquiry cking Bj Budget 5j Cost jj Closing Bj Recurring Batch 5j Report 5j PSL3 Help The screen then appears 2011 Cast amp Crew Entertainment Services LLC 250 PSL3 User Manual ZE ckvoid Void Checks OB File Edit Programs Options View Favorites Help 110101410115 1510 HA PreView Clear All Register Cancel Void checks Print detail EXit Void then Reissue Help Enter a bank code PI T Ms To select criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 Check Selection e Bank Input the Bank Code that issued the check that you wish to void Once entered the Check Number and Reference Number fields associated with the Bank Code selected become accessible Check Number Input the range of Check Numbers that you wish to void To wid a single check enter the same Check Number in both the From and To Check Number fields Reference Number Input the range of Check Reference Numbers that you wish
19. To proceed with the deferring process press the F1 Key then D option or select Defer located in the top right hand corner of the screen PSL3 automatically saves the change and clears the screen Please note the Defer Open Items ckdef screen does not generate a report 2011 Cast amp Crew Entertainment Services LLC ACCOUNTS PAYABLE 107 Chapter 5 4 Modify Open Items The Modify Open Items apopmod program is used to change a posted A P transaction s Bank Code This program allows you to select either one open A P Reference Number or multiple open A P Reference Numbers and modify the Bank Code associated with those transactions The A P Open Items Modification Report prints the final Bank Code change s for your records NOTE Please note you can not change the Bank Code of an open A P Entry apte transaction that contains a distribution line transferred from a P O Open gt To access the Modify Open Items apopmod screen click the A P module then click the A P Entry sub folder from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC 108 PSL3 User Manual Entry apte Edit List appost Post apposti Yoid Open Items apyoid2 Ea Checks 5 1099 a Pio Bi Pic i JE mi PR i GL ij Checks aj Budget 3
20. a l a a I q El a Ll a q q q a g a a 2 2 2 2 9 0 9 2 2 9 9 9 0 9 9 2 9 2 0 9 9 9 2 0 9 9 9 9 9 0 2 3 3 a3 9 3 33 Hajnan 0 0 1023 00 Fo 033 ojoje o el hos a The Cost Report EFC Worksheet efcws columns and data exactly match the Estimated Final Cost Report efcrpt Similar to EFC Entry efcent the white colored fields which include Cost to Complete CTC Estimated Final Cost EFC and Variance columns are still editable on the postable accounts Also the Variance Description column remains editable as this is where you enter the description after making the necessary changes The Variance Description field remains an optional field If left blank the default description will read EFC Worksheet VA Data View Selection e Upon right clicking in the Cost Report EFC Worksheet efcws PSL3 displays the list of available options to view the worksheet based on your preference which are as follows 2011 Cast amp Crew Entertainment Services LLC Show All Details Show Summary Show Over Budget Show Under Budget Show Over Under Budget Collapse Expand Expand All Relative Variance Edit Drill Down Set All EFCs to Budget Sort by Actuals this Period Desc Sort by Actuals to Date Desc Sort by Commitments Desc The most popular feature Drill Down brings up a listing of all transaction details that make up that specific amount bas
21. all fields blank Report Type e Defaults to Edit List to review your Payroll entries and make any necessary modifications prior to posting To move forward with posting select Posting Register followed by either the Print Preview or Spreadsheet option this will transfer the transaction s to the Bible Report bdbr Report Formats 2011 Cast amp Crew Entertainment Services LLC PAYROLL or e Report Format Report Sort and Description Of are all sorting options available for you to select per your preference Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format gt Spreadsheet Generates an Excel format report and appears instantly on your screen You are still able to print from the Excel format Please note if you select this option you are able to have additional sorting options within Excel 2011 Cast amp Crew Entertainment Services LLC 192 PSL3 User Manual Once you select Posting Register followed by either the Print Preview or Spreadsheet option PSL3 displays the following message prompt ce Register printed Has the register printed correctly Yes Help If you sel
22. bdvar Reference Variance Report bdvep Import a Budget bdint Budget Listing bdentp amp Maintenance Budget Amount Entry bdent w m Bu Closing Es Recurring Batch 38 Report nj PSL3 Help The screen then appears MAR ARO NO NRO TE 10 To select criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave 2011 Cast amp Crew Entertainment Services LLC all fields blank Budget Information Budget Name Input the name of the budget you want to delete Production The Production Code defaults when the Budget Name is input Please note you are not able to access this field Start and End Account Range First and Last Expense Account to delete from the budget To restrict the program to only delete information for a single account number input the same account in both the Start and End fields To delete all account numbers leave both fields blank Series Location Set and Currency Press the F2 Key or right click in any of these fields to limit the budget lines that will be deleted to those that match these items To delete all codes pertaining to the Budget Name selected leave these field blank Delete gt To proceed with the deleting process press the F1 Key then D option or select Delete located in the top right hand corner of the
23. format 2011 Cast amp Crew Entertainment Services LLC 326 PSL3 User Manual 09 01 2012 THE NEM SHOW DATARASE Page 1 5 04 pm Estimated Final Cost Report PSL Standard lefcrpt Type 5 5 By Date Range for Budget Code BUDGET DEAR JOEN BUDGET Treating Open Items as Actual Coste Starting Account 11 01 First active expense Date Range 09 01 11 to 09 01 11 Ending Account 76 01 Last active expense Excluding inactive accounts Pro action JOHN DEAR JO Budgeted amounts are activity Company All Series All Insurance All Location All m All Ser All FF2 All m ALL Fri All 11 22 eo EE ex eed Aot Accomt Previous Cost Actual Cost Total Cost Cost To Estimated Nm Description To Date This Period To Date _ Complete Final Cost Budgeted Variance AVE THE LINE 13 01 MATTERS SALARIES 3 726 652 o 2 716 651 o 1 716 651 1 700 000 16 651 11 03 RIGHTS 1 000 000 o 1 000 000 O 1 000 000 1 000 000 o 11 14 SCAIPT TIMING o o gt o 00 1909 11 73 PROD CLEARANCES 4 770 o 4 770 o 4 770 15 000 10 230 11 75 WGA PUBLICATION FEE 5 473 o 5 473 o 5 473 5 000 473 33 99 Total Fri o o o o o 379 1179 TOTAL 11 00 STORY RIGHTS 2 726 894 o 2 726 894 O 2 726 894 2 720 679 6 215 DROCOCERS UNTT 12 00 12 01 EXEC PROCOCER 242 143 o 242 143 o 242 143 237 000 5 143 12 02 PROCOCER 2 600 000 o 1 600 000 O 1 600 000 1 779 000 175 000 12 06 ASST TO PRODUCER 30 115 o 30 115 o 30 115 30 120 5 12 08 PROD ENTERTAINMENT 8 6
24. gt Vendor Entry gt Vendor Listing Report gt Additional Vendor Screens Reports 2011 Cast amp Crew Entertainment Services LLC s PSL3 User Manual Chapter 3 1 Vendor Entry A vendor is an individual or company providing a product or service The Vendor Entry apven program is used to find modify and delete unused vendor records This screen allows you to set up a vendor record for each vendor you plan to do business with during production The data you enter in the Vendor Entry apven screen can be changed at any time except the Vendor ID Number and Vendor Name once a check has been processed Please note a vendor can not be deleted once it has been used in PSL3 Open gt To access the Vendor Entry apven screen click the Setup A P or P C modules from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter Entry apven avery Labels labels AJP Vendor Inquiry fapying Analysis apvena Account endor Totals accvt AJP Vendor Inquiry apying aj AP Entry Es Checks 5 1099 jaj Pio zu Pic sa JE a PR a GL igi Checks 3 Budget 3 Cost ay Closing ji Recurring Batch 3 Report 31 PSL3 Help EEE EEE amp EI amp EE amp The screen then appears 2011 Cast amp Crew Entertainment Services LLC VENDORS s ma apren Vendor Entry File Ed
25. hier Budget Amount Entry bdent Create a Budget bdgl Delete a Budget bddel Budget Name Entry bdname ii Cost 5 Closing 3 Recurring Batch ii Report PSL3 Help H t t t 2011 Cast amp Crew Entertainment Services LLC oc G gt q a fe DIE Budget Code Description Total Budgeted Production From first account Series To last account Location Set M Amount Account number Sers Locs Sets Currency Amount Budget name Enter search criteria or add data A a Budget Information e Budget Code Name of the budget whose data you want to review or modify Press the F2 Key or right click to select the Budget Code Once the Budget Code is selected press the F7 Key or Find icon located on the toolbar for the budget lines to appear Please note if you press the Enter Key after selecting the Budget Code the budget lines will not appear In this screen the Enter Key just takes you to next field e Description Description for the budget selected defaults You are able to modify the description of the budget here if needed e Production Production Code for the budget selected defaults Budget Total e Currency Currency Code for the budget selected defaults e Total Budgeted Total amount of the budgeted lines for the budget selected Account Selection 2011 Cast amp Crew Entertainment Services LLC 266 PSL3 User Manual e From and To If you would like to look for a
26. make changes to only certain fields Please be advised depending on your specific studio s guidelines the Support Department may need to obtain approval from your Studio Finance Executive before proceeding You will know if you have access or not when you try to make a change in one of the distribution fields as a warning message will display if you do not have access For example if you tried to change the account number and do not have access the following warning message automatically appears on the screen ca Warning A You cannot change the account number Open gt To access the Posted Transaction Item Editor glfix screen click the J E module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC 162 PSL3 User Manual The screen then appears Entry jete depos d Import an Excel File int a PR a GL da Checks da Budget da Cost da Closing dai Recurring Batch da Report Bi PSL3 Help E EEE Reference Information 2011 Cast amp Crew Entertainment Services LLC JOURNAL ENTRY 163 e To begin making distribution changes input the Reference Number of the original transaction that you need to change followed by the Enter or F7 Key or select the Find icon located on the to
27. please refer to the Non Existing P O Report nepor located in the P O module Account Number Chart of Accounts number that will be debited or credited on this distribution line Ifa P O does not exist press the F2 Key or right click to choose an account number If the account number doesn t exist in PSL3 you can add it by pressing the F5 Key or selecting the Zoom icon e located on the toolbar This zooms into the Chart of Accounts Entry glca screen in which you can add the account number immediately Once saved press the F1 Key then F option or select the Fetch icon e to fetch the account back to the A P Entry apte screen NOTE The Series Location Set and Free Field Codes are brought over from the User Entry suuser screen located in the Setup module if setup Otherwise press the F2 Key or right click in these fields to make your selection 1099 and Third Party Expense 1099 Code associated with the distribution ifany A 1099 is a tax form Press the F2 Key or right click to choose the necessary code The State Worked field in the Vendor Information section must be input for the 9 field to be accessible Please note if the 9 field does not have a code displayed the 3rd Party field will nof be available to select the Third Party Vendor Description Explanation for this distribution line which can hold up to 30 alpha numeric Characters Amount Dollar or other currency amount for this distribution
28. poentp except it has a wider variety of Report Type sorting options available Open gt To access the P O Edit List Report poedtl click the P O module from the menu tree see following screen shot gt The P O Edit List Report poedtl is also located in the Report folder under the Purchase Order sub folder gt You can also access this report by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 5 Setup a AP Ea Pio Entry poent lt amp P O Edit List poedtl PTO reno och Pending Items Report pirpt Non Existing PO Report nepor E PIC Bi JE ig PR BI GL a Checks aj Budget Du Cost Ea Closing aj Recurring Batch aj Report aj PSL3 Help The screen then appears 2011 Cast amp Crew Entertainment Services LLC ez PSL3 User Manual Starting Starting if Ending Ending By Account Number By Account Location Code By Account Series Code By Account Set Code Starting PIO Type By Location Acct Ending Relieved By Free Field 1 Open By Free Field 2 Both By Free Field 3 By Free Field 4 By P O Number Batch Number By PIO Type Production By Reference Number Vendor Number All vendor numbers By Series Code All series codes By Set Code All location codes By Vendor Name All set codes By Vendor PIO Free Field 1 Al first free codes By Vendor Name P O Free Field 2 All second fr
29. unposted A P transaction s of the original A P Open Items s selected in the Reference Number field within the Current Period Print Preview the Report Located in the top right hand corner of the screen you can choose the following options to generate the report gt Print Edit Opens the Print Dialogue box and sends the report directly to the printer gt Preview Edit Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format gt Void A P Opens the Print Dialogue box sends the report directly to the printer and begins the voiding process 2011 Cast amp Crew Entertainment Services LLC m PSL3 User Manual Once you select Void A P and the report has printed PSL3 displays the following message prompt ce Register printed Has the register printed correctly Yes Help If you select No PSL3 asks Would you like to reprint the register If you still select No the voiding process is not done If you select Yes PSL3 then displays a secondary prompt Void Reissue is done VVould you like to reprint the Voiding Register with the Reference Numbers for the Reversal Yes and Reissued A P If you select Yes the Voided Open Items Register prints and the selected A P transactions are now voided and or reissued If you select No the Voided Open Items Register is not printed however the void and or reissue process is now complete
30. 2011 Cast amp Crew Entertainment Services LLC 204 PSL3 User Manual Chapter 8 7 Additional Payroll Screens Reports PSL3 offers additional Payroll Screens Reports which are listed below Please note if PSL3 does not provide a reporting option you need please contact your Payroll Coordinator as the Payroll Department has a wider variety of Payroll Reports including additional criteria and sorting options per your preference Open gt To access the following Payroll Screens Reports click the P R module from the menu tree see following screen shot gt These additional Payroll Screens Reports are also located in the Report module under the Payroll sub folder gt You can also access these screens reports by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter PO y Ey Setup Bi AP Bi Pio jy Pic aj Checks ii Budget ij Cost Ea Closing aj Recurring Batch ij Report aj PSL3 Help t HH E HER To select criteria for the following reporting screens press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 e Accrued Holiday Report acvhrpt Use acvhrpt to generate a listing of a single or all em
31. 2011 Cast amp Crew Entertainment Services LLC 122 PSL3 User Manual Chapter 6 1 P C Entry Petty Cash is the distribution of cash funds to pay for employees on a Productions for various expenses usually smaller purchases such as materials and supplies Use the P C Entry pcent program to record both Petty Cash Advances Amount Advanced Petty Cash Receipts and Petty Cash Returned Accounted for Amount To disburse Petty Cash to each vendor and or employee he or she must be set up in Vendor Entry apven and have a Petty Cash Advance Account Number entered in his or her record WARNING Please be advised you are not able to access the P C Entry pcent screen until your User ID and default codes are setup Ifthey are not setup the following warning message will display upon opening the screen co Warning Before opening Petty Cash Entry you must set up your default Series Location and Set Codes in the Users program under the Setup menu Your default Series Location and Set Codes can be input in the User Entry suuser screen located in the Setup module Once saved the P C Entry pcent screen becomes accessible Open gt To access the P C Entry pcent screen click on Tab 5 or press ALT and the number 5 Key simultaneously to open the screen gt P C Entry pcent can also be accessed in the P C module from the menu tree see following screen shot gt You can also access this screen by typing the scre
32. Accept changes and clear screen C Cancel discard changes X exit to menu Print Preview the Report Located in the top right hand corner of the screen you can choose the following options to export and generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format gt Spreadsheet Generates an Excel format report and appears instantly on your screen You are still able to print from the Excel format Please note if you select this option you are able to have additional sorting options within Excel gt AIP Export Allows you to export the selected transactions directly to A P Entry apte in which you can post thereafter Please note the selected transactions must have an account number input before exporting to A P Entry apte or else you will receive the following warning message 2011 Cast amp Crew Entertainment Services LLC PETTY CASH 1 a Warning A You must enter the Account Number before you can exportto AP Once all account numbers have been input the Export to A P screen appears in which you can apply coding to the transaction Input all white required fields and select the OK option located in the top right hand corner of the screen An A P transaction is created and the A P Entry apte Reference Number displays on t
33. Batches Reporta een 346 GLOSSARY 351 2011 Cast amp Crew Entertainment Services LLC POL HOW TO USE THIS MANUAL Secti HOW TO USE THIS MANUAL 11 Section 1 HOW TO USE THIS MANUAL Welcome to the User Manual for Cast amp Crew s PSL3 The purpose of this manual is to give you an organized guide to assist you in your use of the program We encourage you to review this manual in order to better understand the powerful capabilities of the PSL3 program This manual contains step by step instructions covering every aspect of the program Additionally you will notice along the way various Note and Warning messages are displayed which may be helpful in your use of the program These are noted as follows NOTE Notes are designed to remind you of certain program behaviors or alert you to things which may be beneficial as you use the program Notes may also include examples to better illustrate or explain the topic on which you are working WARNING Warnings are exactly that a warning As you complete certain function such as deleting items or changing values these are things which you should be aware of before proceeding 2011 Cast amp Crew Entertainment Services LLC 12 PSL3 User Manual Chapter 1 1 PREFACE PSL3 offers an internet based solution to your Production Accounting software needs This efficient secure and easy to use Production Accounting software features a multitude of aspects inc
34. Cast amp Crew Entertainment Services LLC JOURNAL ENTRY 165 Chapter 7 4 G L Transaction Changes Report The G L Transaction Changes Report glfixp reports on any distribution changes made in the Posted Transaction ltem Editor glfix screen The G L Transaction Changes Report glfixp is also referred to as the G L WAS IS Report as the report displays the WAS what the original transaction data was before being changed in the Posted Transaction Item Editor glfix screen and S what the transaction data is now after the change s detailing the original distribution line values as well as what they reflect now Open gt To access the G L Transaction Changes Report glfixp click the J E module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 5 Setup a AP a Pio a Pic Sa JE Entry jete Edit jepost Post jepost ut amp t t ay Closing 5 Recurring Batch ii Report ii PSL3 Help E E E E t E E t The screen then appears 2011 Cast amp Crew Entertainment Services LLC 166 PSL3 User Manual Effective Date Account Number Reference Number User Company Source Production 1099 Starting effective date Q From To ver Insurance FF1 FF2 FF3 FF4 JE Number Currency 3rd Party OT T E To se
35. Checks module from the menu tree It is also located in the Report module under the Checks sub folder To generate the report manually from the Check Register Summary Report ckolcr screen you have the option to run it by Starting and Ending Check Numbers and Check Run Numbers Period Date Range Check Status Information etc as selection criteria This report provides the option to Print Preview or generate the report to an Excel Spreadsheet 2011 Cast amp Crew Entertainment Services LLC Chapter 10 3 Void and Reissue Checks The Void Checks ckwid program is used to cancel the effect of printing posting the check By voiding a check PSL3 cancels the posting of the A P Entry apte invoice associated with that check by voiding the original transaction and then creating the reversing transaction PSL3 also provides the option to reissue the wided A P Entry apte transaction Open gt To access the Void Checks ckvoid screen click the Checks or A P module from the menu tree see following screen shot gt Void Checks ckvoid is also located in the Report module under the Checks sub folder gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 5 Setup a AP La Pio a Pic a JE a PR a GL 4 Checks Pre Check Report ckper U E E E Fe E Computer Checks ickprnt Manual Checks Open Items ckman
36. Cost a Closing aj Recurring Batch aj Report aj PSL3 Help CN A A EEE 5 The screen then appears 2011 Cast amp Crew Entertainment Services LLC ACCOUNTS PAYABLE 109 143101 M O 2011 Cast 8 Crew Entertainment Services LLC tio PSL3 User Manual Selection Criteria e Reference Number Reference Number of the A P Open Item s whose Bank Code you want to change To choose multiple A P Open Item s press the F2 Key or right click in the Reference Number field and hold down the Control Key while simultaneously using your mouse to select Please note all transactions selected must be coded to the same Bank Code Transaction For e Bank Code Bank Code of the selected A P Open Item s entered in the Reference Number field defaults e Currency Code Currency Code associated with the Bank Code of the selected A P Open Item s defaults Please note you can not access this field e A P Clearing A P Clearing Account Number associated with the Bank Code of the selected A P Open Item s defaults Please note you can not access this field Change To e Bank Code New Bank Code to which you want the selected A P Open Item s to be changed to Press the F2 Key or right click in this field to choose the necessary code e Currency Code Currency Code associated with the new Bank Code defaults Please note you can not access this field e A P Clearing A P Clearing Account Number associated with the new Ban
37. Estimated Final Cost and Variance amounts on the Estimated Final Cost Report efcrpt Please note Variance transactions do not get posted Please note Variances are created by one of three ways which are as follows 1 By directly accessing the Variance Entry bdve screen and inputting the change s here 2 By making the change s in the EFC Entry efcent screen After making and saving the EFC change s a Variance is created with the new Variance Entry bdve Reference Number appearing directly in the EFC Entry efcent screen for your records 3 By making the change s in the Cost Report EFC Worksheet efcws screen After making and saving the EFC change s a Variance is created with the new Variance Entry bdve Reference Number appearing directly in the Cost Report EFC Worksheet efcws screen for your records Although PSL3 allows you to select any of the three previously mentioned options the result of entering a Variance in either Variance Entry bdve EFC Entry efcent or in the Cost Re port EFC Worksheet efcws screen is exactly the same Open gt To access the Variance Entry bdve screen click the Budget or Cost module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC EEE The screen then appears 201
38. For example if you printed check number 000001 and something went wrong you can reset the Last correctly printed check field to the prior number which in this case would be 000000 You can then make the Next available check field reset to 000001 to reprint that check number and any thereafter within the same check run Check Register Summary Report ckolcr 2011 Cast amp Crew Entertainment Services LLC 248 PSL3 User Manual e Upon exiting the Computer Checks ckprnt program PSL3 automatically generates the Check Register Summary Report ckolcr directly on your screen after successfully printing checks The Check Register Summary Report ckolcr displays a summary of the last check run listing one line of information per check and normally in check number order Once you receive the Check Register Summary Report ckolcr PSL3 displays the following prompt 2 Did register print properly Y N If you select No PSL3 continues to ask Did register print properly Y N If you still select No you will continue to receive the prompt until you select Yes Once you select Yes the checks automatically post to the Bible Report bdbr and the related A P transactions now update to a P aid status Please note there is nof an additional check posting process like other software systems Please note the Check Register Summary Report ckolcr can also be ran at any time for any date range as it is accessible in the
39. Format of the Pospay file that defaults when the Bank is selected Please note you are not able to access this field e Cut Off Date The Pospay Format field must be blank in order to enter a value for the cut off date Check Type e Defaults to All Exportable Checks most common Retrieve Existing Report Export File s e Start Date and End Date Dates to retrieve the archived report by Press the F2 Key or right click in either date field for the calendar selection to appear 2011 Cast amp Crew Entertainment Services LLC 264 PSL3 User Manual ec Pick a date lt January 2011 e Bank Name of the bank to retrieve the archived report by Press the F2 Key or right click to select the Bank Code gt Retrieve Report Generates a PDF format of the archived report which appears instantly on your screen You are still able to print from the PDF format The title of the report is named Bank Name Checks Issued List gt Retrieve Files Opens the Save Dialogue box in which you are able to save the archived report file directly to your computer Print Preview the Report Located in the top right hand corner of the screen you can choose the following options to export and generate the report gt Print Edit Sends the report directly to the printer gt Preview Edit Generates a PDF format report and appears instantly on your screen You are still able to print from the PD
40. List 2 2 2 2 2 Re ebene ebene ehren 81 Additional P O Screens Reporfs ue4 444nn nnnnnnnnnnnnnnannnnnnnnnnnnnnnnnnnnnnnnn nenn nnnnn nenn 85 ACCOUNTS PAYABLE 89 AP en EE 90 2011 Cast amp Crew Entertainment Services LLC 6 PSL3 User Manual 2 3 4 5 6 7 Part VI 1 2 3 4 Part VII 1 2 3 4 5 Part VIII 1 2 3 4 5 6 7 Part IX 1 2 3 4 5 6 Part X 1 Post A P Transactions Edit List ccccicssccccccsccereccesecsieccsverecteeseevedeceevececeneenecceveeetieeseewadeceevetees 98 Defer Open Ite MS iii A A ei neve 104 Modify Open ems iii 2 0 er inebrinieliin 107 E A A nn ccued ncaa setees fe tmevnbaureteecratseehaderstekcddsecrnidatsceds covedehivagutacctexs 112 1099 Reporting SCree NS in A aii din na ae 115 Additional A P Screens Reporfs s 4 uu s4 2004400000000 narnia cisne ninia 117 PETTY CASH 121 P G Entry ee neue 122 Post P C Transactions Edit List uusrrssnnsnnnennnnnnnennnnnnnnnnnnnnnnnnnnnnnnnnnsnnnnnnnsnnnnnnnnnnnnnen nn 131 P C Crew Advances Activity Report zsuussnnennnsnnnennnnnnnnnnnnnnnnnnnsnnnnnnnnnnnnnnnsnnnnnnnnnnnnnnn nn 136 P Card View Repart 2 un a nennen aa a a aA a a Eaa E aae E AE iaaa EPa ta erae 140 JOURNAL ENTRY 149 J u urnal Enty arare a lovey aevedzesstidevre ace sduoesteaereeqeeedoe 150 Post J E Transactions Edit LiSt ooiooonnccci na 156 Posted Transaction ltem Editor uuss
41. Please be advised Vendor Names use the back slash not forward slash sign to separate the Last and First name NOTE After a check is written for a vendor the Vendor Name can not be changed Please email a request to support castandcrew com to turn this feature off If you need to change the name of a vendor please email a request to support castandcrew com with what you would like it to read Vendor Contact Information e Enter the vendor or employee s Address City State Zip Country Contact Phone Fax and Email if applicable Tax ID Information e Tax ID Nine digit Tax Identification Number usually beginning with 95 If the vendor is a person enter his or her Social Security Number SSN Ifthe vendor is a business company enter the Employer Identification Number EIN e Tin Type Taxpayer Identification Number Type Press the F2 Key or right click to view and select the Tin Type options along with their descriptions which are as follows 2011 Cast amp Crew Entertainment Services LLC VENDORS st tee TIN type TIN type Description 0200 Not a 1099 able sole proprietor EIN sole proprietor SSN 1 2 3 4 5 e 1099 Type 1099 Type associated with this vendor or employee The 1099 Code selected defaults in transaction distribution lines for this vendor or employee but can be overridden Press the F2 Key or right click to view and select the 1099 Type options alo
42. Section 13 CLOSING This section will address the following program gt Close Period 2011 Cast amp Crew Entertainment Services LLC 332 PSL3 User Manual Chapter 13 1 Close Period The Close Period glclose program is used to close the Accounting Period This program can be run anytime weekly monthly quarterly etc depending on your specific studio s guidelines Before you can close the period you must either post or delete all unposted transactions or change their Effective Dates to a date past the Current Period End Date falling in a future period and in the instance of some studios all transactions may have to be paid The Closing Report displays each postable account s Account Number Account Description Beginning Balance Debits Credits Net Change Ending Balance and Grand Totals for the period being closed Open gt To access the Close Period glclose screen click the Closing module from the menu tree see following screen shot gt Close Period glclose is also located in the Report module under the G L sub folder gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter Setup a AP a Pio i Pic sa JE a PR aj GL aj Checks Ue EEE He Fe Oe EA ii PSL3 Help The screen then appears 2011 Cast amp Crew Entertainment Services LLC CLOSING 333 N Start Date End Da
43. Sort By e Vendor ID and Vendor Name are the sorting options available to select per your preference Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format 2011 Cast amp Crew Entertainment Services LLC Chapter 10 2 Computer Checks and Check Register Summary Report Use the Computer Checks ckprnt program to print PSL3 created checks The Computer Checks ckprnt screen is most commonly used to print a run of checks for posted Accounts Payable invoices but you can also print individual computer checks based on the Open Item Selection Criteria If there are leading check stubs the check prints first and the check that gets voided prints after To view a list of all the open items that will be included in the next check run before proceeding with the check printing process it is suggested to run a Pre Check Printing Report beforehand NOTE Please note PSL3 is compatible with MICR Check Printing and has it s own Check Form MICRFM or MICRLA If you would like to have this feature set up please email support castandcrew com for more information Open gt To access the Computer Checks ckprnt screen click o
44. You can also email a request to support castandcrew com if you need a transaction unposted and include the Reference Number s Please be advised depending on your specific studio s guidelines the Support Department may need to obtain approval from your Studio Finance Executive before proceeding 2011 Cast amp Crew Entertainment Services LLC 160 PSL3 User Manual NOTE Please note you are nof able to re print a Posting Register once the transaction s are posted therefore if you need a copy of the report sent to you please email a request to support castandcrew com with the approximate date and time that the report was ran PSL3 houses all generated reports on a server 2011 Cast amp Crew Entertainment Services LLC JOURNAL ENTRY 161 Chapter 7 3 Posted Transaction ltem Editor The Posted Transaction Item Editor glfix program allows you to change distribution codes on transactions that have a posted or paid status Depending on your User ID access and studio permissions the following distribution fields can be changed in this program Account Series Location Set 1099 Insurance Free Field s Description Amount and 3rd Party NOTE Please email a request to support castandcrew com if you do not currently have access to make distribution changes in the Posted Transaction Item Editor glfix screen You can request Full Access make changes to all distribution fields or Limited Access
45. a purchase order A written script filmed to be distributed as a film movie feature motion picture television pilot television series mini series movie of the week commercial documentary industrial made for cable etc A legal document used to record an employee s hours worked each week The orderly summary of ledger accounts used specifically to extract financial statement information See also balance sheet UPM or PM The producer s executive assigned to the production responsible for coordinating and supervising all administrative financial and technical details of the production and for overseeing the activities of the entire crew An estimate that deviates from the amount budgeted for that estimate usually the difference between the actual costs of production and the budgeted costs A company or individual providing a product or service A number identifying a specific vendor assigned to all invoices purchase orders etc of that vendor A printed check that has not been issued to the payee or posted to the computer system The date marking the end of a weekly pay period which for local locations is five days M F and for distant locations is six days M Sat A special character in PSL3 the asterisk that represents a character or group of characters during a search The state of a ledger that is in balance 2011 Cast amp Crew Entertainment Services LLC Back Cover
46. add the account number immediately Once saved press the F1 2011 Cast amp Crew Entertainment Services LLC 154 PSL3 User Manual Key then F option or select the Fetch icon e to fetch the account back to the Journal Entry jete screen NOTE The Series Location Set and Free Field Codes are brought over from the User Entry suuser screen located in the Setup module if setup Otherwise press the F2 Key or right click in these fields to make your selection e Description Explanation for this distribution line which can hold up to 30 alpha numeric characters e Amount Dollar or other currency amount for this distribution line Input the journal debit or credit amount Ifyou are entering a negative amount input the minus sign before the number Please note if you press the F2 Key or right click in the Amount field a calculator displays for your convenience ce Calculator Journal Entry Was lIs Distribution Changes Once a Journal has been posted you are able to make distribution changes directly from the Journal Entry jete screen in addition to the Posted Transaction Item Editor glfix depending on your User ID access level This includes Account Series Location Sets Insurance Free Field s and Description changes This excludes Amount changes To make changes simply input the Reference Number of the Journal in the Journal Entry jete screen followed by the Enter or F7 Key or selec
47. afafafofetzio aofa pajis 14 15 47 16 19 20 21 22 012214157 NOTE Please email a request to support castandcrew com if you need a transaction s Effective Date changed and include the Reference Number s Please be advised depending on your specific studio s guidelines the Support Department may need to obtain approval from your Studio Finance Executive before proceeding e Description Week ending date from the Payroll invoice which can hold up to 30 alpha numeric characters Ifthis inwice was loaded through the Load Interface C amp C Payroll Invoice printr screen this Reference Description is normally not changed e Status Overall status of the transaction This field is marked with a U for an Unposted entry until you post it in the Post P R Transactions prpost screen As long as the transaction is marked with an unposted status you are able to modify it Once posted it is marked with a P for Posted PSL3 updates the status automatically 2011 Cast amp Crew Entertainment Services LLC 164 PSL3 User Manual NOTE Please email a request to support castandcrew com if you need a transaction unposted and include the Reference Number s Please be advised depending on your specific studio s guidelines the Support Department may need to obtain approval from your Studio Finance Executive before proceeding Batch Information e Codes that are attached to the transaction These field
48. are printing in the designated positions Open gt To access the Print Payroll Checks prckpmt screen click the P R module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter a 5 Setup ij AP ij Pio i Pic a JE PR Load C amp C Invoice printr lee EEE Entry prent Edit List prpost Post prpost History Report prhist Accrued Holiday Report acvhrpt ii Checks 3 Budget ii Cost 3 Closing ji Recurring Batch 3 Report 3 PSL3 Help EEE E E EEE The screen then appears 2011 Cast amp Crew Entertainment Services LLC PAYROLL 199 ec prckprnt Print Checks DER File Edit Programs Options View Favorites Help AAA M Please choose a command key to continue Alignment Print Cancel Alignment and Check Printing e Alignment If this is your first time printing Payroll checks it is recommended to print a test Alignment form to ensure that all check form fields are printing in the designated positions Press the F1 Key then A option or select Alignment located in the top right hand corner Please contact the Support Department for a walk through of this process if preferred Print After the Alignment is complete make sure to put in the correct toner and check stock for Payroll checks Press the F1 Key
49. are pulled from the User Entry suuser screen located in the Setup module if setup beforehand To change the defaulted codes press the F2 Key or right click in any of these fields Batch Production Company Bank and Currency and make your selection Vendor Information e Select the vendor needed by pressing the F2 Key or by right clicking in the Vendor ID field Once the list of vendors appears you can scroll through to find the vendor or click on the column headers Name City or Vendor to sort alphabetically or numerically If the vendor does not exist in PSL3 you can add it by pressing the F5 Key or selecting the Zoom icon located on the toolbar This zooms into the Vendor Entry apven screen To search for a vendor while zoomed into the Vendor Entry apven screen type the wildcard character using the asterisk in the Vendor Name field For example if you want to see if vendor John Smith exists you would type John or Smith and press the F7 Key or select the Find icon CU located on the toolbar PSL3 displays how many records for that criteria exist by selecting the Arrow icons First Prior Next and Last located on the toolbar or by pressing the Page Up or Page Down Keys until you find the vendor needed Once you locate the vendor press the F1 Key then F option or select the select the Fetch icon e to fetch this record back to the A P Entry apte screen Invoice Information e Invoice Number I
50. as shown by a red line through the distribution line Adds a remark to the displayed entry Name Keys and Key Combinations The behavior of name keys and key combinations may change depending on the location of the cursor 2011 Cast amp Crew Entertainment Services LLC lt Enter gt lt Tab gt lt Page Down gt or lt Page Up gt lt gt or Right arrow lt gt Up arrow lt t gt or Down arrow lt j gt lt Shift gt lt Tab gt lt Ctri gt X lt Ctri gt lt W gt B Accept Navigate Navigate Navigate fields Navigate Navigate Navigate Navigate Navigate Enter data Enter data Pick list in an entry Field in the header of a transaction entry screen that has entries Field in the distribution line of a transaction entry screen that has Field Field of a distribution line Field Field Field Field Field that has a changed entry O 2011 Cast Crew Entertainment Services LLC HOW TO USE THIS MANUAL 21 A A Accept the data you entered and move the cursor forward one field Close the message screen Execute the entered command Move from field to field Move from group box to group box Page up or page down through the list Display the next or previous entry for the field Display the next or previous page of entries for the field For example a P O may have more distribution lines than one screen can display Move your cursor to a distrib
51. bar located above the Setup menu Then press Enter O y Setup Hi AP Bi Pio 5j Pic uu JE a PR 5j GL ai Checks Bj Recurring Batch a Report a PSL3 Help To select criteria for the following reporting screens press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 e Account Variance Report bdvar Use bdvar to generate a Detailed or Summary list of Variance entries in your database Detailed reporting can include every Variance entry along with the transaction details for each depending on the Date Range input The report can be ran by Account Range Start and End Dates Multiple Currency etc as selection criteria e Average EFC Report avgefc Use avgefc to generate a listing of account numbers along with their descriptions and the Average EFC Estimated Final Cost spent on the show per account on an episodic basis used especially for budgeting purposes e Cost Bible Report efcrpt2 Use efcrpt2 to generate a cross report between the Estimated 2011 Cast amp Crew Entertainment Services LLC 32 PSL3 User Manual Final Cost Report efcrpt and Bible Report bdbr This report can be ran by Start and End Dates a range of Accounts M
52. characters ST Status Exported status of the transaction Status types are as follows gt N New The transaction status is New and has not been previously exported in P Card View Report pcardip gt E Exported The P O transaction status is Exported and has been previously exported in P Card View Report pcardip PSL3 updates the status automatically when exporting to either A P Entry apte or Import an Excel File xlint Please note you can not access this field 2011 Cast amp Crew Entertainment Services LLC 144 PSL3 User Manual Transaction Date Displays the Transaction Date for a given line item Please note you can not access this field Card Number Displays the Card Number for a given line item Please note you can not access this field Merchant Name Displays the Merchant Name for a given line item Please note you can not access this field Billing Amount US Displays the transaction dollar amount billed in U S Currency Please note credit amounts will appear in parentheses for example 100 00 Please note you can not access this field Helpful Hints v To save this entry select either Save icon k i located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and clears the screen most common ee Command Command U Update database with changes A
53. check will print with the words HOLD FOR PICK UP instead of the address therefore no need to mail it out Number Number ofthe check that paid the inwice This field is automatically filled in after the check is printed The Check Number field is also where you can input a manual check or wire transfer number Manual checks are checks that have been hand written or typed rather than generated by PSL3 Please note if a number is manually input in this field PSL3 will not print a check however the check number is still recorded on the Summary Check Register Report Date Date the check was issued This field automatically defaults after the check is printed 2011 Cast amp Crew Entertainment Services LLC ACCOUNTS PAYABLE os e Amount Amount the check was made for less the Discount Amount Ifyou have combined this invoice with other invoices payable to the same vendor then the Check Amount field reflects the total amount of the combined invoices This field automatically defaults after the check is printed Distribution Lines e P O Number If a P O number s exists for a vendor press the F2 Key or right click to view all P O numbers listed and make your selection The selected distribution lines will transfer over Ifa P O does not exist for a vendor you can manually enter it in this field for reference To print a list of all A P Entry apte transactions containing a P O Number that does not exist in P O Entry poent
54. clears the screen most common ec Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes x exit to menu v To add another distribution line press Enter or Tab where the last line was entered v To insert a distribution line in between already existing lines place your cursor where you want to add and press the F4 Key or select the Add icon Bi A new line is added beneath v To delete a distribution line place your cursor in the line you want to delete and press the F10 Key or select the Delete icon TI A red strike through line appears which is deleted upon saving v To search for an existing entry press the F7 Key or select the Find icon Ly when the screen is clear All records appear in which you can scroll through using the Arrow icons 2011 Cast amp Crew Entertainment Services LLC 130 PSL3 User Manual First Prior Next and Last l l l O or by pressing the Page Up or Page Down Keys until you find the entry needed 2011 Cast amp Crew Entertainment Services LLC PETTY CASH 1 31 Chapter 6 2 Post P C Transactions Edit List Use the Post P C Transactions Edit List pcpost screen to review and post P C transactions You can post transactions one at a time or all transactions at the same time if you prefer It is recommended to first generate an Edit List a list of the transactions you ve selected prior to posti
55. either date field for the calendar selection to appear za Pick a date January 2011 Envelope Information e Number User defined code or number identifying each P C envelope P C Cash Account Range e Starting and Ending Account numbers to include in the report To restrict the report to only include information for a single account number input the same account in both the Starting and Ending fields To select all account numbers leave both fields blank Please note these fields only become accessible when you select Include A P Transactions and or Include J E Transactions in the Report Selection area 2011 Cast amp Crew Entertainment Services LLC PETTY CASH 139 Report Selection e Show Detail Check mark to include detail distribution data for each transaction Include P C Transactions Check mark to include transactions that were entered in P C Entry pcent Include A P Transactions Check mark to include transactions that were entered in A P Entry apte Include J E Transactions Check mark to include transactions that were entered in Journal Entry jete J E Transactions e J E Number User defined code or number also known as the User Source Code to track your company s different classifications of Journal Entries Please note this field only becomes available when you select Include J E Transactions in the Report Selection area Print Preview the Report Located
56. file contained errors ERROR The expected column headers were not found in interface file Test file bd The expected column headings are ACCOUNT SER LOC SET 1099 IN FF1 FF2 FF3 FF4 DESCRIPTION AMOUNT If you received this message the importing process is not completed until the errors are corrected The main reason you would receive this error message is because the Excel Spreadsheet file is not formatted correctly please refer to the PSL3 Excel template NOTE Please email the Excel Spreadsheet file to support castandcrew com should you encounter any problems with the import process The Support Department is happy to assist in troubleshooting and or loading the file for you upon request 2011 Cast amp Crew Entertainment Services LLC POL PAYROLL O PAYROLL Section 8 PAYROLL Cast 8 Crew s Payroll Coordinator receives the time cards that have been submitted by the Accountant and enters this data into the Payroll System After Payroll is calculated the Payroll Coordinator sends the Accountant an email notification with the Payroll Edit file attachment The Edit file displays how Payroll will be processed based on the data entered The Accountant reviews the Payroll Edit file and contacts the Payroll Coordinator if there are any coding modifications hours series location set etc needed If so the Payroll Coordinator makes any requested changes in which the Accountant th
57. gt To access the Bible Report bdbr click on Tab 8 or press ALT and the number 8 Key simultaneously to open the screen gt The Bible Report bdbr is also accessible if you click the G L module from the menu tree see following screen shot as well as the Report folder under the General Ledger and Weekly sub folders gt You can also access this report by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC GENERAL LEDGER 225 Setup a AP ja Pio i Pic a JE a PR Sa Gi Chart of Accounts Entry glca Chart of Accounts List glcap ee E Ff oo Report Group Entry surpt Report ledbib Asset Report assetrpt Recurring Batch Process rbproc a Inquiry aj Checks a Budget 5 Cost 3 Closing ji Recurring Batch a Report aj PSL3 Help E E E E E tt The screen then appears 2011 Cast amp Crew Entertainment Services LLC 226 PSL3 User Manual I Production Period Company Stan Date i Source End Date ti Insurance FFA From first accourt FF2 To ast account FF3 FF4 Account Type Vendor JE Number Y Include Detail I Include Inactive Accounts I Include PIO s Y Include Beginning Balance Y Beg Bal Is Activity I Include Audit information Source Currency All source currency TargetCurrency US Dollars Ending date in rango blank for last
58. have not gone all the way through the accounting process You can enter a range of 2011 Cast amp Crew Entertainment Services LLC s PSL3 User Manual Account Numbers choose the Account Type and generate either a Combined or Individual Detail or Summary Report You can also input Start and End Dates and choose the Date Type by Effective or A P Due Date In addition you can include the Transaction Status Postable Deferred Payable and or Open P O and Multiple Currency as selection criteria Please note this report is also accessible in the A P module Non Existing P O Report nepor Use nepor to print a list of all A P Entry apte transactions containing a P O Number that does nof exist in P O Entry poent You can enter a range of Vendor ID Numbers P O Numbers Start and End Dates etc as selection criteria Please note depending on your studio restrictions your PSL3 database may not allow you to manually input A P transactions with a non existent P O Number NOTE The reports are available in either Print Preview and or Spreadsheet formats NOTE Please email support castandcrew com if you don t see a specific PSL3 report currently listed as an option in your database 2011 Cast amp Crew Entertainment Services LLC POL ACCOUNTS PAYABLE Secti ACCOUNTS PAYABLE ss Section 5 ACCOUNTS PAYABLE This section will address the following programs gt A P Entry gt Post A P T
59. ia ges sdveceut danna dad 238 Computer Checks and Check Register Summary RepOlTb oonccccconnccccnonaccncnnnnnonnncnnnnnnnnananes 241 Void and Reisstie Che KS iii A arena or annene na 249 2011 Cast amp Crew Entertainment Services LLC Part XI 9 oO FR ON Part XII 1 2 3 4 5 Part XIII 1 Part XIV 1 2 3 Part XV Bank Reconciliation een 255 Positive Pay Export and Report z ss sn0nnnannnannnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnannnannn ann ann 261 Additional Check Screens Re ports civic anna nahen 266 BUDGET 271 Importa Budget ii A 272 Create a Budget i r a aaa reaa r aa ara Li Para a caian iii 277 Delete a Bud t a rinisin ei 281 Budget Amount Ey ivive 284 Budget Listing Report ci ai ici 288 Additional Budget crees viii a nel 290 Additional Budget Inquiries and ReporktS oomconncccnccnnnonnnoncnoncnnnroncnnncnonenanenancnnnrnnarenanenans 292 COST 297 ERG a 4 ati 298 Variance Enty miiia RR 304 CostReport EFC WorksShe t ociii ai 310 Estimated Final C st Re port naci a raaa aaa aaia ar 319 Additional Cost Report Screens ReportS oocooocccccnccnonnnonnnnncnnccnnnncnnnnnnnnnnnnnnrennnernnnnenanennnns 327 CLOSING 331 Close Peri T A A E E bene 332 RECURRING BATCH 339 Create Establish Recurring BatchesS coooonncccccoonnccccnnnncnnncnncncnnnnncnnnnnnncnennnnnarennnnnerennnananes 340 Process Recurring Batches uu u eins en 343 List Of
60. in the Summary worksheet the default is 1 An example of this is if your database is setup with an account mask of XX XX XOX XX it has four levels Please note this option only becomes accessible when you select either the Summary or Both type option Inactive Accounts Check mark to include accounts that had no activity distributions posted to them during the period or date range selected or have a zero dollar balance Budgeted Amount as Activity Check mark to include accounts that had no distributions posted to them but do have a non zero amount budgeted If checked the worksheet displays these account numbers in the distribution lines 2011 Cast amp Crew Entertainment Services LLC COST 315 e Open Items as Actual Costs Check mark to include Open Items items posted but not yet paid displayed in the Actual Cost column Only P O s will be treated as Commitments e Committed Costs Check mark for the worksheet to display a column for Committed Costs items entered in the database but not yet paid which consist of P O s and Open Items e Sub totals Check mark to include Sub total amounts Selections e Press the F2 Key or right click in any of these fields Company Series Location Set Insurance and Free Field s to choose the necessary codes ifthey don t already default To choose multiple codes for a particular field press the F2 Key or right click in that field and hold down the Control Key while simulta
61. input all white colored fields as white fields are required before saving in PSL3 v To save this entry select either Save icon A l located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and clears the screen most common 00 Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes x exit to menu v To delete an unused vendor record place your cursor in any field within the screen and press the F10 Key or select the Delete icon TI Red strike through lines appear which are deleted upon saving v To search for an existing entry press the F7 Key or select the Find icon Q when the screen is clear All records appear in which you can scroll through using the Arrow icons 2011 Cast amp Crew Entertainment Services LLC e PSL3 User Manual First Prior Next and Last iS l O or by pressing the Page Up or Page Down Keys until you find the entry needed 2011 Cast amp Crew Entertainment Services LLC VENDORS e Chapter 3 2 Vendor Listing Report The Vendor Listing Report apvenp generates a listing of all vendors in your database Open gt To access the Vendor Listing Report apvenp click the A P module then Vendor sub folder from the menu tree see following screen shot gt The Vendor Listi
62. line press Enter or Tab where the last line was entered v To insert a distribution line in between already existing lines place your cursor where you want to add and press the F4 Key or select the Add icon BI A new line is added beneath v To delete a distribution line place your cursor in the line you want to delete and press the F10 Key or select the Delete icon TI A red strike through line appears which is deleted upon saving v To search for an existing entry press the F7 Key or select the Find icon CY when the screen is clear All records appear in which you can scroll through using the Arrow icons First Prior Next and Last l or by pressing the Page Up or Page 2011 Cast amp Crew Entertainment Services LLC PAYROLL Down Keys until you find the entry needed 2011 Cast amp Crew Entertainment Services LLC 188 PSL3 User Manual Chapter 8 3 Post P R Transactions Edit List Use the Post P R Transactions Edit List prpost screen to review and post Payroll Entry transactions You can post transactions one at a time or all transactions at the same time if you prefer It is recommended to first generate an Edit List a list of the transactions you ve selected prior to posting The purpose of the Edit List is for you to review the Payroll transactions for any errors as well as to make sure the transactions listed are indeed the ones you want to post You can print the Edit List or view
63. receive a secondary prompt confirming the period is now closed Upon selecting Yes you may also receive the following warning message if your Closing Edit List contained errors Closing errors have been encountered Would you still like to print the report If you select No the closing process is not done If you select Yes the Edit List prints out but the closing process is not completed until the errors are corrected Please note if you are associated with a studio and depending on your specific studio s guidelines there may be additional processes with closing the period e g saving the Closing Report and sending it to your studio etc Please refer to your studio for additional information regarding the closing process 2011 Cast amp Crew Entertainment Services LLC POLS RECURRING BATCH Secti RECURRING BATCH 3 Section 14 RECURRING BATCH This section will address the following programs gt Create Establish Recurring Batches gt Process Recurring Batches gt List of Batches 2011 Cast amp Crew Entertainment Services LLC 34 PSL3 User Manual Chapter 14 1 Create Establish Recurring Batches The Create Establish Recurring Batches rbcre program allows you to create a recurring batch transaction for transactions that you will use repeatedly on a daily weekly monthly or quarterly basis This program also allows you to modify an existing recurring batch transaction Open
64. report can be ordered by Vendor Number entries are sorted in ascending order by number first then alphabetically Name or Tax ID e Include You can include vendors that are Active or Inactive or both select whether they have a W9 on file or not or both and specify only A P Vendors or P C Vendors or both e Type Select whether you want to view a Detailed Summary or Vendor Spend Report Vendor Spend Parameters Period e Period System assigned Period Number that indicates the Accounting Period in which these costs were entered Ifyou chose to run the report by Period Number then the Start Date and End Date fields default for the period chosen e Start and End Dates Transaction Effective Dates to include in the report as PSL3 is date driven To restrict the report to only include information for a single date input the same date in both the Start Date and End Date fields To select all dates from inception to future leave both fields blank Press the F2 Key or right click in either date field for the calendar selection to appear ce Pick a date lt lt lt January 2011 ab Goji 17 18 19 20 21 22 a ala 2011 Cast amp Crew Entertainment Services LLC e PSL3 User Manual Vendor Spend Parameters Multiple Currency e Source Currency If you have more than one currency in your database you can choose to include only transactions denominated in one currency two three etc or al
65. screen After selecting Delete PSL3 provides a confirmation prompt with how many budget lines were deleted or if the entire budget was deleted depending on the Budget Information input PSL3 automatically saves the budget deletion 2011 Cast amp Crew Entertainment Services LLC 264 PSL3 User Manual Chapter 11 4 Budget Amount Entry Once you have created the framework of your budget with either the Create a Budget bdgl or Import a Budget bdint programs use Budget Amount Entry bdent to enter or modify amounts for each budgeted expense account within your Chart of Accounts These amounts will be the budgeted amounts in the Estimated Final Cost Report efcrpt Budget Amount Entry bdent also allows you to look up budgeted items add new budget lines delete existing budget lines and modify the Currency and Amount fields Open gt To access the Budget Amount Entry bdent screen click the Budget module then Maintenance sub folder from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter The screen then appears ii Setup a AP ij Pio i PIC i JE a PR ij GL ii Checks 4 Budget EFC Entry efcent Variance Entry bdve Ue EEE EEE Account Variance Report bdvar Reference Variance Report bdvep Import a Budget bdint Budget Listing bdentp z
66. tell PSL3 the checks printed correctly the related A P transactions will still have an O pen status So if something happens to interrupt the check run e g a power outage disruption of internet service etc even after the checks have printed correctly the check process is really not complete Do not close out of the IMPORTANT window until the desired check s have printed correctly Gaz printed check PSL3 PRACTICE DEMO IMPORTANT Check numbers between the last correct check and the next available check will be created as alignment voids Last correctly printed check blank if none 000001 Next available check 000002 OK Enter the number of the next available check If all checks printed correctly then press the OK option However if only some of the checks printed you can reset the Last correctly printed check field The number of the last check printed defaults in this field If at least one of the checks printed incorrectly or you need to reprint any of the checks for any reason enter the number of the last check that printed correctly Even if other checks printed correctly after the first incorrectly printed check you need to enter the number of the check that directly precedes the first check that printed incorrectly and then press the Enter Key or OK option All of the checks that printed after the last correctly printed check will be marked as Computer Alignment Voids and will need to be reprinted
67. the Current Period End Date from there and saving Please note you may have to log out and back into PSL3 for the update to take effect Report Type e Defaults to Edit List to review the Current Period you are closing and check for any errors e g unposted transactions etc If you have encountered any errors they are listed on the last page of the Edit List along with the Reference Numbers containing the errors To correct this make the changes listed on the Edit List then review the Edit List again to make sure all errors have been fixed To move forward with closing select Closing Register Close Period followed by either the Print or Preview option Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format 2011 Cast amp Crew Entertainment Services LLC CLOSING 335 Once you select Closing Register Close Period followed by either the Print or Preview option PSL3 displays the following message prompt 43 GLCLOSE If you select No PSL3 asks Would you like to reprint the register If you still select No you will receive a prompt notifying you the closing process is not done Ifyou select Yes you will
68. the F1 Key then A option to Accept which saves and clears the screen most common ee Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes X exit to menu v To add another distribution line press Enter or Tab where the last line was entered v To insert a distribution line in between already existing lines place your cursor where you want to add and press the F4 Key or select the Add icon B A new line is added beneath v To delete a distribution line place your cursor in the line you want to delete and press the F10 Key or select the Delete icon TI A red strike through line appears which is deleted upon saving Y To search for an existing entry press the F7 Key or select the Find icon Q when the screen is clear All records appear in which you can scroll through using the Arrow icons First Prior Next and Last l O O or by pressing the Page Up or Page Down Keys until you find the entry needed 2011 Cast amp Crew Entertainment Services LLC sto PSL3 User Manual Chapter 12 3 Cost Report EFC Worksheet Estimated Final Cost EFC is the projection of the anticipated costs to complete the Production equal to the sum of the estimate to complete and the actual costs to date for the Production The Cost Report EFC Worksheet efcws program allows you to modify EFC s similar to the EFC Entry efcent and Variance Entry bdve scre
69. the F4 Key or select the Add 2011 Cast amp Crew Entertainment Services LLC 24 PSL3 User Manual icon Bl A new line is added beneath v To delete an account number place your cursor in the account you want to delete and press the F10 Key or select the Delete icon m A red strike through line appears which is deleted upon saving Please note PSL3 only allows you to delete an account number that is not attached to an transaction v To search for an existing account number press the F7 Key or select the Find icon Q when the screen is clear All records appear in which you can scroll through until you find the account needed 2011 Cast amp Crew Entertainment Services LLC GENERAL LEDGER 215 Chapter 9 2 Chart of Accounts Listing Report The Chart of Accounts Listing Report glcap generates a listing of all account numbers in your database These account numbers are pulled from the Chart of Accounts Entry glca screen Chart of Accounts is the master list of all account numbers used to track Production costs including Assets Liabilities Capital Income and Expenses Open gt To access the Chart of Accounts Listing Report glcap click the G L module from the menu tree see following screen shot gt The Chart of Accounts Listing Report glcap is also located in the Report folder under the General Ledger and Setup amp Maintenance sub folders gt You can also access this report by typing th
70. the calendar selection to appear 2011 Cast amp Crew Entertainment Services LLC 40 PSL3 User Manual ce Pick a date lt January 2011 e ISO Input the International Organization for Standardization three letter currency abbreviation used to represent a country s currency For example the United States dollars ISO alphabetic currency code is USD for the United States Dollar This field can hold up to three alpha numeric characters Check Printing Information Bill Input the name of the currency which can hold up to 20 alpha numeric characters example Dollars and Input the word meaning and in the language in which checks will be written when using this Currency Code This field can hold up to 20 alpha numeric characters Coin Input the word meaning coins in the language in which checks will be written when using this Currency Code example Cents This field can hold up to 20 alpha numeric characters pay to Input the words for Pay to the order of in the language in which checks will be written when using this Currency Code This field can hold up to 20 alpha numeric characters Decimal Digits e Input Number of digits to appear to the right of the decimal point in transaction entry fields Enter one digit from 0 to 4 to indicate the number of digits you would like displayed after the decimal point The most common number entered is 2 e Reports Number of digits to appear to t
71. the following Vendor Screen Reports click the A P module then Vendor sub folder from the menu tree see following screen shot gt These additional Vendor Screen Reports are also located in the Report module under the A P Setup amp Maintenance and Vendors sub folders gt You can also access these screens reports by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter aj GL aj Checks aj Budget aj Cost 3 Closing B Recurring Batch 3 Report aj PSL3 Help t To select criteria for the following reporting screens press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 e Account Vendor Totals Report accvt Use accvt to print a total for each account vendor combination Only paid or wided A P distributions contribute to the totals This report converts all amounts to the base currency You can enter Starting and Ending Dates a range of Vendor ID Numbers Starting and Ending Account Numbers and Multiple Currency as selection criteria 2011 Cast amp Crew Entertainment Services LLC PSL3 User Manual A P Vendor Analysis Report apvena Use apvena to track A P transact
72. the toolbar Y You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and clears the screen most common 2011 Cast amp Crew Entertainment Services LLC so PSL3 User Manual ee Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes x exit to menu v To add another distribution line press Enter or Tab where the last line was entered v To insert a distribution line in between already existing lines place your cursor where you want to add and press the F4 Key or select the Add icon Bi A new line is added beneath v To delete a distribution line place your cursor in the line you want to delete and press the F10 Key or select the Delete icon TI A red strike through line appears which is deleted upon saving Y To search for an existing entry press the F7 Key or select the Find icon when the screen is clear All records appear in which you can scroll through using the Arrow icons First Prior Next and Last iS l O or by pressing the Page Up or Page Down Keys until you find the entry needed 2011 Cast amp Crew Entertainment Services LLC PURCHASE ORDER s1 Chapter 4 2 P OEdit List The P O Edit List poedtl reports on all purchase order distribution lines that are Relieved Open or Both This report is similar to the P O Report
73. then P option or select Print located in the top right hand corner to choose the Payroll Check file you wish to print from the list All invoices that have not been printed display on the pick list Please note Payroll Check files are printed one at a time NOTE Please email a request to support castandcrew com if you need to reprint Payroll checks for any reason e g wrong toner forgot to load in check stock etc and need them to be made available again Please provide the invoice number and or certain check numbers along with the reason for the reprint 2011 Cast amp Crew Entertainment Services LLC 200 PSL3 User Manual Chapter 8 6 Payroll History Report The Payroll History Report prhist generates a complete listing of an employee s Payroll history The report can also include multiple employees or all employees Payroll history in the database You can view the employee s Payroll data through the many selection criteria and sorting options listed on the report screen At the end of each employee listing PSL3 prints a Distribution Summary in account order followed by a Check Line Stub Summary Please note the Payroll History Report prhist displays only the Payroll transactions that were interfaced in the Load Interface C amp C Payroll Invoice printr screen It does not show Payroll entries manually created in Payroll Entry prent Open gt To access the Payroll History Report prhist click t
74. then the check would print as 3 000123 This field can hold up to six alpha numeric characters Account Information An account number must be input for all fields in the Account Information section even if you will not be using them all For example if you are not going to be using the A P Discount field you can not leave this field blank you must enter an account number as it is a white required field e Cash in Bank Chart of Accounts number representing the checking account for this bank account usually an Asset account If the account number doesn t exist in PSL3 you can add it by pressing the F5 Key or selecting the Zoom icon o located on the toolbar This zooms into the Chart of Accounts Entry glca screen in which you can add the account number immediately Once saved press the F1 Key then F option or select the Fetch icon 2011 Cast amp Crew Entertainment Services LLC 30 PSL3 User Manual e to fetch the account back to the Bank Code Entry subank screen A P Clearing Chart of Accounts number representing the account from which all A P invoices will be cleared usually a Liability account This account number is the credit entry also known as the offset account for A P expenses after you post the A P transaction s AIP Discount Chart of Accounts number representing the account from which all A P discount amounts will be recorded usually a Liability account P C Box Chart of Accounts numbe
75. to EFC Entry Variance if none was entered Ifthe Variance was created in the Cost Report EFC Worksheet efcws program the description defaults to EFC Worksheet VA if none was entered Batch Information e Codes that are attached to the transaction These fields are pulled from the User Entry suuser screen located in the Setup module if setup beforehand To change the defaulted codes press the F2 Key or right click in any of these fields Batch Production Company and Currency and make your selection If the Variance was created in either the EFC Entry efcent or Cost Report EFC Worksheet efcws programs the Batch Information defaults upon inputting the Reference Number with the codes previously input in either screen Total Variance e Sum ofall Variance Amounts entered in the distribution lines that is automatically tallied by 2011 Cast amp Crew Entertainment Services LLC 3o PSL3 User Manual PSL3 Please note you are not able to access this field Distribution Lines If the Variance was created in either the EFC Entry efcent or Cost Report EFC Worksheet efcws programs the distribution lines default upon inputting the Reference Number with the codes previously input in either screen Account Number Chart of Accounts number that will be debited or credited on this distribution line Press the F2 Key or right click to change the account number If the account number doesn t exist in PSL3 you
76. you press the F2 Key or right click in this field a calculator displays for your convenience ce Calculator 2011 Cast amp Crew Entertainment Services LLC Helpful Hints Y Make sure to input all white colored fields as white fields are required before saving in PSL3 Y To save this entry select either Save icon located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and clears the screen most common ec Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes x exit to menu v To add another budget line press Enter or Tab where the last line was entered or scroll down to the bottom of the screen and a blank line becomes available v To insert a budget line in between already existing lines place your cursor where you want to add and press the F4 Key or select the Add icon A new line is added beneath v To delete an unused budget line place your cursor in the line you want to delete and press the F10 Key or select the Delete icon fu A red strike through line appears which is deleted upon saving 2011 Cast amp Crew Entertainment Services LLC 288 PSL3 User Manual Chapter 11 5 Budget Listing Report The Budget Listing Report bdentp generates a listing of all fields in the Budget Amount Entry bdent scr
77. you select Yes you will receive a prompt confirming the selected P C transactions are now marked posted oc Information D Petty cash items posted 2011 Cast amp Crew Entertainment Services LLC PETTY CASH 1 35 NOTE Please note if you need to make distribution changes to posted items this can be done in the Posted Transaction ltem Editor glfix screen located in the J E module depending on your User ID and studio permissions Please be advised P C Entry pcent distribution lines will nof appear in the Posted Transaction Item Editor glfix if they were automatically created by PSL3 therefore you are not able to make changes to them in this program P C distribution lines only appear in the Posted Transaction Item Editor glfix screen if they were manually created You can also email a request to support castandcrew com if you need a transaction unposted and include the Reference Number s Please be advised depending on your specific studio s guidelines the Support Department may need to obtain approval from your Studio Finance Executive before proceeding NOTE Please note you are not able to re print a Posting Register once the transaction s are posted therefore if you need a copy of the report sent to you please email a request to support castandcrew com with the approximate date and time that the report was ran PSL3 houses all generated reports on a server 2011 Cast amp Crew Entertain
78. 0013 To see if the vendor already exists in PSL3 press the F2 Key or right click in the Vendor ID field Once the list of vendors appears you can scroll through to find the vendor or click on the column headers Vendor Name or City to sort alphabetically or numerically Vendor Name Name of the vendor or employee who will receive Petty Cash Advances Enter a unique Vendor Name of up to 30 alpha numeric characters It is best to be consistent in style when entering Vendor Names Commonly names are entered in ALL CAPS Ifthe vendor is a person the last name is entered first followed by a back slash and then the first name You can enter a middle initial after the first name but enter a space before the middle initial The Vendor Name format is as follows SMITH JOHN D The same format is the same 2011 Cast amp Crew Entertainment Services LLC so PSL3 User Manual for company names as well PRODUCTION COMPANY THE To see if the vendor already exists in PSL3 type the wildcard character using the asterisk in the Vendor Name field For example if you want to see if vendor John Smith exists you would type John or Smith and press the F7 Key or select the Find icon CJ located on the toolbar PSL3 displays how many records for that criteria exist by selecting the Arrow icons First Prior Next and Last located on the toolbar or by pressing the Page Up or Page Down Keys until you find the vendor needed WARNING
79. 1 Cast amp Crew Entertainment Services LLC aj Setup a AP jaj Pio a Pic sa JE a PR a GL ij Checks aj Budget 4 Cost Cost Report eferpt Cost Bible Report eferpt2 Average EFC Report avgefc Cost Detail Report costinff EFC Summary Yariance Report efedifh Episodic EFC Report efcser Variance Entry bdve Worksheel e1cws Account Variance Report bdvar Reference Yariance Report bdvep da Closing aj Recurring Batch 3 Report aj PSL3 Help 306 PSL3 User Manual dl bdve Variance Entry File Edit Programs Options View Favorites Help EMO A A REA MA CAL AAA rReference Information Baen Information Noor EEE Batch Eff Date v1 Production Description Company Total Variance Currency Account Sers Locs Sets in FEA Description Amour ff ransaction reference number Enter search criteria or add data E Reference Information e Reference Number System assigned number that is also referred to as transaction number To generate the next sequential Reference Number press the F4 Key or select the Add icon B located on the toolbar You can also right click outside a field in which Add option appears to add the next record Ifthe Variance was created in either the EFC Entry efcent or Cost Report EFC Worksheet efcws programs type in the Reference Number previously assigned in either screen and press Enter the F7 Key or select the Find icon l
80. 11 Cast amp Crew Entertainment Services LLC COST Section 12 COST This section will address the following programs gt EFC Entry gt Variance Entry gt Cost Report EFC Worksheet gt Estimated Final Cost Report gt Additional Cost Report Screens Reports 2011 Cast amp Crew Entertainment Services LLC 298 PSL3 User Manual Chapter 12 1 EFC Entry Estimated Final Cost EFC is the projection of the anticipated costs to complete the Production equal to the sum of the estimate to complete and the actual costs to date for the Production Use EFC Entry efcent to make EFC changes Once an EFC Variance change has been created PSL3 automatically adjusts the Cost to Complete Estimated Final Cost and Variance amounts on the Estimated Final Cost Report efcrpt Please note EFC s and Variances are created by one of three ways which are as follows 1 By directly accessing the Variance Entry bdve screen and inputting the change s there 2 By making the change s in the EFC Entry efcent screen After making and saving the EFC change s a Variance is created with the new Variance Entry bdve Reference Number appearing directly in the EFC Entry efcent screen for your records 3 By making the change s in the Cost Report EFC Worksheet efcws screen After making and saving the EFC change s a Variance is created with the new Variance Entry bdve Reference Number appearing directly in the Cost Report EFC W
81. 27 pm Detail Trial Delanos Cover Page igith Currency selected all currencies Printed in Dollaza Us Ch REVIEW DOLIARS CR 1 000000 1 000000 Currency for REVIEW NC 1 549300 1 000000 Demo Code 1 IE 1 635000 1 000000 Pounds Gh 1 800000 1 000000 Date Range All dates Peport ID DETAIUTN Production DEMO TFIIM DEMO DATABASE Start Acct First Account Company All Set All End Acct Last Account Source All mm All Excluding inactive eccounts J R Mumber All Insurance All Serien All location All Act Nun Recount Description Beginning Dal Deita Credits Net Change _ Ending Balance 0 00 600 00 1800 00 100 00 100 00 0 00 0 00 13 13 3 13 43 13 0 00 11 561 253 44 22459103 91 10 897 850 47 10 897 850 47 0 00 2 039 052 00 1013390 00 1 025 662 00 1 025 642 00 0 00 300 000 00 1650 00 299 350 00 299 350 00 9201 Office Petty Cash 0 00 37 093 14 1547 205 54 510 112 40 1510 212 40 9202 AMEX PETTY CASN 0 00 435 32 185 32 350 00 280 00 9203 3 Micholecn Set Dec 0 00 951 83 1451 83 500 00 500 00 9204 R Barg Property 0 00 3 150 00 1150 00 3 000 00 3 000 00 9205 M Grandas Marircte 0 00 5 099 08 13 049 08 2 050 00 2 060 00 9206 M Soria Dir Asat 0 00 169 83 1169 83 0 00 0 00 9207 N Moody Loc Mngr 0 00 1 042 04 542 04 500 00 500 00 9206 N Taglianetti Crafty 0 00 6 130 00 16 130 00 0 00 0 00 9209 D Kesting Poc 0 00 2 303 93 11 733 93 570 00 70 00 9210 Lufe
82. 5 Pio a Pic a JE a PR a GL EEE EEE A Budget ja Cos Closing jj Recurring Batch 3 Report ii PSL3 Help HH E To select criteria for the following reporting screens press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 e Account Variance Report bdvar Use bdvar to generate a Detailed or Summary list of Variance transactions in your database Detailed reporting can include every Variance entry along with the transaction details for each depending on the Date Range input The report can be ran by Account Range Start and End Dates Multiple Currency etc as selection criteria e Reference Variance Report bdvep Use bdvep to print a list of Variances entries for one day or for the entire reporting period sorted by Account Order or Entry Order The report can be used in conjunction with the Bible Report bdbr to show how and why account balances do not match the budgeted amounts 2011 Cast amp Crew Entertainment Services LLC NOTE The reports are available in either Print Preview and or Spreadsheet formats NOTE Please email support castandcrew com if you don t see a specific PSL3 report currently listed as an option in your database 20
83. 505 37 1900 30 1 004 87 1 004 87 TOTAL ASSETS 0 00 14 141 397 75 24059553 91 9 918 156 16 19 918 156 16 LIANTLITIES 7000 9501 Payroll Clesring 0 00 1 028 223 45 1491696 38 463 472 93 1463 472 93 9550 A P Clearing 0 00 21 105 754 39 21106166 29 411 90 1411 90 9551 a p clearing 2 0 00 766 56 1650 00 116 56 16 56 9590 Suspense 0 00 103 96 0 00 103 96 103 6 9800 FUNDING 0 00 500 000 00 17810000 00 7 310 000 00 7 310 000 00 9801 Sony 0 00 126 514 95 1 2614803 00 2 488 268 05 2 488 288 05 TOTAL LIABILITIES 0 00 22 761 363 31 33073315 10 261 952 36 10 261 952 36 EXPENSES q __n _ _ _ eRe Px _ OCPENSES 0 00 21 299 844 12 11119735 60 20 180 108 52 20 180 108 52 GRAND TOTALS 0 00 58 202 605 18 Se202605 18 0 00 0 00 O 2011 Cast Crew Entertainment Services LLC 224 PSL3 User Manual Chapter 9 4 Bible Report The Bible Report bdbr or also commonly referred to as the General Ledger is the original financial statement that produces a Detailed or Summary Report on distributions based on the date range or period selected The Bible Report bdbr generates a reference copy of all transactions that were entered in your PSL3 database The major difference between the Bible Report bdbr and the Chronological Bible Report bdbible is that the Bible Report bdbr is organized by Account Number and the Chronological Bible Report bdbible is organized by Reference Number Open
84. 56 o 8 656 o 8 656 2 500 6 156 12 78 BOX RENTALS 2 375 o 2 375 2 375 3 000 1625 12 80 PROD CONTRACTUALS 40 959 o 40 959 o 40 959 43 830 2 871 12 83 MISC EXPENSES 6 484 o 6 484 o 6 454 2 500 3 904 12 96 TEAMSTER MINT 3 840 o 3 840 i 3 840 9 059 5 839 12 98 DGA FRINGE 22 222 o 22 222 o 22 222 33 420 11 198 TOTAL 12 00 PROOUCERS UNIT 1 969 934 o 1 969 934 O 1 969 934 2 368 475 178 541 DIRECTION 13 00 13 01 DIRECTOR 2 000 000 o 2 000 000 O 2 000 000 2 000 000 o 13 06 ASST 70 DIRECTOR 40 553 o 40 593 o 40 553 28 190 12 363 13 08 DIR ENTERTADOENT 1 085 o 2 085 a 1 085 2 500 1 415 13 11 DIR RESEARCH 5 o 5 o s 2 000 1 995 13 15 STORYAD ARTIST o o o o o 00 8 800 13 20 TECH ADVISOR 13 360 o 13 360 o 13 360 19 000 5 640 13 78 BOX RENTALS 430 o 430 o 430 1 000 1570 13 40 DIR CONTRACTUALS 63 007 o 3 007 o 63 007 73 943 10 936 13 85 MISC EXPENSES 3 538 o 3 538 o 3 538 1 500 2 038 13 96 TEAMSTER FRIN 6 890 o 6 880 El 6 880 20 838 13 978 13 98 DGA FRINGE 45 000 o 45 000 o 45 000 45 000 0 PERA TS Y A O A A 1 42 0 LS E Lo TOTAL 13 00 DIRECTION 2 308 278 o 2 108 274 1 2 188 277 2 217 322 29 045 14 01 LEAD CAST 3 009 5900 3 009 500 O 3 009 500 3 000 000 9 500 14 02 SUPPORTING CAST 502 679 o 502 679 o 502 679 609 660 106 981 14 03 DAY PLAYERS 105 546 o 205 546 E 105 546 206 476 100 930 14 04 STUNT COORD 42 000 o 42 000 o 42 000 55 500 13 500 14 05 STUNTS 4 ADJ 5 756 o 5 756 o 5 756 27 909 22 153 14 06 STUNT EQU
85. C Transactions T Include AP Transactions F Include JE Transactions Vendor Number To select criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank Vendor Range e Starting and Ending Vendors to include in the report To restrict the report to only include information for a single vendor input the same Vendor Number in both the Starting and Ending fields To select all vendors leave both fields blank Transaction Selection e Press the F2 Key or right click in any of these fields Production Company Bank and Currency to choose the necessary codes if they don t already default To choose multiple codes for a particular field press the F2 Key or right click in that field and hold down the Control Key while simultaneously using your mouse to select By making a selection this isolates the report to only display items based on the code s selected Date Range e Starting and Ending Transaction Effective Dates to include in the report as PSL3 is date driven To restrict the report to only include information for a single date input the same date 2011 Cast amp Crew Entertainment Services LLC 138 PSL3 User Manual in both the Starting and Ending fields To select all dates from inception to future leave both fields blank Press the F2 Key or right click in
86. Currency Edit List Posting Register Account Number Reference Number Account per Line All batch numbers All reference numbers All productions All companies All currencies Account Number Entry Order JOURNAL ENTRY 157 Account Number Series Location set Enter a batch number leave blank for all A A e FE Post J E Transactions Selection Criteria e To select an entry press the F2 Key or right click in any of these fields Batch Reference Production Company and or Currency to select the item s needed You can also choose multiple entries by holding down the Control Key and simultaneously using the mouse to select By making a selection this isolates the report to only display items based on the code s selected If you wish to select all unposted Journal Entry transactions leave all fields blank Report Type e Defaults to Edit List to review your Journal Entries and make any necessary modifications prior to posting To move forward with posting select Posting Register followed by either the Print Preview or Spreadsheet option this will transfer the transaction s to the Bible Report bdbr Report Formats 2011 Cast amp Crew Entertainment Services LLC 158 PSL3 User Manual e Report Format Report Sort and Description Of are all sorting options available for you to select per your preference Print Preview the Report Located in the top right hand comer of t
87. F format gt Send Export Begins the exporting process 2011 Cast amp Crew Entertainment Services LLC Once you select Send Export PSL3 displays the following message prompt a Pospay Upload Has register printed correctly Register printed If you select No PSL3 asks Would you like to reprint the register If you still select No the exporting process is not done If you select Yes you will receive a secondary prompt confirming the Positive Pay file is now sent ee Information WARNING Please be advised do not click Send Export more than one time within a 15 minute interval or else two files get created Please contact the Support Department should this occur as one file becomes overridden 2011 Cast amp Crew Entertainment Services LLC 266 PSL3 User Manual Chapter 10 6 Additional Check Screens Reports PSL3 offers additional Check Screens Reports which are listed below Open gt To access the following Check Screens Reports click the Checks module from the menu tree see following screen shot gt These additional Check Screens Reports are also located in the Report module under the Checks sub folder gt You can also access these screens reports by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter a Cost Es Closing Bj Recurring Batch 5j Report aj PSL3 Help To select criteria for t
88. IP RENTALS m o 73 o m 3 500 1527 14 07 CASTING DIRECTOR 76 500 o 76 500 o 76 500 75 000 1 500 14 08 CASTING ASST 15 100 o 15 100 3 15 100 20 500 5 400 14 09 CASTING EXPENSES 20 421 o 20 623 o 30 423 19 250 8 029 14 20 LOOPING ADR 16 973 o 16 973 o 16 973 12 500 4 473 14 50 REMEAREAL o o 1 035 1 000 35 14 85 CAST CONTRACTUALS JONN o o 169 826 103 342 13 516 14 86 CAST CONTRACTUALS SAVANNAH 91 982 o o 91 982 110 707 18 725 14 87 CAST CONTRACTUALES 19 474 o o 17 454 36 943 19 469 14 68 OTHER CAST CONTRACTUALS 22 800 o o 22 000 10 700 12 100 14 90 CAST WC HANDLING FEES o o o o 19 663 19 663 14 44 SAG FRINGE 133 003 o 129 003 2 133 003 362 718 28 915 14 96 TEAMSTER FRINCE 20 583 o 20 583 1 20 583 46 873 26 290 TOTAL 14 00 CAST 4 287 943 o 4 287 943 2 4 287 945 4 704 475 416 534 2011 Cast amp Crew Entertainment Services LLC Chapter 12 5 Additional Cost Report Screens Reports PSL3 offers additional Cost Reporting Screens which are listed below Some of these reports can also be found in the section Additional Budget Inquiries and Reports Open gt To access the following Cost Reporting Screens click the Cost module from the menu tree see following screen shot gt These additional Cost Reporting Screens are also located in the Cost module as well as Report module under the Budgeting Cost sub folder gt You can also access these screens reports by typing the screen or acronym name in the blue prompt
89. No Variance transaction is created gt Update Saves the change s and remains on the screen A Variance transaction is created and the Variance Entry bdve Reference Number displays on the screen gt Accept Saves the change s and exits the screen A Variance transaction is created and the Variance Entry bdve Reference Number displays on the screen gt Cancel Discards any all changes and exits the screen No Variance transaction is created 2011 Cast amp Crew Entertainment Services LLC Chapter 12 4 Estimated Final Cost Report The Estimated Final Cost Report efcrpt is a detailed analysis that identifies costs to date and weekly costs as well as estimates the final costs to complete the Production The Estimated Final Cost Report efcrpt summarizes all costs recorded in the General Ledger as of the date range you specify listed by account number The report can be ran by a range of Expense Accounts and combine or display the balances separately for all Series Location and or Set Codes in addition to other selection criteria to tailor the report based on your preference Please note you are able to run the Estimated Final Cost Report efcrpt with selecting multiple budgets Open gt To access the Estimated Final Cost Report efcrpt click on Tab 7 or press ALT and the number 7 Key simultaneously to open the screen gt The Estimated Final Cost Report efcrpt is also accessible if you click the Cost modul
90. Number Payroll Check Numbers to include in the report To restrict the report to only include information for a single Payroll check input the same Payroll Check Number in both the From and To fields To select all Payroll checks leave both fields blank Employee Number Employee Numbers to include in the report To restrict the report to only include information for a single employee input the same Employee Number in both the From and To fields To select all employees leave both fields blank Week Ending Payroll Week Ending dates to include in the report as PSL3 is date driven This is the date marking the end of a weekly pay period To restrict the report to only include information for a single date input the same Week Ending date in both the From and To fields To select all dates from inception to future leave both fields blank Press the F2 Key or right click in either date field for the calendar selection to appear 2011 Cast amp Crew Entertainment Services LLC 202 PSL3 User Manual ce Pick a date lt January 2011 Selection Criteria Report Press the F2 Key or right click in any of these fields SSN Reference Production Company Code Payroll Company and Free Field s to choose the necessary codes if they don t already default Some fields allow you to choose multiple codes for a particular field in which you can press the F2 Key or right click in that field and hold down the Control Key while sim
91. Number JE Number Clear All Cancel Once the data is entered in to the Excel Spreadsheet correctly save the file as a Text Tab delimited txt format to your desired directory as shown on the following screen shot Please note you can also save as a Comma delimited csv format if the Text Tab delimited txt option does not import properly File name Save as type Import an Excel File txt v Text Tab delimited txt Text Tab delimited txt _ Unicode Text txt XML Spreadsheet 2003 xml Microsoft Excel 5 0 95 Workbook xls CSY Comma delimited csw 5 2011 Cast amp Crew Entertainment Services LLC JOURNAL ENTRY 171 Interface File e Select File Choose the Text Tab delimited txt or Comma delimited csv file you wish to load Please note that files are loaded one at a time Transaction Type e Select the type of transaction you wish to load which are as follows J E P O A P P C and VA Please note this program does not import Payroll transactions Default Distribution Codes e Press the F2 Key or right click in any of these fields Batch Production Company Bank Currency Series Location Set Insurance and Free Field s to choose the necessary codes ifthey don t already default Please note if you leave the Series Location or Set columns blank on the Excel Spreadsheet PSL3 loads the file with the codes you input here in the Def
92. Open gt To access the Load Interface C amp C Payroll Invoice printr screen click the P R module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter Load C amp C Invoice printr Entry prent Edit List prpost Post prpost History Report prhist Accrued Holiday Report acvhrpt Invoice Report prinyp Print Payroll Checks prekprnt Payroll Wasils Report prwasis ii GL ij Checks 3 Budget ii Cost 3 Closing ji Recurring Batch 3 Report 3 PSL3 Help E E E E E E tt The screen then appears 2011 Cast amp Crew Entertainment Services LLC PAYROLL E y invoice File F Load only the employee information without the payroll data Edit List Loading Register Batch Production Bank Currency Series FF1 Location Set Insurance invoice number Invoice Information e Invoice Select the Payroll invoice you wish to load by pressing the F2 Key or by right clicking in this field to choose from the list All unimported invoices that have not been interfaced display on the pick list You can also simply type in the invoice number and press Enter Please note invoice numbers are loaded one at a time Interface File Information e File This field automatically populates once you input an invoice number The invoice number displays at the end of the fil
93. RDER Section 4 PURCHASE ORDER This section will address the following programs gt P O Entry gt P O Edit List gt Additional P O Screens Reports 2011 Cast amp Crew Entertainment Services LLC PSL3 User Manual Chapter 4 1 P O Entry A Purchase Order is a record of expenses or financial commitment that serves as an approved written contract for goods and services Purchase Orders are entered in the P O Entry poent screen To transfer P O lines to A P use A P Entry apte Once a P O is entered and saved in PSL3 it is considered an Open P O and appears as a commitment on the Estimated Final Cost Report efcrpt Please note P O transactions do not get posted Open gt To access the P O Entry poent screen click on Tab 2 or press ALT and the number 2 Key simultaneously to open the screen gt P O Entry poent can also be accessed from the menu tree under the P O module see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter P O Edit List poedth P O Report poentp Pending Items Report pirpt Non Existing PO Report nepor iy Pic a JE a PR a GL ij Checks Budget ii Cost 3 Closing 3 Recurring Batch 3 Report ii PSL3 Help E E E EEEE The screen then appears 2011 Cast amp Crew Entertainment Services LLC PURCHASE ORDER e 8 Sisibis g DI N
94. Then press Enter amp Setup Banks subank Batch Maintenance batchent Control AYP suapctrh Currencies sucur Default Accounts suacct Employees pcemp Free Field1 sufree1 Free Field sufree2 Free Field3 sufree3 Free Field4 sufree4 Locations iC roductions suprod Recurring Batch rbcre Company Code sucomp Report Group Entry surpt Series suser DataBase Info sudbinfo Sets suset States sustate Users suuser Change Password newpass Vendor Entry apven a Reports Control System suctrl Line Type Entry sulntyp The screen then appears 2011 Cast amp Crew Entertainment Services LLC s PSL3 User Manual Fields e Production Input the Production Code associated with the Location Code e Location Input the code identifying the location which can hold up to four alpha numeric characters After entering the new Location Code PSL3 asks That Location Code is not in the database Would you like to add it Select Yes e Description Input the name of the location which can hold up to 30 alpha numeric characters Helpful Hints v Make sure to input all white colored fields as white fields are required before saving in PSL3 v To save this entry select either Save icon located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and
95. This distribution line is still a commitment on the Estimated Final Cost Report efcrpt gt R Relieved The distribution line has been Relieved transferred to A P Entry apte and the A P has been posted and or paid gt C Closed The distribution line has been Closed Manually Closing and Re opening Entire P O s and Individual P O Lines gt To close an entire P O that has not been relieved to A P Entry apte place your cursor in the Reference Number field in P O Entry poent and press the F1 Key then P option to close PSL3 then prompts you to input a closing date gt To close an individual P O line that has not been relieved to A P Entry apte place your cursor in the distribution line you would like to close in P O Entry poent and press F1 Key then L option PSL3 then prompts you to input a closing date gt To re open an entire P O place your cursor in the Reference Number field in P O Entry poent and press the F1 Key then O option to open gt To re open an individual P O line place your cursor in the distribution line you would like to open in P O Entry poent and press the F1 Key then L option Please make sure to save after performing any of the previously mentioned commands or the updates will not take effect Helpful Hints Y Make sure to input all white colored fields as white fields are required before saving in PSL3 v To save this entry select either Save icon located on
96. URNAL ENTRY 151 MISIL IG e 10 Ef Date j Batch ption Production Company Currency JE Number Total Debits Total Credits Account Sers Locs Sets f FFIIFF2IFF3 FF4 Descnption Amount Transaction reference number Enter search criteria or add data a s Reference Information e Reference Number System assigned number that is also referred to as transaction number To generate the next sequential Reference Number press the F4 Key or select the Add icon located on the toolbar You can also right click outside a field in which the Add option appears to add the next record Effective Date Date of the transaction that is recorded on the Bible Report bdbr and appears as an Actual Cost on the Estimated Final Cost Report efcrpt should default with today s date after generating the Reference Number You can always change it by typing over the defaulted date or by right clicking in that field for the calendar selection to appear Please note you can nof input a date that is in a previously closed period 2011 Cast amp Crew Entertainment Services LLC 152 PSL3 User Manual cc Pick a date 7a A afafafofetzio aofa pajis 14 15 47 16 19 20 21 22 012214157 NOTE Please email a request to support castandcrew com if you need a transaction s Effective Date changed and include the Reference Number s Please be advised depending on your specific studio s guidelines the Support Department m
97. accounts that had no activity distributions posted to them during the period or date range selected or have a zero dollar balance Include P O s Check mark to include open P O s If a P O distribution line is transferred to an A P transaction but the A P is not yet posted then the P O line is still considered open A P O distribution line remains open and is considered a Commitment on the Estimated Final Cost Report efcrpt until the A P containing the transferred P O line is posted marking it relieved or until the P O line is closed Include Beginning Balance Beginning Balance is Activity Check mark to include the Beginning Balance and consider active accounts that have a non zero Beginning Balance Include Audit Information Include User Check mark to isolate transactions entered by a single User ID for auditing purposes Show Hide e Series Separation Check mark if you want transactions for each Series Code displayed separately If selected the report is broken down by account number then Series Code e Location Separation Check mark if you want transactions for each Location Code displayed separately If selected the report is broken down by account number then Location Code if Series Separation is not check marked first 2011 Cast amp Crew Entertainment Services LLC GENERAL LEDGER 229 e Set Separation Check mark if you want transactions for each Set Code displayed separately If selected the report
98. ail support castandcrew com NOTE The reports are available in either Print Preview and or Spreadsheet formats NOTE Please email support castandcrew com if you don t see a specific PSL3 report currently listed as an option in your database 2011 Cast amp Crew Entertainment Services LLC ACCOUNTS PAYABLE 117 Chapter 5 7 Additional A P Screens Reports PSL3 offers additional A P Screens Reports which are listed below Some of these reports can also be found in the section Additional Vendor Screens Reports Open gt To access the following A P Screens Reports click the A P module then click the Vendor and A P Entry sub folders from the menu tree see following screen shot gt These additional A P Screens Reports are also located in the Report module under the A P sub folder gt You can also access these screens reports by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 3 Setup Sa AP E ne ene A Za AP Entry Ej Checks 5j 1099 a Pio a Pic sa JE a PR a GL ij Checks aj Budget aj Cost a Closing ii Recurring Batch B Report da PSL3 Help A E E eee eee amp amp amp amp To select criteria for the following reporting screens press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all crite
99. aja 2 a a le End Date Cut off date for this transaction to include up to Please note many transactions are created with future dates therefore the worksheet will only include information up to this date not past it Please note the Effective Date and End Date are usually input with the same date for consistency purposes Account Selection e From and To Account numbers to include in the worksheet To restrict the worksheet to only include information for a single account number input the same account in both the From and To fields To multi pick certain accounts press the F2 Key or right click in either field and hold down the Control Key while simultaneously using your mouse to select To select all account numbers leave both fields blank Selection Criteria e Press the F2 Key or right click in these fields Series Location and Set to choose the necessary codes To select all Series Location and Set Codes leave these fields blank Check mark the Combine option to combine all Series Location and or Set Codes into one line on the worksheet Options e Include Committed Costs Check mark to include Committed Costs items entered in the database but not yet paid which consist of P O s and Open Items e Include Inactive Accounts Check mark to include accounts that had no activity distributions posted to them during the date range selected or have a zero dollar balance 2011 Cast amp Crew Entertain
100. allotted fields e Budget Name Entry bdname Use bdname to add a new Budget Name find existing Budget Names modify an exiting budget s Description and Production Code the Production Code can only be changed if no budget lines have been entered and delete Budget Names if 2011 Cast amp Crew Entertainment Services LLC no budget lines have been entered e Copy Merge Budgets bdmove Use bdmove to copy an existing budget or merge two budgets This program also allows you to rename a budget by copying it to a new budget with the new name or change all of the budget amounts by the same percentage This screen is also used to quickly create a budget for a new Series Code Episode within one Production 2011 Cast amp Crew Entertainment Services LLC 22 PSL3 User Manual Chapter 11 7 Additional Budget Inquiries and Reports PSL3 offers additional Budget Inquiries and Reports which are listed below These reports can also be found in the section Additional Cost Report Screens Reports Open gt To access the following Budget Reports click the Budget module from the menu tree see following screen shot gt These additional Budget Reports are also located in the Cost module as well as Report module under the Budgeting Cost sub folder gt You can also access these reports by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter Setup a AP
101. ank NOTE Please note Card Numbers are usually not listed right away after making purchases as it takes a couple of days for P Card transactions to post to the bank and appear in this screen Transaction Date Selection e Start Date and End Date Dates to include for viewing the P Card transactions Press the F2 Key or right click in either date field for the calendar selection to appear To restrict the screen to only include information for a single date input the same date in both the Start Date and End Date fields To select all dates from inception to future leave both fields blank cc Pick a date a7 ne 19 20 121 122 JUMAA Include e New Select to only include data which has not previously been exported by P Card View Report pcardlp into either the A P Entry apte or Import an Excel File xlint e Exported Select to only include data which has previously been exported by P Card View Report pcardlp into either the A P Entry apte or Import an Excel File xlint Both Select to include both New and previously Exported data 2011 Cast amp Crew Entertainment Services LLC PETTY CASH 143 Sort By e Transaction Date New on top Exported on top are all sorting options available for you to select per your preference Amounts e Total Billing Amount US Displays the total dollar amount billed in U S Currency for the selected Card Number s Please note yo
102. astandcrew com if you would like the Chart of Accounts imported into your new database from a PSL3 database you previously worked on if none was specified on the initial database request Open gt To access the Chart of Accounts Entry glca screen click the G L module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC GENERAL LEDGER 211 Tee EEE amp Report Group Entry surpth Trial Balance glth Bible bdbr Ledger Bible Report ledbib Asset Report assetrpt Recurring Batch Process rbproc a Inquiry aj Checks Budget ay Cost aj Closing ii Recurring Batch aj Report 3 PSL3 Help E E amp FF HF The screen then appears a gica Chart of Accounts Entry File Edit Programs Options View Favorites Help File Edit Programs Options View Favorites Help 181 0101 91 B1 8101 31 B1015101Q010101 01 101510 M Type Line Post Sub e Account Number Combination of characters of the same length and format as the account mask After entering the new account number PSL3 asks That Account is not in the database Would you like to add it Select Yes To search for an existing account press the F2 Key or right click in the Account Number field to choose from the list You can also search for a ran
103. ault Distribution Codes section The other fields Vendor Number State Worked P O Number Invoice Number and Envelope Number only become accessible depending on the Transaction Type selected Make sure to input all white colored fields as white fields are required before proceeding in PSL3 Report Type e Defaults to Edit List to review the file import prior to loading To move forward with loading select Loading Register followed by either the Print or Preview option Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format 2011 Cast amp Crew Entertainment Services LLC 172 PSL3 User Manual Once you select Loading Register followed by either the Print or Preview option PSL3 displays the following message prompt confirming the file is now interfaced cc Information File data interfaced to PSL Once imported the newly created Reference Number is listed on the Excel Interface Register The new transaction is also created with an unposted status in which you can still modify before posting Upon selecting Loading Register you may also receive the following warning message if your Excel Spreadsheet
104. ay need to obtain approval from your Studio Finance Executive before proceeding Description Explanation of this Journal transaction as a whole which can hold up to 30 alpha numeric characters This Reference Description defaults in the distribution lines If this field is left blank PSL3 defaults the distribution description with the description of the first account number selected Status Overall status of the transaction This field is marked with a U for an Unposted entry until you post it in the Post J E Transactions jepost screen As long as the transaction is marked with an unposted status you are able to modify it Once posted it is marked with a P for Posted PSL3 updates the status automatically 2011 Cast amp Crew Entertainment Services LLC JOURNAL ENTRY 153 NOTE Please email a request to support castandcrew com ifyou need a transaction unposted and include the Reference Number s Please be advised depending on your specific studio s guidelines the Support Department may need to obtain approval from your Studio Finance Executive before proceeding Batch Information e Codes that are attached to the transaction These fields are pulled from the User Entry suuser screen located in the Setup module if setup beforehand To change the defaulted codes press the F2 Key or right click in any of these fields Batch Production Company and Currency and make your selection Journal Informat
105. bove the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC PAYROLL 189 za Setup a AP ij Pio i Pic i JE Ea PR Load C amp C Invoice printr bee amp amp amp History Report prhist Accrued Holiday Report acvhrpt Invoice Report prinyp Print Payroll Checks prekprnt Payroll Wasils Report prwasis ii GL ij Checks aj Budget day Cost ii Closing 3 Recurring Batch ij Report aj PSL3 Help BHR HF FF The screen then appears 2011 Cast amp Crew Entertainment Services LLC 190 PSL3 User Manual z Batch All batch numbers Reference All reference numbers Invoice Production All productions Company All Companies Bank All banks Currency All currencies Edit List Posting Register Account Number Account Number Account Number Reference Number Entry Order Series Account per Line Location Set Enter a batch number leave blank for all Post P R Transactions Selection Criteria e To select an entry press the F2 Key or right click in any of these fields Batch Reference Invoice Production Company Bank and or Currency to select the item s needed You can also choose multiple entries by holding down the Control Key and simultaneously using the mouse to select By making a selection this isolates the report to only display items based on the code s selected If you wish to select all unposted Payroll transactions leave
106. bs aj Closing a Recurring Batch ij Report aj PSL3 Help E E EA A The screen then appears 2011 Cast amp Crew Entertainment Services LLC ru L G Is HIG Ko DI Bank F Include Checks Date Currency include Deposits Check Number One Line Per Check Num Vendor Name Cash Account Statement Date I Use Statement Date As Cutoff Date Out Clear Outstanding Cleared Beginning Checks 0 0 Cleared Deposits 0 0 Statement Reconciling items Difference EN Date or Reference Description Cleared Clear Date Check Number Check Date Type Reference or Vendor Name Amount 0 Enter a bank code Enter search criteria E Selection Criteria e Bank Bank Code to perform the Bank Reconciliation Press the F2 Key or right click to select the bank e Currency Currency Code associated with the Bank Code defaults upon selecting the bank All transaction amounts included in the reconciliation are translated to this currency e Cash Account Cash in Bank Account associated with the Bank Code defaults upon selecting the bank This field is pulled from the Bank Code Entry subank screen e Statement Date Date when the items will be marked as Cleared This field defaults to today s date but you can change it by typing over the defaulted date or by right clicking in this field for the calendar selection to appear 2011 Cast amp Crew Entertainment Services LLC 258 PSL3 User Manual ce Pick a date
107. can add it by pressing the F5 Key or selecting the Zoom icon o located on the toolbar This zooms into the Chart of Accounts Entry glca screen in which you can add the account number immediately Once saved press the F1 Key then F option or select the Fetch icon e to fetch the account back to the Variance Entry bdve screen NOTE The Series Location Set and Free Field Codes are brought over from the User Entry suuser screen located in the Setup module if setup Otherwise press the F2 Key or right click in these fields to make your selection Description Explanation for this distribution line which can hold up to 30 alpha numeric characters Amount Dollar or other currency amount for this distribution line If you are entering a negative amount input the minus sign before the number Please note if you press the F2 Key or right click in the Amount field a calculator displays for your convenience ce Calculator 2011 Cast amp Crew Entertainment Services LLC NOTE Please note Variance Entry bdve transactions do not get posted Once the transaction is saved it is recorded in your database Helpful Hints v Make sure to input all white colored fields as white fields are required before saving in PSL3 v To save this entry select either Save icon located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press
108. cated in the Report module under the Purchase Order sub folder gt You can also access these screens reports by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter Fes sa JE a PR a GL aj Checks aj Budget aj Cost ii Closing jj Recurring Batch 3 Report aj PSL3 Help KERN To select criteria for the following reporting screens press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 e P O Report poentp Use poentp to print a list of all P O transactions The report can be ran to include P O Type Reference Number Vendor and a range of P O Numbers You can also include Closed P O s Open P O s and or Transferred Items Effective and Expiry Start and End Dates can also be input as selection criteria In addition you can sort the report by Reference Entry P O number Distribution Entry and or Account Number order This report is similar to the P O Edit List poedtl except it does not offer a wide variety of Report Type sorting options Pending Items Report pirpt Use pirpt look for transactions that you may want to post pay defer or relieve Pending items are transactions that have been entered in the database but
109. checks 2011 Cast amp Crew Entertainment Services LLC Term check stock cost report currency conversion disposition edit list employee entry episodic budget estimated final cost execute general ledger hand typed inactive independent contractor instance journal entry location bank 352 PSL3 User Manual Definition An inventory of unsigned blank checks sometimes imprinted with the production name and address for use in the accounts payable process A detailed weekly analysis that identifies costs to date identifies weekly costs and estimates the final costs to complete the production The conversion of foreign monetary currency in order to reflect production costs and or transaction against a particular currency the act of exchanging one type of currency into another type To complete an activity or change in status For example you disposition new entries by saving or canceling them A report that shows the items to be posted without actually posting the items A person paid for doing work under direction See also independent contractor Generic term for a record or a transaction that is saved in PSL3 series budget The overall budget for an episodic production such as a recurrent television show EFC The projection of the anticipated costs to complete the production equal to the sum of the estimate to complete and the actual costs to date for the production usually calcula
110. clears the screen most common 2011 Cast amp Crew Entertainment Services LLC ee Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes X exit to menu v To delete an unused Location Code place your cursor in the specific Location Code you want to delete and press the F10 Key or select the Delete icon m Red strike through lines appear which are deleted upon saving v To search for an existing Location Code press the F7 Key or select the Find icon when the screen is clear All records appear in which you can scroll through using the Arrow icons First Prior Next and Last l l O or by pressing the Page Up or Page Down Keys until you find the code needed 2011 Cast amp Crew Entertainment Services LLC 4 PSL3 User Manual Chapter 2 7 Set Code Entry Use Set Code Entry suset to set up Set Codes for tracking expenses by set Please note if you are not tracking set expenses you must setup at least a default Set Code e g 0000 to be used in the transaction entry screens You can also use the Set Code like a Free Field Code to track other items such as all travel costs for all sets if you prefer Please note a Set Code record can not be deleted once it has been used in PSL3 If you would like to print a list of all Set Codes entered in the database click the Report module then Setup amp Maintenance sub folder List
111. converted to on the worksheet Reference Batch e Press the F2 Key or right click in any of these fields Batch Company and Effective Date to choose the necessary codes ifthey don t already default The codes selected will be associated with the Variance Entry bdve transaction once created To run the Cost Report EFC Worksheet efcws from a previous Variance transaction created use the Variance Reference field to input the Reference Number 2011 Cast amp Crew Entertainment Services LLC 36 PSL3 User Manual Worksheet gt To proceed with the worksheet press the F1 Key then W option or select Worksheet located in the top right hand corner of the screen After selecting Worksheet the interactive Cost Report EFC Worksheet efcws appears in which you can make the necessary EFC or Variance change s directly on the screen Ga EFC Worksheet ln Se ESD eS le Loe L a RIGHTS WRITERS SA T Ross Screw rT Tia PROD CLEAR 1716 ol 1 009 608 716651 1 080 000 a fra 5473 1 Fee 1 000 09 a a ei 5473 a 2726304 47 54 ICC 0 0 0 0 0 0 0 Total STORY amp ROGHTS PRODUCERS UPET T DEE PRODU T PRODUCER I ASST TOPR PROD ENTER BOX RENTAL PROD CONTA Tast DPEN TTLAMSTER E T DGA FRINGE EERTE 1 400 050 30 118 DIRECTOR T Asst TO OF T OR ENTERT DIR REBEAR STORYEO AR TECH ADVIS BOX RENTAL DIR CONTRA msc DPEN I JEAMSTER F DGA FRINGE Total Fen 1 4 q a a d
112. ctions You can specify the Invoice Selection by Vendor Reference Number Inwice Number P O Number and or Location Code You can also choose the Currency Transaction Type Open and or Paid Items Start and End Dates etc as selection criteria Pending Items Report pirpt Use pirpt look for transactions that you may want to post pay defer or relieve Pending items are transactions that have been entered in the database but have not gone all the way through the accounting process You can enter a range of Account Numbers choose the Account Type and generate either a Combined or Individual Detail or Summary Report You can also input Start and End Dates and choose the Date Type by Effective or A P Due Date In addition you can include the Transaction Status Postable Deferred Payable and or Open P O Multiple Currency etc as selection criteria Please note this report is also accessible in the P O module NOTE The reports are available in either Print Preview and or Spreadsheet formats NOTE Please email support castandcrew com if you don t see a specific PSL3 report currently listed as an option in your database 2011 Cast amp Crew Entertainment Services LLC POL PETTY CASH Av PETTY CASH 1 21 Section 6 PETTY CASH This section will address the following programs gt P C Entry gt Post P C Transactions Edit List gt P C Crew Advances Activity Report gt P Card View Report
113. d in the Setup module defaults This Currency Code is what all transactions are converted to on the report Each currency in your database and its conversion rate are listed in the report heading Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to generate the report gt Print Combined Report Opens the Print Dialogue box and sends the report combining all Series Location and Set Codes onto one report directly to the printer gt Print Individual Report Opens the Print Dialogue box and sends the report separating each Series Location and Set Codes into separate reports directly to the printer gt Preview Combined Report Generates a PDF format report combining all Series Location and Set Codes onto one report and appears instantly on your screen You are still able to print from the PDF format gt Preview Individual Report Generates a PDF format report separating each Series Location and Set Codes into separate reports and appears instantly on your screen You are still able to print from the PDF format gt Spreadsheet Generates an Excel format report and appears instantly on your screen You are still able to print from the Excel format Please note if you select this option you are able to have additional sorting options within Excel Below is a sample of the first page of a Combined Estimated Final Cost Report efcrpt in the PSL Standard
114. d or Alignment in addition to the Period or Date Range to generate the report by This report is similar to the Check Register Summary Report ckolcr by listing one line of information per check however it also includes the added line item details of the A P invoice transaction Rapid Check ckent Use ckent to print a single demand check for immediate printing and paying an invoice This screen is especially beneficial when the A P transaction has not been entered in A P Entry apte because this program creates an new unposted A P transaction It is also helpful when the A P transaction is unposted because you won t have to post it before you print the check Please note this program still prints a Check Register Report at the end of the check printing process NOTE The reports are available in either Print Preview and or Spreadsheet formats NOTE Please email support castandcrew com if you dont see a specific PSL3 report currently listed as an option in your database 2011 Cast amp Crew Entertainment Services LLC POL BUDGET Exi Section 11 BUDGET This section will address the following programs gt Import a Budget gt Create a Budget gt Delete a Budget gt Budget Amount Entry gt Budget Listing Report gt Additional Budget Screens gt Additional Budget Inquiries and Reports 2011 Cast amp Crew Entertainment Services LLC 272 PSL3 User Manual Chapter 11 1 Import a Bu
115. ded one at a time Clearing e Clearing Account Input the Payroll Clearing Account Number The Payroll Clearing Account Number is used as the offset or the credit entry when Payroll transactions are posted When the invoice is paid this account number is debited and cash is credited Default Batch Codes e Press the F2 Key or right click in any of these fields Batch Production Company Bank and Currency to choose the necessary codes if they don t already default Please note whichever Batch Number you input here is carried through to the Journal Entry jete screen You can also create a new Batch Number with up to six alpha numeric characters e g 2011 Cast amp Crew Entertainment Services LLC PAYROLL PAYROLL to keep track of all Payroll transactions Default Distribution Codes e Press the F2 Key or right click in any of these fields Series Location Set Insurance and Free Field s to choose the necessary codes if they don t already default Inputting the default codes here does not change the existing codes already on the Payroll Data file it simply takes the place of any errors e g illegal invalid account series location set etc that have been encountered Make sure to input all white colored fields as white fields are required before proceeding in PSL3 Print Preview the Report Located in the top right hand corner of the screen you can choose the following options to generate the report g
116. default upon entering the screen Open Item Selection e Press the F2 Key or right click in any of these fields Select A P by Due Date Vendor Invoice Batch Reference and Production to choose the necessary items you wish to print ifthey don t already default Some fields allow you to choose multiple codes for a particular field in which you can press the F2 Key or right click in that field and hold down the Control Key while simultaneously using your mouse to select By making a selection this isolates PSL3 to only print checks based on the open item s selected To select all posted A P transactions leave all fields in the Open Item Selection blank Check Alignment and Printing Checks e Alignment Prior to the check printing process you can choose the Alignment option located in the top right hand corner to estimate how the check s will be formatted 2011 Cast amp Crew Entertainment Services LLC WARNING Please be advised if you select the Alignment option the next available check number is used for the Bank Code entered This check number appears on the Check Register Summary Report ckolcr with the default description COMPUTER ALIGNMENT VOID e Print To ensure check alignment accuracy it is suggested to select the Print option located in the top right hand corner instead of Alignment for your first computer check using real check stock In doing so the Support Department can see exactly
117. dget The Import a Budget bdint program is used to import a budget file from either Movie Magic or EP Budgeting into PSL3 This program also provides the option to create new account numbers from the budget you are importing creating your Chart of Accounts Once you have successfully imported a budget into PSL3 you are able to make any necessary modifications change budgeted amounts enter budget lines specific to a particular Series Location or Set Code delete an account add an account etc manually in the Budget Amount Entry bdent screen Open gt To access the Import a Budget bdint screen click the Budget module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter aj Setup a AP a Pio a Pic B JE a PR a GL dai Checks 3 Budget EFC Entry efcent Variance Entry bdve ue amp E E t tte Account Variance Report bdvar Reference Variance Report bdvep Import a Budget bdint aj Maintenance 5 Cost 3 Closing ji Recurring Batch ii Report PSL3 Help The screen then appears 2011 Cast amp Crew Entertainment Services LLC E Budget Name Production Scenes Location Set Currency F Create New Accounts Combine Existing Amounts With Interface Amounts Replace Basting Amounts With Interface Amounts Preserve Budget Amounts and Ignore I
118. e Free Field s Description Employee Number and Amount and make your selection You can also simply type in the changes in the allotted fields e Account Number Chart of Accounts number that will be debited or credited on this distribution line Ifthe Payroll Interface file contains an account number that does not exist in PSL3 then the Suspense Account will automatically default if setup otherwise the Account 2011 Cast amp Crew Entertainment Services LLC PAYROLL 185 Number field is left blank Press the F2 Key or right click to change the account number If the account number doesn t exist in PSL3 you can add it by pressing the F5 Key or selecting the Zoom icon a located on the toolbar This zooms into the Chart of Accounts Entry glca screen in which you can add the account number immediately Once saved press the F1 Key then F option or select the Fetch icon e to fetch the account back to the Payroll Entry prent screen WARNING Please be advised although you can save a Payroll transaction with a Suspense Account Number in Payroll Entry prent PSL3 does not allow you to post it in the Post P R Transactions prpost screen NOTE The Series Location Set Insurance and Free Field Codes are brought over from Payroll Interface file If the Payroll Interface file contains codes that do not exist in PSL3 the codes input in the Load Interface C amp C Payroll Invoice printr screen default ins
119. e from the menu tree see following screen shot as well as the Report folder under the Budgeting Cost and Weekly sub folders gt You can also access this report by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC 32 PSL3 User Manual OO OM The screen then appears I E E EEE EEE EEE H k E ii Setup ii AP ij Pio a Pic i JE Bj PR GL ij Checks aj Budget Average EFC Report avgefc Cost Detail Report costinff EFC Summary Variance Report efediff Episodic EFC Report efeser EFC Entry fefcent Variance Entry bdve EFC Worksheet efcws Account Variance Report bdvar Reference Variance Report bdvep ii Closing ji Recurring Batch ii Report 3 PSL3 Help 2011 Cast amp Crew Entertainment Services LLC COST 321 Q HOME 4 CHECKS PETTY CASH 6 PAYROLL 2 COST REPORT FEELS 9 TRIAL BALANCE File Edit Programs Options View Favorites Help IBISISI I01 51810 Budget Information Budget Production ja ee Period Period Start Date End Date ff Selections Company I Detal fers 4 F a Erestion Set Insurance FFI FF2 FF3 Fra the budget code for this report F Detail F Detail Hiit Format Type PSLStandara v Summary Suuta LEVE o rinclude F Inactive Accounts
120. e Field Codes are brought over from the User Entry suuser screen located in the Setup module if setup Otherwise press the F2 Key or right click in these fields to make your selection 1099 and Third Party Expense 1099 Code associated with the distribution ifany A 1099 is a tax form Press the F2 Key or right click to choose the necessary code The State Worked field in the Vendor Information section must be input for the 9 field to be accessible Please note if the 9 field does not have a code displayed the 3rd Party field will nof be available to select the Third Party Vendor Description Explanation for this distribution line which can hold up to 30 alpha numeric characters Amount Dollar or other currency amount for this distribution line should default with the remaining P C amount when you input an amount in the Amount Advanced and or Accounted for Amount fields Please note if you press the F2 Key or right click in the Amount field a calculator displays for your convenience 2011 Cast amp Crew Entertainment Services LLC PETTY CASH 129 ec Calculator Helpful Hints v Make sure to input all white colored fields as white fields are required before saving in PSL3 v To save this entry select either Save icon k i located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and
121. e Field Codes are brought over from the User Entry suuser screen located in the Setup module if setup Otherwise press the F2 Key or right click in these fields to make your selection 1099 and Third Party Expense 1099 Code associated with the distribution ifany A 1099 is a tax form Press the F2 Key or right click to choose the necessary code The State Worked field in the Vendor Information section must be input for the 9 field to be accessible Please note if the 9 field does not have a code displayed the 3rd Party field will nof be available to select the Third Party Vendor Description Explanation for this distribution line which can hold up to 30 alpha numeric characters Amount Dollar or other currency amount for this distribution line should default with the remaining P O amount when you select or input an account number Please note if you press the F2 Key or right click in the Amount field a calculator displays for your convenience ce Calculator e ST Status Status types of individual P O distribution lines are as follows 2011 Cast amp Crew Entertainment Services LLC PURCHASE ORDER gt O Open The distribution line is still open it has not been Transferred Closed or Relieved This field does not display a status type if Open it is just left blank gt T Transferred The distribution line has been Transferred to A P Entry apte but the A P transaction has not yet been posted
122. e budget you can append those new account numbers to your existing budget with the Create a Budget bdgl program as well Please note Header Accounts are not included when copying account number data into the budget NOTE Please note you must have a budget input in to PSL3 in order to run the Estimated Final Cost Report efcrpt If you don t have a budget input yet you can create a Zero Dollar Budget here in the Create a Budget bdgl screen Open gt To access the Create a Budget bdgl screen click the Budget module then Maintenance sub folder from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC 278 PSL3 User Manual aj Setup a AP a Pio ja Pic sa JE a PR a GL ij Checks 3 Budget EFC Entry fefcent Variance Entry bdve U E E amp amp Account Variance Report bdvar Reference Variance Report bdvep Import a Budget bdint Budget Listing bdentp 4 Maintenance Budget Amount Entry bdent ouvwMerge Budge bdmove Budget Name Entry bdname B Cost 3 Closing aj Recurring Batch 3 Report aj PSL3 Help E amp t The screen then appears 2011 Cast amp Crew Entertainment Services LLC ZB bagi Create Budget File Edit Programs Options View Favorites Help OO Wel Tr y
123. e name and looks something like this usr pa inv yourdatabasename 123456 Please note you are not able to access this field Load Data e Load only the employee information without the payroll data Check mark this box only if you want to load new employee records Otherwise to load both new employee records and the Payroll invoice data into PSL3 leave this box unchecked which is the default 2011 Cast amp Crew Entertainment Services LLC 178 PSL3 User Manual Default Distribution Codes e Press the F2 Key or right click in any of these fields Batch Production Company Bank Currency Series Location Set Insurance and Free Field s to choose the necessary codes ifthey don t already default Inputting the default codes here does not change the existing codes already on the Payroll Interface file it simply takes the place of any errors e g illegal invalid account series location set etc that have been encountered upon loading Please note whichever Batch Number you input here is carried through to Payroll Entry prent in addition to A P Entry apte if your database is setup for the Automatic A P option You can also create a new Batch Number with up to six alpha numeric characters e g PAYROLL to keep track of all Payroll transactions Make sure to input all white colored fields as white fields are required before proceeding in PSL3 Report Type e Defaults to Edit List to review the selected invoice fi
124. e screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter U amp AE Report Group Entry surpt Trial Balance gltb Bible bdbr Ledger Bible Report ledbib Asset Report assetrpt Recurring Batch Process rbproc 5j Inquiry aj Checks a Budget Ea Cost Ea Closing ay Recurring Batch a Report aj PSL3 Help The screen then appears 2011 Cast amp Crew Entertainment Services LLC 216 PSL3 User Manual KOLORE HE IK O 2011 Cast amp Crew Entertainment Services LLC GENERAL LEDGER 217 To select criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank e Chart of Accounts Information e Starting and Ending Account Account numbers to include in the report To restrict the report to only include information for a single account number input the same account in both the Starting Account and Ending Account fields To select all account numbers leave both fields blank e Account Type Information The report can also be run to include only certain account numbers based on the following option types Account Type Single letter classification indicating the Account Type Asset Liability C apital Income Expense Line Type Single letter classification indicating the Line T
125. e the existing budget amounts intact and ignore import file budget amounts The result is the existing budget amounts Translation Coding that displays how the budget line account numbers are formatted from the file include account numbers and 0 ignore account numbers Please note the Support Department usually modifies this field if needed Account Displays the account mask for the Chart of Accounts e g XXX XX XX etc Please note you are not able to access this field 2011 Cast amp Crew Entertainment Services LLC NOTE Please email a request to support castandcrew com if you need your databases account mask changed The default account mask for a new database is XXXX Print Preview the Report Located in the top right hand corner of the screen you can choose the following options to generate the report gt Print Edit Opens the Print Dialogue box and sends the report directly to the printer gt Preview Edit Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format gt Import Begins the importing process Once you select Import PSL3 displays a message similar to the following message prompt confirming the budget is now loaded ee Information 6 Budget added Reading Interface file Budget Lines 660 To review or make any changes to the budget use the Budget Amount Entry bdent screen located in the Budget m
126. eck s should default to today s date You can always change it by typing over the defaulted date or by right clicking in that field for the calendar selection to appear Please note you cannot input a date that is in a previously closed period 2011 Cast amp Crew Entertainment Services LLC 252 PSL3 User Manual ce Pick a date Register e Print Detail Check mark this option to generate a Detailed Register of the check s which is the default setting Ifleft unchecked a Summary Register is printed instead Print Preview the Report Located in the top right hand corner of the screen you can choose the following options to void and or reissue and generate the report gt Print Opens the Print Dialogue box sends the report directly to the printer and begins the voiding process gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format WARNING Please be advised in order to complete the wid and or reissue process you must select the Print option If you select Preview the check s does not get voided 2011 Cast amp Crew Entertainment Services LLC CHECKS 253 Once you select Print PSL3 displays the following message prompt Has register printed correctly Yin If you select No PSL3 asks Would you like to reprint the register Y N If you still select No you will rec
127. ect No PSL3 asks Would you like to reprint the register If you still select No you will receive a prompt notifying you the posting process is not done therefore you are still able to make any needed changes If you select Yes you will receive a secondary prompt confirming the selected Payroll transactions are now marked posted ec Information In addition if your database is setup with the Automatic A P option you will receive the following prompt Would you like A P transactions to be created automatically Y N If you select Yes the newly created A P Entry apte Reference Number will display on the screen immediately following With this new Reference Number you can still make any needed changes in A P Entry apte before posting as it is created with an unposted status In addition if you have requested to exclude any Vacation or Holiday Accrual Accounts they will not transfer over to the new A P transaction If you do not want the Automatic A P option setup you will have to manually enter in the transaction in the A P Entry screen apte 2011 Cast amp Crew Entertainment Services LLC PAYROLL 193 NOTE Please note if you need to make distribution changes to posted items this can be done in the Posted Transaction ltem Editor glfix screen located in the J E module depending on your User ID and studio permissions You can also email a request to support castandcrew com if you need a tran
128. ed is the Set Codes List Report Open gt To access the Set Code Entry suset screen click the Setup module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter O Setup Banks subank Batch Maintenance batchent Control AP suapctrl Currencies sucur Default Accounts suacct Employees pcemp Free Field1 sufree1 Free Field2 sufree2 Free Field3 sufree3 Free Field4 sufree4 Insurance suins Locations suloc Productions suprod Recurring Batch rbcre Company Code sucomp Report Group Entry surpt Series suser elfo sudkinfo t Users suuser Change Password newpass Vendor Entry apven 3 Reports Control System suctrl Line Type Entry sulntyp The screen then appears 2011 Cast amp Crew Entertainment Services LLC Fields e Production Input the Production Code associated with the Set Code e Set Input the code identifying the set which can hold up to four alpha numeric characters After entering the new Set Code PSL3 asks That Set Code is not in the database Would you like to add it Select Yes e Description Input the name of the set which can hold up to 30 alpha numeric characters Helpful Hints v Make sure to input all white colored fields as white fields are required before saving in PSL3 v T
129. ed on the criteria input on the Cost Report EFC Worksheet efcws The following screen shot is an example of the transaction Drill Down detail columns Please note not pictured is the Reference Description Currency Code and Amount columns Drill Do Ob Reference Distribution Check Invoice PO Vendor Tengg Insurance Source Distributio Number Date Number Number Number Number Code FF1 FF2 FF3 FF4 Code Code Descriptio 276 0000 00 00 4 R PR PO ardrobe 7 Close EFC Committed Drill Down on Account 1203 1 250 00 Y Also another popular feature is the Relative or Replace Variance Edit Mode PSL3 defaults to the Relative mode which adds or subtracts from the original amount shown whereas Replace overrides the existing amount You are able to switch between the two by right clicking The bottom left hand corner of the screen always display which mode you are currently in as shown below Relative edit mode ar Replace edit mode In addition the Jump to Account function located in the bottom left hand corner of the screen allows the cursor to go directly to the indicated account number typed in Jumpto Account Print Save the worksheet Located in the bottom right hand corner of the screen you can choose the following options 2011 Cast amp Crew Entertainment Services LLC ste PSL3 User Manual gt Print Opens the Print Dialogue box and sends the report directly to the printer
130. edure of reconciling the bank balance reflected on a ledger to the bank balance reflected on a bank statement for a given period to balance a bank statement Bank Reconciliation ckrbs is used to determine the actual Cash in Bank account balance on the date you perform the reconciliation Your Bank Reconciliation is balanced when the statement balance equals the checkbook balance NOTE Please note any service charges or interest earned items must be entered in through the Journal Entry jete screen You are not able to enter them through the Bank Reconciliation ckrbs screen Open gt To access the Bank Reconciliation ckrbs screen click the Checks module from the menu tree see following screen shot gt Bank Reconciliation ckrbs is also located in the Report module under the Checks sub folder gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC 256 PSL3 User Manual ii Setup a AP ja Pio Pic a JE a PR a GL 3 Checks Pre Check Report ckpcr U E amp E E F Computer Checks ckprnt Manual Checks Open Items ckman Positive Pay Export and Report pospay Void Checks ckyoid Checks Inquiry cking Check Register Summary ckolcr Check Register Detailed ckreg Check Register History ckdetcr Bank Reconciliation ckr
131. ee codes Summary By PIO Free Field 3 All third free codes O IS Free Field 4 All fourth free codes Source All currency codes Target US Dollars lAccount number p u To select criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 Account Range e Starting and Ending Account numbers to include in the report To restrict the report to only include information for a single account number input the same account in both the Starting and Ending fields To select all account numbers leave both fields blank Date Range e Starting and Ending Transaction Effective Dates to include in the report as PSL3 is date driven To restrict the report to only include information for a single date input the same date in both the Starting and Ending fields Press the F2 Key or right click in either date field for the calendar selection to appear 2011 Cast amp Crew Entertainment Services LLC PURCHASE ORDER 83 ce Pick a date lt January 2011 OEA 710 19 20 21 122 24125 26 27 28 29 OEM e a s P O Range e Starting and Ending P O Numbers to include in the report To restrict the report to only include information for a s
132. een for the specified budget The report includes budget details on the following fields Account Number Description Series Location Set Currency and Budgeted Amount At the end of the report the Grand Total of the selected budget is displayed The Budget Listing Report bdentp is helpful in reviewing all codes were entered in correctly If changes need to be made to a budget this is done in the Budget Amount Entry bdent screen Open gt To access the Budget Listing Report bdentp click the Budget module from the menu tree see following screen shot gt The Budget Listing Report bdentp is also located in the Report folder under the Budgeting Cost sub folder gt You can also access this report by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter nn 5 Setup la AP ij Pio i Pic i JE igi PR ii GL ii Checks 4 Budget EFC Entry fefcent Variance Entry bdve EEE EEE EEE E Account Variance Report bdvar Reference Variance Report bdvep ii Cost Ea Closing 3 Recurring Batch ii Report aj PSL3 Help H t amp amp The screen then appears 2011 Cast amp Crew Entertainment Services LLC Budget Information e Budget Name Name of the budget whose data you want to view and or print To select the Budget Name press the F2 Key or right click to make your selection You can also simply type in the Budget Name
133. eens Reports 2011 Cast amp Crew Entertainment Services LLC 258 PSL3 User Manual Chapter 10 1 Pre Check Printing Report The Pre Check Printing Report ckpcr lists the posted Accounts Payable transactions that will be included in the next check run The report displays the details ofthe open A P transactions including check and invoice information Open gt To access the Pre Check Printing Report ckpcr click the Checks module from the menu tree see following screen shot gt The Pre Check Printing Report ckpcr is also located in the Report module under the Checks sub folder gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter PO ay Setup i AP au Pio 5 Pic Du JE 5 PR BI GL Pre Check Report ckper Computer Checks ckprnt Manual Checks Open Items ckman Positive Pay Export and Report pospay Void Checks ckroid Checks Inquiry cking Check Register Summary ckolcr Check Register Detailed ckreg Check Register History ckdetcr Bank Reconciliation ckrbs Checks Inquiry cking 3 Budget i Cost ii Closing 3 Recurring Batch ij Report 3 PSL3 Help H amp EN 2011 Cast amp Crew Entertainment Services LLC The screen then appears Bank every bank Currency every currency Production every production Batch Number every bank eve
134. eive a prompt notifying you the voiding process is not done If you select Yes you will receive a secondary prompt confirming the voiding process is completed ee Information Yoiding completed If you selected the option to Void then Reissue PSL3 also displays the following message prompt Would you like to print the list of reissued AYP invoices YIN If you select No the Reissued A P Invoice List Report is not printed If you select Yes the Print Dialogue box opens and sends the report directly to the printer The Reissued A P Invoice List Report includes the A P invoices that were reissued Please note in A P Entry apte the Batch Number on the reissued transaction s now reflect the Check Number of the voided check s These reissued A P invoices are created with an unposted status in which you can modify before posting or delete if needed Once the void and or reissue process is complete PSL3 automatically updates the A P transaction s status as follows gt Original A P transaction s is marked with a V for Void gt Reversal A P transaction s is marked with an R for Reversal 2011 Cast amp Crew Entertainment Services LLC 25 PSL3 User Manual gt Reissued A P transaction s is marked with a U for Unposted to make any necessary modifications 2011 Cast amp Crew Entertainment Services LLC CHECKS 255 Chapter 10 4 Bank Reconciliation Bank Reconciliation is the proc
135. en has the option to approve the changes or receive another Edit file for review When the Payroll Edit file is finalized Payroll checks are cut and the Payroll Interface file is created and sent to PSL3 The Accountant is notified by an email notification that includes the Payroll inwice number This section will address the following programs gt Load Interface C amp C Payroll Invoice gt Payroll Entry gt Post P R Transactions Edit List gt Load Payroll Other Company gt Print Payroll Checks gt Payroll History Report gt Additional Payroll Screens Reports 2011 Cast amp Crew Entertainment Services LLC 176 PSL3 User Manual Chapter 8 1 Load Interface C amp C Payroll Invoice When the Payroll Edit file is finalized Payroll checks are cut and the Payroll Interface file is created and sent to the PSL3 server that houses the database The Accountant is notified by email that the Payroll Interface file is ready to load into PSL3 Upon interfacing should your Payroll Edit List encounter any errors e g illegal invalid account series location set etc this usually means that the Payroll System has codes that differ and or do not exist in PSL3 To correct this add the necessary codes in PSL3 then review the Edit List again or load the file with the errors and make the corrections in the Payroll Entry prent screen You can also contact your Payroll Coordinator to make any revisions before interfacing into PSL3
136. en or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC PETTY CASH 1 23 Post pepost Advance Report pear Entry apven vendor Listing apvenp P CARD View Report pcardlp ij JE a PR GL 3 Checks aj Budget aj Cost i Closing aj Recurring Batch 3 Report aj PSL3 Help E E E E EEE EEE The screen then appears 2011 Cast amp Crew Entertainment Services LLC 124 PSL3 User Manual SiSsivbis e 0 i a Number Batch Eff Date Production Description Company Status Bank Currency ID Number State Worked Amount Advanced Accounted for Amount Account Sers Locs Sets 9 in FFiIFF2IFF3 FF4 Description Amount 3rd Transaction reference number Enter search criteria or add data E S Reference Information Reference Number System assigned number that is also referred to as transaction number To generate the next sequential Reference Number press the F4 Key or select the Add icon located on the toolbar You can also right click outside a field in which the Add option appears to add the next record Effective Date Date of the transaction that is recorded on the Bible Report bdbr should default with today s date after generating the Reference Number You can always change it by typing over the defaulted date or by right clicking in that field for the calendar selection to appear Please note yo
137. enance batchent Control AP suapetrl Currencies sucur Default Accounts suacct Employees pcemp Free Field1 sufree1 Free Field2 sufree2 Free Field3 sufree3 Free Field4 sufree4 Insurance suins Productions Recurring B Company Code sucomp Report Group Entry surpb Series suser DataBase Info sudbinfo Sets suset States sustate Users suuser Change Password newpass Vendor Entry apven a Reports Control System suctrl Line Type Entry sulntyp The screen then appears 2011 Cast amp Crew Entertainment Services LLC Fields e Code Input the code identifying the Production which can hold up to six alpha numeric characters After entering the new Production Code PSL3 asks That Production Code is not in the database Would you like to add it Select Yes e Description Input the name of the Production which can hold up to 30 alpha numeric characters e Comp Code Input the Company Code associated with the Production Code optional Helpful Hints v Make sure to input all white colored fields as white fields are required before saving in PSL3 v To save this entry select either Save icon located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and clears the screen most common 2011 Cast amp Crew Entertainment Services LLC
138. ens However it differs in the fact that it allows you to Drill Down to see the related transaction details in addition to other new functions The Cost Report EFC Worksheet efcws screen looks almost identical to the actual Estimated Final Cost Report efcrpt screen except it includes a Reference 8 Batch section that contains white required fields In addition whichever report format type you are using in the Estimated Final Cost Report efcrpt screen the same format s is still available in this screen Please note you are able to run the Cost Report EFC Worksheet efcws with selecting multiple budgets Once an EFC Variance change has been created PSL3 automatically adjusts the Cost to Complete Estimated Final Cost and Variance amounts on the Estimated Final Cost Report efcrpt Please note EFC s and Variances are created by one of three ways which are as follows 1 By directly accessing the Variance Entry bdve screen and inputting the change s there 2 By making the change s in the EFC Entry efcent screen After making and saving the EFC change s a Variance is created with the new Variance Entry bdve Reference Number appearing directly in the EFC Entry efcent screen for your records 3 By making the change s in the Cost Report EFC Worksheet efcws screen After making and saving the EFC change s a Variance is created with the new Variance Entry bdve Reference Number appearing directly in the Cost Report EFC Work
139. er Account Number Account Number Reference Number Entry Order Series Both Invoice Date Location Account per Line Set Clear All Cancel Reson Vendor Mame I Include VendorW9 Report Exit Help Enter a batch number leave blank for all Post A P Transactions Selection Criteria e To select an entry press the F2 Key or right click in any of these fields Batch Reference Vendor Production Company Bank and or Currency to select the item s needed You can also choose multiple entries by holding down the Control Key and simultaneously using the mouse to select By making a selection this isolates the report to only display items based on the code s selected If you wish to select all unposted A P transactions leave all fields blank Report Type e Defaults to Edit List to review your A P entries and make any necessary modifications prior to posting To move forward with posting select Posting Register followed by either the Print 2011 Cast amp Crew Entertainment Services LLC ACCOUNTS PAYABLE to Preview or Spreadsheet option this will transfer the transaction s to the Bible Report bdbr Report Formats e Report Format Report Sort and Description Of are all sorting options available for you to select per your preference Include Vendor W9 Report e Check mark this option to print a separate report after the A P Edit List appost and or Posti
140. er Account Description Previous Cost To Date Actual Cost This Period Committed Total Cost To Date Cost to Complete Estimated Final Cost Budgeted and Variance Ifthe database is associated with a major studio than that studio s format type defaults instead To view the list of additional format types if any click the drop down arrow to select from the list PSL3 also provides the option of a Detail Summary or Both Report Summary Sub total Level Indicate the account number detail level to include in the Summary Report the default is 1 An example of this is if your database is setup with an account mask of XOCXX YXOCXXK it has four levels Please note this option only becomes accessible when you select either the Summary or Both type option NOTE Please note PSL3 offers many different style formats of the Estimated Final Cost Report efcrpt besides the default type PSL Standard Please email a request to support castandcrew com if you would like the format type implemented from a previous PSL3 database or would like to implement another format from another accounting software an emailed or a scanned copy of the report will suffice Include e Inactive Accounts Check mark to include accounts that had no activity distributions posted to them during the period or date range selected or have a zero dollar balance e Budgeted Amount as Activity Check mark to indicate if you want to display accounts that
141. ertainment Services LLC GENERAL LEDGER 227 ce Pick a date 2011 Cast amp Crew Entertainment Services LLC 228 PSL3 User Manual Account Selection e From and To Account numbers to include in the report To restrict the report to only include information for a single account number input the same account in both the From and To fields To multi pick certain accounts press the F2 Key or right click in either field and hold down the Control Key while simultaneously using your mouse to select To select all account numbers leave both fields blank e Account Type Single letter classification indicating the Account Type Asset Liability C apital Income Expense Selection Criteria e Press the F2 Key or right click in any of these fields Production Company Source Series Location Set Insurance Free Field s Vendor and J E Number to choose the necessary codes if they don t already default To choose multiple codes for a particular field press the F2 Key or right click in that field and hold down the Control Key while simultaneously using your mouse to select To run the report by a specific transaction type A P C K J E P C P O and or P R use the Source Code field By making a selection this isolates the report to only display items based on the code s selected Include Exclude Include Detail Check mark to include detail distribution data Include Inactive Accounts Check mark to include
142. es sustate Users suuser Change Password newpass Vendor Entry apven a Reports Control System suctrl Line Type Entry sulntyp The screen then appears 2011 Cast amp Crew Entertainment Services LLC r a sucur Currency Code Entry Im X File Edit Programs Options View Favorites Help I I lSlISIIBIFIQIABiViFiele ie idigliioilsle ie urrency Code search criteria or add data jr E 3 Currency Information e Code Input the code identifying the currency which can hold up to two alpha numeric characters After entering the new Currency Code PSL3 asks That Currency Code is not in the database Would you like to add it Select Yes e Description Input the name of the currency which can hold up to 20 alpha numeric characters e g US Dollars Mexican Pesos French Francs etc e Country Input the name of the country which uses this currency This field can hold up to 15 alpha numeric characters Rate Information e Budgeted Input the currency exchange rate used to convert the base currency to this currency If this currency is the base currency then 1 000000 defaults automatically as the Budgeted Rate This rate is used to convert amounts on reports and to convert budgeted amounts that use different currencies when copying merging budgets e Date Input the date the Budgeted exchange rate reflects as of Type in the date or press the F2 Key or right click in this field for
143. et is input Please note you are not able to access this field Overage Name of the Overage Budget selected to compare against the original budget If an Overage Budget is selected the report includes an Approved Overage and Total Budget column in addition to the original Budgeted column Period System assigned Period Number that indicates the Accounting Period in which these costs were entered Ifyou chose to run the report by Period Number then the Start Date and End Date fields default for the period chosen Start Date and End Date Transaction Effective Dates to include in the report as PSL3 is date driven Current Period Start and End Dates default You can always change the date by typing over the defaulted date or by right clicking in that field for the calendar selection to appear To restrict the report to only include information for a single date input the same date in both the Start Date and End Date fields To select all dates from inception to future leave both fields blank co Pick a date lt January 2011 ale ze orn ek al 21sla s elzle aoir 2 13 14 15 47 18 19 20 21 22 ENEA 234i 2011 Cast amp Crew Entertainment Services LLC COST 323 Format e Type Report format type determining the report columns and their order of appearance The default type for the majority of Independent Studios is the PSL Standard format which includes the following columns Account Numb
144. fer Open Items ckdef screen click the A P module then click the A P Entry sub folder from the menu tree see following screen shot gt Defer Open Items ckdef is also located in the Report module under the A P sub folder gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 3 Vendor Entry apte Edit List appost Post appost Defer Open Items ckdef Es Checks Du 1099 a Pio aj Pic sa JE a PR a GL aj Checks aj Budget ay Cost ii Closing ji Recurring Batch 5 Report ii PSL3 Help E E E E EE EEE OU AE The screen then appears 2011 Cast amp Crew Entertainment Services LLC ACCOUNTS PAYABLE 105 a ckdef Defer Open Items File Edit Programs Options View Favorites Help Oar Well er Selection Criteria Due Date Discount amoure 7 Defer indefinitely A E nter a reference number Selection Criteria e Reference Number Enter the Reference Number of the A P or P C transaction whose payment you want to defer and press the Enter Key You can also press the F2 Key or right click in the Reference Number field to select a transaction from the list The Due Date and Discount Amount fields default if you entered them in the original transaction or if you have already modified these fields in this screen Due Date Date by which the A P transaction should be pa
145. fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 e 1099 Forms or Audit Report bd1099 Use bd1099 to print paper 1099 forms generate a listing of all vendors and or employees including all amounts that have been paid to them as wells as generate a listing of vendors and or employees who have invalid Tax ID Numbers You can specify the report format as Detailed Summary Blank Tax ID Paper 1099 Form or 2011 Cast amp Crew Entertainment Services LLC ne PSL3 User Manual Spreadsheet Text Tab delimited txt and sort by Tax ID or Vendor Name You can include or exclude the following options TIN Name TIN Type State Worked 3rd Party 1099 s only Withholding Taxes only T4 only Federal Filing Limit and Non 1099 able Items in addition to Multiple Currency etc as selection criteria 1099 ICR Independent Contract Reporting Report icr1099 Use icr1099 to create an export file that includes vendors and or employees who have earned 600 or more of 1099 able amounts in the tax year or since the date the last export file was created This file should be sent to the EDD Employment Development Department To find out more about Independent Contractor Reporting or sending the file to the EDD visit the EDD web site at www edd ca gov Please note if you need to reset the ICR Export Date for any reason please em
146. g screen shot Listed are the Edit List and Post Reports You will notice once you click either report the other also becomes selected as you can view both reports from the same screen gt The Post A P Transactions Edit List appost screen is also located in the Report module under the A P sub folder gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC ACCOUNTS PAYABLE ss 3 Setup 4 AP sy Vendor AP Entry Open Items Report apopenp Defer Open Items ckdef Void Open Items apyoid2 Ea Checks En 1099 ij Pio sa PIC mj JE ig PR Bj GIL ii Checks da Budget ii Cost a Closing 3 Recurring Batch Report aj PSL3 Help BERR HER HE SF EF The screen then appears 2011 Cast amp Crew Entertainment Services LLC 100 PSL3 User Manual a appost Post A P Transactions Ema File Edit Programs Options View Favorites Help 1 BI01QI1IAI0 1 51210 HA Post AP Transactions Print Batch EEE all batches Reference ANAP reference numbers Pid bite Vendor st All vendors Spreadsheet Production AI productions Company EA All companies Bank All banks Currency All currencies Report Type Edit List ho Posting Register AAN Report Format Report Sort Description Of Account Numb
147. ge of account numbers by using the wildcard character aka asterisk For example if you want to view all 1100 accounts type 11 and press the F7 Key or select the Find icon CY located on the toolbar PSL3 displays all matching account numbers 2011 Cast amp Crew Entertainment Services LLC 212 PSL3 User Manual Please note PSL3 is compatible with almost all account masks formats e g XOX XX XX etc NOTE Please email a request to support castandcrew com if you need the account mask in your database changed New databases usually default to XXXX if none is specified on the initial database request Please be advised depending on your specific studio s guidelines the Support Department may need to obtain approval from your Studio Finance Executive before proceeding e Description Name or title of the account number which can hold up to 30 alpha numeric characters To search for an existing account by description use the the wildcard character aka asterisk For example if you want to view all accounts with the word bank type bank and press the F7 Key or select the Find icon Y located on the toolbar PSL3 displays all matching account descriptions e Type Single letter classification indicating the Account Type Press the F2 Key or right click to select the Account Type options which are displayed below ES Account type Account type Description e Line Single letter classification i
148. gh 4 If your database is not utilizing all four Free Fields and or any additional columns please leave the fields blank PSL3 automatically excludes the unused columns upon importing Sm B c D E F G J K L 1 ACCOUNT NUMBER ISERIES CODE LOCATION CODE SET CODE 1099 CODE INSURANCE FF1 FF4 DESCRIPTION AMOUNT 2 3 4 Please email a request to support castandcrew com if you would like the PSL3 Excel template emailed to you Open gt To access the Import an Excel File xlint screen click the J E module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC JOURNAL ENTRY 169 aj Setup a AP ij Pio iy Pic Sa JE Entry jete Edit jepost Post jepost ue amp H glo aj Checks aj Budget Cost Closing aj Recurring Batch 3 Report aj PSL3 Help E E E EE E Ett The screen then appears 2011 Cast amp Crew Entertainment Services LLC 170 PSL3 User Manual E xlint Import an Excel File O File Edit Programs View Favorites Help ALCOY Tew M erface File Report Type Edit List Loading Register Reference Descipton O Default Distribution Codes Vendor Number State y VOrREOo FONUmoer Invoice Number invoice Date FF Envelope
149. ginal check except that the duplicate check amount has the opposite sign of the original check amount that was voided For example if the voided check amount was 300 the reversing check amount now reflects negative 300 If the voided A P Entry apte transaction contains distribution lines that were transferred from P O Entry poent and you choose not to re issue the A P Entry apte transaction the P O lines linked to the A P that was voided will be re opened Void then Reissue Select this option to reissue the A P Entry apte transaction s that is voided upon voiding the check If you select this option the original A P Entry apte transaction is recreated with an unposted status in the Current Period which you can modify in A P Entry apte if necessary All reissued A P Entry apte transactions will have the voided Check Number default in the Batch field Ifthe voided A P Entry apte transaction contains distribution lines that have been transferred from P O Entry poent those P O distribution lines are automatically transferred to the new reissued A P Entry apte transaction WARNING Please be advised if you need to change the Vendor Name on a check that has a P O attached PSL3 does not allow you to change the Vendor Name on a reissued transaction It is recommended to simply select Void and input a new A P Entry apte transaction with the correct information Void Date e Date Date that you are voiding the ch
150. ginal recurring batch transaction remains unposted After you process a recurring batch a new unposted transaction is created in the original transaction entry screen This newly created transaction can be posted or deleted just like any other unposted transaction NOTE Please note you must manually run the Process Recurring Batches rbproc program to process recurring batches This process is not done automatically Open gt To access the Process Recurring Batches rbproc screen click the Recurring Batch module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter aj Setup zu AP a Pio 5 Pic B JE a PR a GL aj Checks 3 Budget ay Cost a Closing 3 Recurring Batch U E E E t eee amp amp amp ui PSL3 Help The screen then appears 2011 Cast amp Crew Entertainment Services LLC 34 PSL3 User Manual ie a rbproc Process Recurring Batches File Edit Programs Options View Favorites Help IPI ISISIIVPITDQIAiBiLiFiel iedPdsiis0 MO Clear All he batch number to process Entersearcherteta OO E Selection Criteria Batch Number Batch Number assigned to the recurring batch Press the F2 key or right click in this field to select the Batch Number of the transactions you want to process You can also manually type in the Ba
151. he P R module from the menu tree see following screen shot gt The Payroll History Report prhist is also located in the Report module under the Payroll sub folder gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 3 Setup a AP ii Pio i Pic ii JE Sa PR Load C amp C Invoice printr Entry prent Edit List prpost Post prpost Print Payroll Checks prekprnt Payroll Wasils Report prwasis a GL 3 Checks 3 Budget ii Cost i Closing 3 Recurring Batch 3 Report 5 PSL3 Help E E E E E E EE 2011 Cast amp Crew Entertainment Services LLC PAYROLL 201 The screen then appears From Te PIR Check Employee Numi Week Endin Production Reference 0 ompany Code Payrol Yu Free Field 1 AS first tree codes Employee Number Check Number Defauk Free Field 2 Al second free codes Employee Name 5 y Week Ending Gratis AB third free codes SN Al fourth free codes Source Currency All source currency Target Currency Dollars Starting Check Number To select criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 From and To e P R Check
152. he following reporting screens press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 e Checks Inquiry cking Use cking to display information for any check that has been printed in PSL3 This report lists all details attached to the check number including the Check Date Void Date if any Clear Date as well as the attached A P Reference Numbers etc This report can also be found in the G L module and it s main use is to provide a quick look up of details pertaining to a single check Check Register Detailed Report ckreg Use ckreg to print a detailed register of either all checks or just manual checks issued This report includes several summaries that display at the end of the report which are as follows Total Number of Checks and Total Stub Lines Grand Total for each Bank Grand Total for each Currency Currency Conversion Chart Cash in Bank and the Clearing Account details Account Numbers Descriptions and Amounts 2011 Cast amp Crew Entertainment Services LLC e Check Register History Report ckdetcr Use ckdetcr to display a summary of all checks that have printed This report provides you the option to select the status type Cleared Outstanding Computer Voided Manual an
153. he right of the decimal point on all reports except Cost Reports Enter one digit from 0 to 4 to indicate the number of digits you would like displayed after the decimal point The most common number entered is 2 e Cost Reports Number of digits to appear to the right of the decimal point on Cost Reports Enter one digit from 0 to 4 to indicate the number of digits you would like displayed after the decimal point The most common number entered is 0 to round to the nearest dollar 2011 Cast amp Crew Entertainment Services LLC Helpful Hints Y Make sure to input all white colored fields as white fields are required before saving in PSL3 v To save this entry select either Save icon located on the toolbar Y You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and clears the screen most common a Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes x exit to menu v To delete an unused Currency Code place your cursor in the specific Currency Code you want to delete and press the F10 Key or select the Delete icon fu Red strike through lines appear which are deleted upon saving v To search for an existing Currency Code press the F7 Key or select the Find icon A when the screen is clear All records appear in which you can scroll thr
154. he screen Please note the purpose of the Export to A P screen is to apply default codes to the transactions contained within a particular P Card export Each individual line item may be recoded with its one attributes once the export reaches the A P Entry apte screen as the transaction exports with an unposted status For field details in the Export to A P screen please refer to A P Entry ce Export to AP AP Defaults Description Vendor Number Insurance scription of transaction gt XLINT Export Allows you to export the selected transactions directly into an Excel Spreadsheet specifically formatted to be re imported back into PSL3 through the Import an Excel File xlint screen The data which can be coded in the Excel Spreadsheet is as follows e Account Number 2011 Cast amp Crew Entertainment Services LLC 146 PSL3 User Manual Series Code Location Code Set Code 1099 Code Insurance Code Free Field 1 4 Distribution Description Amount Envelope Number Transaction Date Card Number Merchant Name Please note these items marked with an asterisk are populated in the Excel Spreadsheet by P Card View Report pcardlp and it is recommended that they are not changed For details and step by step directions on the Import an Excel File xlint process into the Transaction Type of your choice please refer to Import an Excel File 2011 Cast amp Crew Entertainment Services LLC POL
155. he screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format gt Spreadsheet Generates an Excel format report and appears instantly on your screen You are still able to print from the Excel format Please note if you select this option you are able to have additional sorting options within Excel 2011 Cast amp Crew Entertainment Services LLC JOURNAL ENTRY 159 Once you select Posting Register followed by either the Print Preview or Spreadsheet option PSL3 displays the following message prompt ce Register printed A Has the register printed correctly If you select No PSL3 asks Would you like to reprint the register If you still select No you will receive a prompt notifying you the posting process is not done therefore you are still able to make any needed changes If you select Yes you will receive a prompt confirming the selected Journal Entry transactions are now marked posted cc Information D Journal entries posted to general ledger el NOTE Please note if you need to make distribution changes to posted items this can be done in the Posted Transaction ltem Editor glfix screen located in the J E module depending on your User ID and studio permissions
156. hey don t already default The codes selected will be associated with the budget lines once created 2011 Cast amp Crew Entertainment Services LLC 260 PSL3 User Manual Make sure to input all white colored fields as white fields are required before proceeding in PSL3 Create gt To proceed with the creating process press the F1 Key then S option or select Create located in the top right hand corner of the screen After selecting Create PSL3 provides a confirmation prompt with how many budget lines were created depending on the Budget Information input PSL3 automatically saves the budget creation 2011 Cast amp Crew Entertainment Services LLC Chapter 11 3 Delete a Budget Use the Delete a Budget bddel program to delete an entire budget or parts of an existing budget WARNING Please be advised once a budget is deleted it is gone from the database There is not an undo command You can always re enter a budget if needed Open gt To access the Delete a Budget bddel screen click the Budget module then Maintenance sub folder from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC 282 PSL3 User Manual EFC Entry efcent Variance Entry bdve Account Variance Report
157. id When you enter a Reference Number for the first time the original Due Date entered on that A P transaction record displays If you have previously changed the Due Date field in this screen that date displays instead When you change the Due Date here then the Due Date field of the A P Entry apte transaction record also updates accordingly Please note P C transactions do not have Due Dates To select the date press the F2 Key or right click in the Due Date field for the calendar selection to appear or manually type in the date ec Pick a date 2011 Cast amp Crew Entertainment Services LLC 106 PSL3 User Manual e Discount Amount Amount by which the check amount is reduced Invoice Amount Discount Amount Check Amount You can neither modify a Discount Amount unless it was originally entered in A P Entry apte nor increase a Discount Amount You can only reduce a Discount Amount from what was originally posted Please note P C records do not have Discount Amounts To input the amount press the F2 Key or right click in the Discount Amount field for the calculator option to display or manually type in the amount ce Calculator Defer Indefinitely Check mark this option if you want to defer the open item indefinitely or just defer it until the Due Date entered on this screen If check marked the selected transaction will not be included on any future check runs until you uncheck this option Defer gt
158. ields as white fields are required before proceeding in PSL3 e Account Number Inquiry Report glaa Use glaa to generate a report of distribution lines coded to a specific account number This report displays transaction details only for items that have been posted for the account number selected Please note this report is ran by only one account number at a time Asset Report assetrpt User assetrpt to generate a Detailed or Summary Report on distributions based on the date range or period and Free Field Codes Assets etc selected This report generates a reference copy of all transactions based on the criteria selected identical to the Bible Report bdbr This report can be used in conjunction with the Asset Disposition Maintenance Entry assetdis screen 2011 Cast amp Crew Entertainment Services LLC 254 PSL3 User Manual Checks Inquiry ckinq Use cking to display information for any check that has been printed This report lists all details attached to the check number including but not limited to the Check Date Void Date if any Clear Date as well as the attached A P Reference Numbers etc This report can also be found in the Checks module and it s main use is to provide a quick look up of details pertaining to a single check Chronological Bible Report bdbible Use bdbible to run a transaction log sorted by Reference Number The major difference between the Chronological Bible Report bdbible a
159. ields default for the period chosen Start Date and End Date Transaction Effective Dates to include in the worksheet as PSL3 is date driven Current Period Start and End Dates default You can always change the date by typing over the defaulted date or by right clicking in that field for the calendar selection to appear To restrict the worksheet to only include information for a single date input the same date in both the Start Date and End Date fields To select all dates from inception to future leave both fields blank co Pick a date lt January 2011 or 3 2011 Cast amp Crew Entertainment Services LLC 34 PSL3 User Manual Format Include Type Report format type determining the worksheet columns and their order of appearance The default type for the majority of Independent Studios is the PSL Standard format which includes the following columns Account Number Account Description Previous Cost To Date Actual Cost This Period Committed Total Cost To Date Cost to Complete Estimated Final Cost Budgeted and Variance If the database is associated with a major studio than that studio s format type defaults instead To view the list of additional format types if any click the drop down arrow to select from the list PSL3 also provides the option of a Detail Summary or Both worksheet Summary Sub total Level Indicate the account number detail level to include
160. in database All company codes All source codes All series codes All location codes All set codes All ins codes All first free codes All second free codes All third free codes All fourth free codes I Show Series Separation FT Show Location Separation l Show Sets Separation I Show Company Separation l Show Reference Description To select criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 Period Selection e Period System assigned Period Number that indicates the Accounting Period in which these costs were entered If you chose to run the report by Period Number then the Start Date and End Date fields default for the period chosen e Start Date and End Date Transaction Effective Dates to include in the report as PSL3 is date driven Current Period Start and End Dates default You can always change the date by typing over the defaulted date or by right clicking in either field for the calendar selection to appear To restrict the report to only include information for a single date input the same date in both the Start Date and End Date fields To select all dates from inception to future leave both fields blank 2011 Cast amp Crew Ent
161. in the Amount Advanced field It displays the account number for the P C Box Custodian set up in the Bank Entry subank screen the credit from the P C Box Custodian s account First Accounted For Amount Distribution Line This automatically created distribution line is created only if you enter an amount in the Accounted For Amount field It displays the Advance Account Number for the P C Vendor set up in the Vendor Entry apven screen 2011 Cast amp Crew Entertainment Services LLC 128 PSL3 User Manual NOTE Please email a request to support castandcrew com to turn offthe P C Entry pcent automated distribution lines function Ifthis feature is turned off you will have to input the distribution lines in manually If you prefer not to have PSL3 automatically create the distribution line s input the following fields manually Account Number Chart of Accounts number that will be debited or credited on this distribution line Press the F2 Key or right click to choose the account number Ifthe account number doesn t exist in PSL3 you can add it by pressing the F5 Key or selecting the Zoom icon e located on the toolbar This zooms into the Chart of Accounts Entry glca screen in which you can add the account number immediately Once saved press the F1 Key then F option or select the Fetch icon e to fetch the account back to the P C Entry pcent screen NOTE The Series Location Set and Fre
162. in the top right hand comer of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format gt Spreadsheet Generates an Excel format report and appears instantly on your screen You are still able to print from the Excel format Please note if you select this option you are able to have additional sorting options within Excel 2011 Cast amp Crew Entertainment Services LLC 1 PSL3 User Manual Chapter 6 4 P Card View Report Cast 8 Crew Entertainment Services in an effort to maximize efficiency with regard to a Production s purchasing needs offers its Purchasing Card P Card service Through this system in conjunction with Wells Fargo Bank a Production is able to request Purchase Cards for members of the crew which can be used anywhere major credit cards are accepted Productions are then able to reconcile these transactions in PSL3 using the P Card View Report pcardlp program Within this program you are able to view transactions by specific Card Number and date selection make coding assignments and then export into either A P Entry apte or an Excel Spreadsheet for further modification through the Import an Excel File xlint screen NOTE Please note not all databases are setup with the
163. ingle P O Number input the same P O Number in both the Starting and Ending fields To select all P O Numbers leave both fields blank e P O Status Status of the P O Select whether you want the report to include P O s that are Relieved Open or Both e P O Type User defined code to track your company s different classifications of P O s Input the P O Type to run the report by if any If a P O Type is input here then the report only displays P O transactions for that P O Type Selection Criteria e Press the F2 Key or right click in any of these fields Batch Number Production Vendor Number Series Location Set and Free Field s to choose the necessary codes if they don t already default To choose multiple codes for a particular field press the F2 Key or right click in that field and hold down the Control Key while simultaneously using your mouse to select By making a selection this isolates the report to only display items based on the code s selected 2011 Cast amp Crew Entertainment Services LLC ss PSL3 User Manual Multiple Currency e Source If you have more than one currency in your database you can choose to include only transactions denominated in one currency two three etc or all currencies To choose multiple Currency Codes press the F2 Key or right click in the field and hold down the Control Key while simultaneously using your mouse to select Each currency in your database and its conversio
164. ion J E Number User defined code or number also known as the User Source Code to track your company s different classifications of Journal Entries This field can hold up to six alpha numeric characters Total Debits Total amount of the debit entries calculated in the distribution lines Please note you are not able to access this field Total Credits Total amount of the credit entries calculated in the distribution lines Please note you are not able to access this field Please note when entering a new Journal Entry PSL3 tallies the debit and credit entries you make in the distribution lines Entering a positive amount in the distribution line Amount field increases total debits Entering a negative amount input a minus sign before the number in the distribution line Amount field increases the total credits Please be advised debits and credits must equal before you can save the transaction Distribution Lines PSL3 automatically creates the debit and or credit offset distribution line s once you input the account number on the second distribution line e Account Number Chart of Accounts number that will be debited or credited on this distribution line Press the F2 Key or right click to choose the account number If the account number doesn t exist in PSL3 you can add it by pressing the F5 Key or selecting the Zoom icon e located on the toolbar This zooms into the Chart of Accounts Entry glca screen in which you can
165. ion activity by vendor You can choose the Report Type Vendor ID Vendor Name State or Invoice and include the Transaction Type Unposted Open Paid and or Void You can also enter a range of Vendor ID Numbers Start and End Dates Multiple Currency etc as selection criteria A P Vendor Inquiry apving Use apving to look up information on posted A P transactions You can specify the Invoice Selection by Vendor Reference Number Inwice Number P O Number and or Location Code You can also choose the Currency Transaction Type Open and or Paid Items Start and End Dates etc as selection criteria Vendor Employee Labels labels Use labels to print vendor and or employee mailing labels The labels can be sorted by ID Number Name or Zip Code PSL3 prints two or three column labels and is compatible with Avery 5161 for two columns or Avery 5160 for three columns Please note you can multi pick vendors employees instead of printing an entire range by pressing the F2 Key or right clicking in the Starting and Ending fields and holding down the Control Key while simultaneously using your mouse to select NOTE The reports are available in either Print Preview and or Spreadsheet formats NOTE Please email support castandcrew com if you don t see a specific PSL3 report currently listed as an option in your database 2011 Cast amp Crew Entertainment Services LLC POL PURCHASE ORDER Secti PURCHASE O
166. ion and or Set Code you are not able to access the Detail field Accounts e From and To Account numbers to include in the report To restrict the report to only include information for a single account number input the same account in both the From and To fields To multi pick certain accounts press the F2 Key or right click in either field and hold down the Control Key while simultaneously using your mouse to select To select all account numbers leave both fields blank e Additional Report for all Expenses Check mark this option to generate a second report that includes all Expense Accounts Please note this option only becomes accessible when an account number is input in either the From and or To Account fields Printing e Shading Check mark this option to shade every other line on the report this allows the report to be easily read Multi Currency e Source If you have more than one currency in your database you can choose to include only transactions denominated in one currency two three etc or all currencies To choose multiple Currency Codes press the F2 Key or right click in the field and hold down the Control Key while simultaneously using your mouse to select Each currency in your database and its conversion rate are listed in the report heading 2011 Cast amp Crew Entertainment Services LLC COST 325 e Target Base currency set up in the System Control Information Entry suctrl screen locate
167. is broken down by account number then Set Code if Series and or Location Separation is not check marked first e Company Separation Check mark if you want transactions for each Company Code displayed separately If selected the report is broken down by account number then Company Code if Series Location and or Set Separation is not check marked first e Reference Description Check mark to include the Reference Description in addition to the Distribution Description of each transaction If selected the report usually defaults to Landscape layout due to the additional column Multiple Currency e Source Currency If you have more than one currency in your database you can choose to include only transactions denominated in one currency two three etc or all currencies To choose multiple Currency Codes press the F2 Key or right click in the field and hold down the Control Key while simultaneously using your mouse to select Each currency in your database and its conversion rate are listed in the report heading Target Currency Base currency set up in the System Control Information Entry suctri screen located in the Setup module defaults This Currency Code is what all transactions are converted to on the report Each currency in your database and its conversion rate are listed in the report heading Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to gene
168. is the orderly summary of ledger accounts used specifically to extract financial statement information The Trial Balance Report gltb generates a listing of each postable account displaying its Beginning Balance Debits Credits Net Change and Ending Balance based on the period or date range input You can generate a Detail Summary or customized report per your preference Open gt To access the Trial Balance Report gltb click on Tab 9 or press ALT and the number 9 Key simultaneously to open the screen gt The Trial Balance Report gltb is also accessible if you click the G L module from the menu tree see following screen shot as well as the Report folder under the General Ledger and Weekly sub folders gt You can also access this report by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter Setup a AP a Pio a Pic sa JE a PR GL Chart of Accounts Entry glca Chart of Accounts List gleap U H E t t AE Report Group Entry surpi Trial Balance glth Ledger Bible Report ledbib Asset Report assetrpt Recurring Batch Process rbproc a Inquiry ii Checks aj Budget Cost 3 Closing Bj Recurring Batch a Report a PSL3 Help HH t E 2011 Cast amp Crew Entertainment Services LLC GENERAL LEDGER 2 The screen then appears 2 TRIAL BALANCE File Edit Programs Options View Favorites Help
169. it Programs Options View Favorites Help ISIS SOISIIBIFRAGIAIBICiBlSi ie idgiGiiHisle Vendor Information Vendorp aa Name SMITHWOHN Address 1123 MAPLE STREET City LOS ANGELES State Zip CA 90001 Country USA Contact Phone Fax Email Tax ID Information TxD Tin Type 1099 type rTerms Terms Other Information Comment Studio Vendor T F PetlyCash F Inactive rDefaults Currency Code Default Account PIC Advance Account TIN Name State worked ICR 1099 Information GEN First Name mo O Last Name Help gt Vendor 1 of 1 aca 0 moa 0 Oo of Vendor Information e Vendor ID Identification code for a vendor or for an employee who will receive Petty Cash Advances which can hold up to six characters depending on your studio Press the F4 Key or select the Add icon E3 located on the toolbar to generate the next numerical Vendor ID Number You can also manually enter a unique Vendor ID with a combination of alpha numeric characters to represent the new vendor Then press the Enter Key PSL3 asks That Vendor is not in the database Would you like to add it Select Yes If you manually enter a Vendor ID Number of less than six characters PSL3 automatically zero pads the number For example if you enter 13 as the Vendor ID Number PSL3 adds zeroes in front of the number as follows 00
170. it straight from your screen If you need to make any corrections do so in the P R Entry prent screen After accepting the changes generate another Edit List to verify the corrections Once you re satisfied with the changes move forward with the Posting Register Posting is the act of permanently transferring a transaction to the Bible Report General Ledger bdbr NOTE Please email a request to support castandcrew com prior to posting if you would like your database setup with the Automatic A P option when posting Payroll transactions Please provide the Vendor ID Number as well as any Vacation or Holiday Accrual Accounts that you want excluded on the newly created A P transaction You will receive the Automatic A P prompt upon posting in the Post P R Transactions prpost screen If you prefer not to have this option setup you will have to manually enter in the A P transaction in the A P Entry screen apte Open gt To access the Post P R Transactions Edit List prpost screen click the P R module from the menu tree Listed are the Edit List and Post Reports You will notice once you click either report the other also becomes selected as you can view both reports from the same screen gt The Post P R Transactions Edit List prpost screen is also located in the Report module under the Payroll sub folder gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located a
171. k Code defaults Please note you can not access this field Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to generate the report gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format gt Start Opens the Print Dialogue box sends the report directly to the printer and begins the modification process 2011 Cast amp Crew Entertainment Services LLC ACCOUNTS PAYABLE 1 1 1 Once you select Start and the report has printed PSL3 displays the following message prompt ce Register printed Has the register printed correctly If you select No PSL3 asks Would you like to reprint the register If you still select No the modification process is not done If you select Yes PSL3 then displays a secondary prompt za APOPMOD gt The report is printed Do you wish to modify Modify selected AP reference If you select Yes the selected A P transactions are now modified to the new Bank Code If you select No the modification process is not done 2011 Cast amp Crew Entertainment Services LLC 112 PSL3 User Manual Chapter 5 5 Void Open Items The Void Open Items apvoid2 program is used to wid an A P Open Item s and or reissue the original A P transaction s if needed The Voided Open Items Register prints the voided change s for your records
172. key or right click in this field to select the Batch Number You can also manually type in the Batch Number This field can hold up to six alpha numeric characters Description Description of the Batch Number selected which can hold up to 30 alpha numeric characters Enter the description if it doesn t already default once selecting the recurring Batch Number Number of times to recur Total Number of times you want the transaction s to recur which can be a number up to five characters long This number is automatically reduced by 1 each time you run this batch in the Create Establish Recurring Batches rbcre screen Frequency e Select the schedule on which the recurring batch is run The options are as follows Daily Weekly Monthly and Quarterly Start gt To proceed with the create establish recurring batch process press the F1 Key then S option or select Start located in the top right hand corner of the screen Once successfully created you will receive the Recurring batch created message 2011 Cast amp Crew Entertainment Services LLC 342 PSL3 User Manual cc Information Recurring batch created 2011 Cast amp Crew Entertainment Services LLC RECURRING BATCH 343 Chapter 14 2 Process Recurring Batches The Process Recurring Batches rbproc screen processes the transactions that were set up as a recurring batch in the Create Establish Recurring Batches rbcre screen The ori
173. l Zoom normal Field fal Ma Whole page Field aaa Page width Field E E Print Field Function Keys Description Opens a new program from within the current program Used with Fetch For example with your cursor in the Vendor ID field of the AIP Transaction Entry program click the Zoom icon to open the Vendor Entry program without leaving the A P screen Populate the field from which you zoomed with data from the zoomed to program To continue the Zoom example click the Fetch icon to fetch a Vendor ID back to the Vendor ID field in the A P Transaction Entry program Opens the Cast amp Crew online help pages Clear the screen Cancel the entry Preview the report Save and preview your report as an Adobe Acrobat PDF file Zoom in magnify the report preview Zoom out shrink the report preview Zoom to preview the report at 100 actual size Size the preview to view the whole page Size the preview to the page width Open the Print dialog screen Function keys provides shortcuts to commands additional information and inputting finding saving or changing entries The results of pressing a function key depend on the location of the cursor 2011 Cast amp Crew Entertainment Services LLC 20 PSL3 User Manual alla lg f a IE a Back Duplicate BE F Mark for i Fi Jump F2 Remark aL Field Field Field Field in section or in Field in distribution Field Program screen or
174. l a request to support castandcrew com if you need a transaction s Effective Date changed and include the Reference Number s Please be advised depending on your specific studio s guidelines the Support Department may need to obtain approval from your Studio Finance Executive before proceeding Description Explanation of this A P transaction as a whole which can hold up to 30 alpha numeric characters This Reference Description defaults in the distribution lines If this field is left blank PSL3 defaults the distribution description with the description of the first account number selected Status Overall status of the transaction This field is marked with a U for an Unposted entry until you post it in the Post A P Transactions appost screen As long as the transaction is marked with an unposted status you are able to modify it Once posted it is marked with an O for Open or P for Paid once a check has been processed PSL3 updates the status automatically 2011 Cast amp Crew Entertainment Services LLC ACCOUNTS PAYABLE os NOTE Please email a request to support castandcrew com if you need a transaction unposted and include the Reference Number s Please be advised depending on your specific studio s guidelines the Support Department may need to obtain approval from your Studio Finance Executive before proceeding Batch Information e Codes that are attached to the transaction These fields
175. l currencies To choose multiple Currency Codes press the F2 Key or right click in the field and hold down the Control Key while simultaneously using your mouse to select Each currency in your database and its conversion rate are listed in the report heading Target Currency Base currency set up in the System Control Information Entry suctri screen located in the Setup module defaults This Currency Code is what all transactions are converted to on the report Each currency in your database and its conversion rate are listed in the report heading Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format gt Spreadsheet Generates an Excel format report and appears instantly on your screen You are still able to print from the Excel format Please note if you select this option you are able to have additional sorting options within Excel 2011 Cast amp Crew Entertainment Services LLC VENDORS e Chapter 3 3 Additional Vendor Screens Reports PSL3 offers additional Vendor Screen Reports which are listed below Some of these reports can also be found in the section Additional A P_Screens Reports Open gt To access
176. le and check for any errors e g illegal invalid account series location set etc prior to loading If you have encountered any errors they are listed on the Edit List and this usually means that the Payroll System has codes that differ and or do not exist in PSL3 To correct this add the necessary codes in PSL3 then review the Edit List again or load the file with the errors and make the corrections in the Payroll Entry prent screen You can also contact your Payroll Coordinator to make any revisions before interfacing into PSL3 To move forward with loading select Loading Register followed by either the Print or Preview option Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format 2011 Cast amp Crew Entertainment Services LLC PAYROLL Once you select Loading Register followed by either the Print or Preview option PSL3 displays the following message prompt If you select No PSL3 asks Would you like to reprint the register If you still select No the loading process is not done If you select Yes you will receive a secondary prompt confirming the selected Payroll invoice is now loaded in which PSL3 will p
177. lears the screen most common a Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes x exit to menu v To add another distribution line press Enter or Tab where the last line was entered v To insert a distribution line in between already existing lines place your cursor where you want to add and press the F4 Key or select the Add icon B A new line is added beneath v To delete a distribution line place your cursor in the line you want to delete and press the F10 Key or select the Delete icon TI A red strike through line appears which is deleted upon saving v To search for an existing entry press the F7 Key or select the Find icon Q when the screen is clear All records appear in which you can scroll through using the Arrow icons First Prior Next and Last g l l l O or by pressing the Page Up or Page Down Keys until you find the entry needed 2011 Cast amp Crew Entertainment Services LLC 156 PSL3 User Manual Chapter 7 2 Post J E Transactions Edit List Use the Post J E Transactions Edit List jepost screen to review and post Journal Entry transactions You can post transactions one at a time or all transactions at the same time if you prefer It is recommended to first generate an Edit List a list of the transactions you ve selected prior to posting The purpose of the Edit List is for you to review the Journal tra
178. lease email a request to support castandcrew com ifyou do not see this program listed as an option in your database and would like it made available Open gt To access the Load Payroll Other Company pr2psl screen click the P R module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC PAYROLL 1 O M mu Pio Entry prent Edit List prpost Post prpost History Report prhist Accrued Holiday Report acvhrpt Invoice Report prinvp Print Payroll Checks prekprnt Payroll Wasils Report prwasis ij GL 3 Checks a Budget ii Cost 3 Closing 3 Recurring Batch B Report 3 PSL3 Help ee amp amp amp amp amp The screen then appears 2011 Cast amp Crew Entertainment Services LLC 196 PSL3 User Manual z x Invoice Clearing account Batch Production Bank Currency FFI Insurance Invoice number to be interfaced Invoice File Information Prior to the import process first save the Payroll Data file sent to you via email to your computer The file should already be in fil format e Invoice Number Input the Payroll Invoice Number that you received via email e Select File Choose the fil file you wish to load Please note that files are loa
179. lect criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank From and To Effective Date Transaction Effective Dates to include in the report as PSL3 is date driven To restrict the report to only include information for a single date input the same Effective Date in both the From and To fields To select all dates from inception to future leave both fields blank Press the F2 Key or right click in either date field for the calendar selection to appear 2011 Cast amp Crew Entertainment Services LLC JOURNAL ENTRY 167 ce Pick a date e Account Number Account numbers to include in the report To restrict the report to only include information for a single account number input the same account in both the From and To fields To select all account numbers leave both fields blank e Reference Number Reference Numbers to include in the report To restrict the report to only include information for a single Reference Number input the same account in both the From and To fields To select all Reference Numbers leave both fields blank Selection Criteria e Press the F2 Key or right click in any of these fields User Company Source Production Series Location Set 1099 Insurance Free Field s J E Number Currency 3rd Party to choose the neces
180. line should default with the remaining invoice amount when you input an account number Please note if you press the F2 Key or right click in the Amount field a calculator displays for your convenience 2011 Cast amp Crew Entertainment Services LLC PSL3 User Manual ce Calculator Helpful Hints v Make sure to input all white colored fields as white fields are required before saving in PSL3 v To save this entry select either Save icon located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and clears the screen most common ec Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes x exit to menu v To add another distribution line press Enter or Tab where the last line was entered v To insert a distribution line in between already existing lines place your cursor where you want to add and press the F4 Key or select the Add icon BI A new line is added beneath v To delete a distribution line place your cursor in the line you want to delete and press the F10 Key or select the Delete icon TI A red strike through line appears which is deleted upon saving v To search for an existing entry press the F7 Key or select the Find icon CY when the screen is clear All records appear in which you can scroll through
181. lso access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC 262 PSL3 User Manual The screen then appears U E E EEEE E E amp amp amp 3 Setup a AP a Pio sa PIC sa JE aj PR aj GL 4 Checks Pre Check Report ckper Computer Checks ckprnt Manual Checks Open Items ckman Positive Pay Export and Report pospay Yoid Checks ckvoid Checks Inquiry cking Check Register Summary ckolcr Check Register Detailed ckreg Check Register History ckdeter Bank Reconciliation ckrbs Checks Inquiry cking ii Budget aj Cost aj Closing ji Recurring Batch 3 Report 3 PSL3 Help 2011 Cast amp Crew Entertainment Services LLC ec pospay Positive Pay Export and Report File Edit Programs Options View Favorites Help IBI Q lQIPGIiBIBle Selection Criteria Print Edit Bank Production Pospay Format Send Export ut Of wate Preview Edit Type All Exportable Checks T Final Transmit Payments Only Voids Only Clear All End Date Bank nter a bank code Selection Criteria e Bank Name of the bank in which the check file will be transmitted to Press the F2 Key or right click to select the Bank Code e Production Name of the Production should default if there is only one Production Code setup in the database e Pospay Format
182. luding Production Cost capability Multiple Production capability Multiple Company capability Special Episodic Television formats Payroll Interface Onsite Payroll Check Printing Extensive secure web access Multi user worldwide capabilities Multi tasking capability Optional database hosting Customizable reports Report previewing Twenty four hour support seven days a week 24 7 Audience This manual is for anyone using PSL3 to manage Production Payroll and costs It introduces new users to the fundamentals of PSL3 This document assumes that you have online access to PSL3 and are familiar with the Windows platform Internet Explorer web browser as well as Production Accounting Training Whether you re starting a new job and will be using PSL3 or simply want to bolster your skill set for your resume Cast amp Crew offers hands on tutorials in our Burbank office or visually enhanced on line remote sessions to allow you to see what your instructor is seeing from the comfort of your own office anywhere in the world Training sessions are usually held on a weekly basis but it is best to call in advance to schedule Please note there is no cost to attend a PSL3 Training session NOTE Please email support castandcrew com or contact the Support Department at 818 848 0999 to set up a free PSL3 Training Session Please provide your full name studio and film show you are working on if an
183. ment Services LLC 136 PSL3 User Manual Chapter 6 3 P C Crew Advances Activity Report The P C Crew Advances Activity Report pcar displays posted Petty Cash transaction amounts broken down by Amounts Advanced Accounted for Amounts receipts and the amount of the Advance Outstanding the difference between the Amounts Advanced and the Accounted for Amounts Open gt To access the P C Crew Advances Activity Report pcar click the P C module from the menu tree see following screen shot gt The P C Crew Advances Activity Report pcar is also located in the Report folder under the Petty Cash sub folder titled P C Activity Report pcar gt You can also access this report by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 3 Setup Zi AP a Pio Sa Pic a Vendor Entry pcent Edit pcpost Post pcpost it amp amp Advance Report pear Entry apven Vendor Listing apvenp P CARD View Report pcardip sa JE a PR i GL ii Checks 3 Budget ii Cost 3 Closing 5j Recurring Batch 3 Report ii PSL3 Help E E E E EEE E EI amp The screen then appears 2011 Cast amp Crew Entertainment Services LLC PETTY CASH E a Starting Ending Production All productions Starting Company Ending Bank All banks Currency All currencies Number Starting first account Ending last account Wr Show detail F Include PI
184. ment Services LLC 302 PSL3 User Manual WARNING Please be advised if you are adding a new account number to a budget it must be added in both Chart of Accounts Entry glca and Budget Amount Entry bdent for it to appear in EFC Entry efcent If you have added the account number only in Chart of Accounts Entry glca it will nof appear in this screen when check marking Include Inactive Accounts e Budget Amount as Activity Check mark to include accounts that had no distributions posted to them but do have a non zero amount budgeted e Open Items as Actuals Check mark to include Open Items items posted but not yet paid Only P O s will be treated as Commitments e Over Budget as Negative Check mark to show over budget amounts as negative numbers Multiple Currency e Source If you have more than one currency in your database you can choose to include only transactions denominated in one currency two three etc or all currencies To choose multiple Currency Codes press the F2 Key or right click in the field and hold down the Control Key while simultaneously using your mouse to select e Target Base currency set up in the System Control Information Entry suctrl screen located in the Setup module defaults This Currency Code is what all transactions are converted to on the worksheet Start to populate data gt To proceed with making the EFC changes press the F1 Key then S option
185. n These fields are pulled from the User Entry suuser screen located in the Setup module if setup beforehand To change the defaulted codes press the F2 Key or right click in any of these fields Batch Production Company Bank and Currency and make your selection Please note the Bank Code field setup in the Bank Entry subank screen is where the P C Box Custodian Account is pulled from To set up a new P C Custodian do so in the Bank Entry subank screen located in the Setup module Vendor Information Only vendors with Advanced Accounts setup in Vendor Entry apven are displayed in the vendor pick list in P C Entry pcent This is done by check marking the Petty Cash option in which the P C Advance Account field becomes accessible in Vendor Entry apven e Select the vendor needed by pressing the F2 Key or by right clicking in the Vendor ID field Once the list of vendors appears you can scroll through to find the vendor or click on the column headers Name City or Vendor to sort alphabetically or numerically If the vendor does not exist in PSL3 you can add it by pressing the F5 Key or selecting the Zoom icon located on the toolbar This zooms into the Vendor Entry apven screen To search for a vendor while zoomed into the Vendor Entry apven screen type the wildcard character using the asterisk in the Vendor Name field For example if you want to see if vendor John Smith exists you would type John or Smith a
186. n Tab 4 or press ALT and the number 4 Key simultaneously to open the screen gt Computer Checks ckprnt can also be accessed in the Checks and A P modules from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC 242 PSL3 User Manual Setup a AP a Pio a Pic sa JE a PR a GL a Checks Pre Check Report ckper U E amp E Fe Computer Checks ck Upen Items ckman Positive Pay Export and Report pospay Void Checks ckvoid Checks Inquiry cking Check Register Summary ckolcr Check Register Detailed ckreg Check Register History ckdetcr Bank Reconciliation ckrbs Checks Inquiry cking ii Budget ii Cost 3 Closing Ea Recurring Batch day Report aj PSL3 Help E E E E The screen then appears 2011 Cast amp Crew Entertainment Services LLC Company Enter a company code Bank Enter a bank code Currency Currency Code defaults bas Starting Check Check Date 11 F Allow ZERO Checks to Print Select AP by Due Date Vendor every vendor Invoice Batch every batch Reference every reference Production every production Enter a company code To select criteria press the F2 Key or right click in most fields to make your selection You can also simply t
187. n change the Batch Number here if desired by simply typing over the batch If the Batch Number does not exist PSL3 asks Batch does not exist Create it Select Yes Otherwise select the OK option to process the recurring batch PSL3 then displays the confirmation prompt Recurring batch processed ee Information Recurring batch processed The transaction s is now available in the transaction entry screen in which the recurring batch was originally created The new transaction s is also created with an unposted status in which you can still modify before posting 2011 Cast amp Crew Entertainment Services LLC 346 PSL3 User Manual Chapter 14 3 List of Batches Report The List of Batches Report rblist generates a listing a list of all batches used and not used in your database Recurring batches are identified on the report by the letter Y in the Recurring column along with the Frequency and Time Count if any Open gt To access the List of Batches Report rblist click the Recurring Batch module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 5j Setup a AP 5 Pio Pic a JE a PR a GL ii Checks B Budget aj Cost ii Closing 3 Recurring Batch cre wee EE EA EA A aj PSL3 Help The screen then appears 2011 Cast amp C
188. n items as actuals K a5 1 y t Lo b EF Bud j ian Account L t t al tt 4 udget ance De oor Enter a Dud De Enter search cntena a Budget Information e Budget Name of the budget in which the EFC changes will be made To choose multiple budgets press the F2 Key or right click in this field and hold down the Control Key while simultaneously using your mouse to select e Production Production Code for the Budget Name The Production Code defaults when the budget is input Please note you are not able to access this field Reference Batch e Press the F2 Key or right click in these fields Batch and Company to choose the necessary codes if they don t already default The codes selected will be associated with the Variance Entry bdveltransaction once created To run EFC Entry efcent from a previous Variance transaction created use the Variance Reference field to input the Reference Number Date Selection Effective Date Date of the transaction that is recorded and affects the Estimated Final Cost Report efcrpt should default with today s date You can always change the Effective Date by typing over the defaulted date or by right clicking in that field for the calendar selection to appear Please note you can nof input a date that is in a previously closed 2011 Cast amp Crew Entertainment Services LLC period ec Pick a date 2 3 4 5 6 71 6 ro 11 12 13 14 15 7 18 19 20 21 22
189. n rate are listed in the report heading Target Base currency set up in the System Control Information Entry suctrl screen located in the Setup module defaults This Currency Code is what all transactions are converted to on the report Each currency in your database and its conversion rate are listed in the report heading Report Types e The Report Types By Account Number By Free Field etc are all sorting options available for you to select per your preference Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format gt Spreadsheet Generates an Excel format report and appears instantly on your screen You are still able to print from the Excel format Please note if you select this option you are able to have additional sorting options within Excel 2011 Cast amp Crew Entertainment Services LLC PURCHASE ORDER 85 Chapter 4 3 Additional P O Screens Reports PSL3 offers additional P O Screens Reports which are listed below Open gt To access the following P O Screens Reports click the P O module from the menu tree see following screen shot gt These additional P O Screens Reports are also lo
190. nce To last expense FF1 FF2 FF3 FF4 Source All source currency Target US Dollars Enter the budget code for this report To select criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 2011 Cast amp Crew Entertainment Services LLC COST 313 Budget Information Budget Name of the budget in which the EFC changes will be made For each account number the Estimated Final Cost will be compared to the Budget Amount to determine the Variance To choose multiple budgets press the F2 Key or right click in this field and hold down the Control Key while simultaneously using your mouse to select Production Production Code for the Budget Name The Production Code defaults when the budget is input Please note you are not able to access this field Overage Name of the Overage Budget selected to compare against the original budget If an Overage Budget is selected the report includes an Approved Overage and Total Budget column in addition to the original Budgeted column Period Period System assigned Period Number that indicates the Accounting Period in which these costs were entered If you chose to run the worksheet by Period Number then the Start Date and End Date f
191. nd press the F7 Key or select the Find icon Q located on the toolbar PSL3 displays how many records for that criteria exist by selecting the Arrow icons First Prior Next and Last g l l l O located on the toolbar or by pressing the Page Up or Page Down Keys until you find the vendor needed Once you locate the vendor press the F1 Key then F option or select the select the Fetch icon e to fetch this record back to the P C Entry pcent screen Envelope Information e Envelope Number User defined code or number identifying each P C envelope which can hold up to eight alpha numeric characters The concept of an envelope is that each P C transaction can involve not only disbursing cash but also receiving receipts and cash from vendors The receipts would be kept in an envelope for future reference and the transactions would be listed on the front of the envelope 2011 Cast amp Crew Entertainment Services LLC PETTY CASH NOTE Please email a request to support castandcrew com to make the Envelope Number a white colored field as white fields are required before proceeding in PSL3 e Amount Advanced Dollar or other currency amount that is being given advanced to the P C Vendor After inputting the Amount Advanced PSL3 automatically creates two distribution lines The first automated line displays the Advance Account Number for the P C Vendor set up in the Vendor Entry apven screen debiting
192. nd the Bible Report bdbr is that the Chronological Bible Report bdbible is organized by Reference Number as opposed to Account Number Inquiry by Reference Number Report glrinq Use glring to display information for a specific Reference Number This report is helpful for determining the Source Code P O A P etc of a transaction It s also useful for viewing several transactions from different programs without having to open a new screen Please note this report is ran by only one Reference Number at a time Ledger Bible Report ledbib Use ledbib to print a detailed ledger of transaction data but with the added search criteria of an Amount Range and Reference and or Distribution Description s Active Accounts Beginning Balance Debits Credits and Ending Balance are included in the report Accounts with no activity during the date range are not included NOTE The reports are available in either Print Preview and or Spreadsheet formats NOTE Please email support castandcrew com if you don t see a specific PSL3 report currently listed as an option in your database 2011 Cast amp Crew Entertainment Services LLC CHECKS Section 10 CHECKS This section will address the following programs gt Pre Check Printing Report gt Computer Checks and Check Register Summary Report gt Void and Reissue Checks gt Bank Reconciliation gt Positive Pay Export and Report gt Additional Check Scr
193. nd the programs Program screens include the following areas Title bar Program menu bar Toolbar Working area Hint bar Activity bar for screens where you work with entries The exact layout of the program screens depends in part on the type of accounting procedures it supports Setup record entry Transaction entry Reporting Posting Inquiry Screens that support the same type of procedures have similar layouts For example record entry and transaction entry require similar steps and thus the setup entry and transaction entry screens are similar The other factor affecting the layout is the type of data the screen displays for example bank data versus vendor data Once you re finished working in a program screen you use a command screen to finalize your task Program Menu Bar The program menu bar displays the names of the menus for working with program screens File Edit Programs Options View Favorites Help Click on the name to open the menu If there is a keyboard shortcut for the menu item it is displayed to the right of the item Menu items with an arrow to the right open to a sub menu when you mouse over them 2011 Cast amp Crew Entertainment Services LLC HOW TO USE THIS MANUAL Keyboard shortcuts Add F4 Find F7 Exit Pick F2 Help F6 Programs Arrows indicate submenus Vendor A P Entry Checks Entry Edit List l Post The f
194. ndicating the Line Type Only Expense Accounts have a Line Type Press the F2 Key or right click to select the Line Type options which are displayed below 2011 Cast amp Crew Entertainment Services LLC GENERAL LEDGER ce Codes A ABOVE THE LINE BELOW THE LINE BELOW THE LINE POST PRODUCTION BELOW THE LINE OTHER CHARGES CONTINGENCIES COMPLETION COSTS COST RECOVERY TRANSFERS q il laa a e Post Check mark this option if the account can have amounts posted to it If this field is left unchecked PSL3 does not allow you to post transactions to the account number e Sub Check mark this option if the account is a Sub account and not a Header or Standalone Account Helpful Hints Y Make sure to input all white colored fields as white fields are required before saving in PSL3 v To save this entry select either Save icon located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and clears the screen most common ce Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes X eXit to menu v To add another account number press Enter or Tab where the last line was entered v To insert an account number in chronological order between already existing account numbers place your cursor where you want to add and press
195. ned Period Number that indicates the Accounting Period in which these costs were entered If you chose to run the report by Period Number then the Start Date and End Date fields default for the period chosen Start Date and End Date Transaction Effective Dates to include in the report as PSL3 is date driven Current Period Start and End Dates default You can always change the date by typing over the defaulted date or by right clicking in either field for the calendar selection to appear To restrict the report to only include information for a single date input the same date in both the Start Date and End Date fields To select all dates from inception to future leave both fields blank cc Pick a date E 2011 Cast amp Crew Entertainment Services LLC GENERAL LEDGER 221 Account Selection e From and To Account numbers to include in the report To restrict the report to only include information for a single account number input the same account in both the From and To fields To select all account numbers leave both fields blank Selection Criteria Press the F2 Key or right click in any of these fields Production Company Series Location Set Insurance Free Field s Source Code and J E Number to choose the necessary codes ifthey don t already default To choose multiple codes for a particular field press the F2 Key or right click in that field and hold down the Control Key while simultaneou
196. neously using your mouse to select By making a selection this isolates the worksheet to only display items based on the code s selected To display an additional detail column on the worksheet for either the Company Series Location and or Set Code leave these fields blank and check mark the Detail option PSL3 will print a separate line for each account number and code combination selection Please note if you enter in a Company Series Location and or Set Code you are not able to access the Detail field Accounts e From and To Account numbers to include in the worksheet To restrict the worksheet to only include information for a single account number input the same account in both the From and To fields To multi pick certain accounts press the F2 Key or right click in either field and hold down the Control Key while simultaneously using your mouse to select To select all account numbers leave both fields blank Multi Currency e Source If you have more than one currency in your database you can choose to include only transactions denominated in one currency two three etc or all currencies To choose multiple Currency Codes press the F2 Key or right click in the field and hold down the Control Key while simultaneously using your mouse to select e Target Base currency set up in the System Control Information Entry suctrl screen located in the Setup module defaults This Currency Code is what all transactions are
197. ng The purpose of the Edit List is for you to review the P C transactions for any errors as well as to make sure the transactions listed are indeed the ones you want to post You can print the Edit List or view it straight from your screen If you need to make any corrections do so in the P C Entry pcent screen After accepting the changes generate another Edit List to verify the corrections Once you re satisfied with the changes move forward with the Posting Register Posting is the act of permanently transferring a transaction to the Bible Report General Ledger bdbr Open gt To access the Post P C Transactions Edit List pcpost screen click the P C module from the menu tree see following screen shot Listed are the Edit List and Post Reports You will notice once you click either report the other becomes selected as you can view both reports from the same screen gt The Post P C Transactions Edit List pcpost screen is also located in the Report module under the Petty Cash sub folder gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC 132 PSL3 User Manual i Setup a AP ij Pio a Pic a Vendor i EEE Advance Report pean Entry apven Vendor Listing apyenp P CARD View Report pcardip sa JE lj PR i GL ij Checks da Budget day Cost Ea Cl
198. ng Qu MI 0 00 1 500 00 0 00 1 500 00 1 500 00 9211 P Incardora Coatune Super 0 00 5 278 91 13 778 91 1 500 00 1 500 00 9212 D Rebalstein Conatruction Coor 0 00 5 958 09 14 958 09 1 000 00 1 000 00 9213 N Seeboth Crafty 0 00 3 500 00 0 00 3 500 00 3 500 00 9214 7 Denial Driver 0 00 100 00 0 00 100 00 100 00 9215 J Mempton Editorial 0 00 100 00 0 00 100 00 100 00 9216 A Golow Producer 0 00 8 200 00 14 200 00 4 000 00 4 000 00 9210 PC ADV EDT REG 0 00 1 000 00 0 00 1 000 00 1 000 00 9255 Amia Evelyn PC Advance 0 00 900 00 1481 00 449 00 443 00 9301 DEP Airwaves Inc 0 00 500 00 0 00 500 00 500 00 9302 DEP Matro locaticna Inc 0 00 20 000 00 110 000 00 10 000 00 10 000 00 9303 Universal City Wardrobe 0 00 2 500 00 0 00 2 500 00 2 500 00 9304 TL Fisher 0 00 3 500 00 0 00 3 500 00 3 500 00 9305 DEP Univermal City Propa 0 00 2 500 00 0 00 2 500 00 2 500 00 9306 DEP Indepercdent Studio Service 0 00 2 500 00 0 00 2 500 00 2 500 00 9307 DEP Clairmont Camera 0 00 3 500 00 0 00 3 500 00 3 500 00 9308 DEP Daluxe lata 0 00 10 040 00 0 00 10 040 00 10 040 00 9309 DEP Director s Draw Down 0 00 69 160 03 0 00 69 160 03 69 160 03 9310 DEP DGA Crew CEC 0 00 27 317 25 0 00 27 317 25 21 117 25 9311 DEP Alex s Gourmet Catering 0 00 7 056 69 0 00 7 056 69 7 066 69 9312 DEP Alphe Medical 0 00 5 000 00 2 500 00 2 500 00 2 500 00 9313 DEP Easy Rider Prod Vehicl 0 00 2 500 00 0 00 2 500 00 2 500 00 9314 DEP Rent a center Warcrobe 0 00 1
199. ng Register appost The Vendor W9 Report includes the Vendor Number Name Address and displays whether the vendor has a W9 on File This information is pulled from the Vendor Entry apven screen Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format gt Spreadsheet Generates an Excel format report and appears instantly on your screen You are still able to print from the Excel format Please note if you select this option you are able to have additional sorting options within Excel 2011 Cast amp Crew Entertainment Services LLC 12 PSL3 User Manual Once you select Posting Register followed by either the Print Preview or Spreadsheet option PSL3 displays the following message prompt co Register printed con w Has the register printed correctly If you select No PSL3 asks Would you like to reprint the register If you still select No you will receive a prompt notifying you the posting process is not done therefore you are still able to make any needed changes If you select Yes you will receive a prompt confirming the selected A P transactions are now marked posted ee Information AJP
200. ng Report apvenp is also located in the Report folder under the A P Setup amp Maintenance and Vendors sub folders gt You can also access this report by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter AJP Vendor Inquiry apying Analysis apyena Account endor Totals accvt AJP Yendor Inquiry apving Bj AP Entry a Checks 5j 1099 ij Pio ij Pic i JE a PR a GL ii Checks Bj Budget Cost Closing 3 Recurring Batch ii Report ii PSL3 Help E E E E EEE EEE EEE amp The screen then appears 2011 Cast amp Crew Entertainment Services LLC ss PSL3 User Manual co apvenp Vendor Listing KAKAL UOMINI IK LOA Clear All Cancel 2011 Cast amp Crew Entertainment Services LLC VENDORS eo To select criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 Vendor Information e Starting and Ending Vendor Numbers Vendors to include in the report To restrict the report to only include information for a single vendor input the same Vendor Number in both the Starting and Ending fields To select all vendors leave both fields blank Report Format e Order By The
201. ng with their descriptions which are as follows ES Default 1099 x Default 1099 Description LU Prizes and awards Backup withholding Fishing boat proceeds Medical amp health payments Nonemployee compensation Substitute pay in lieu of dividends or interest Direct sales of 5000 or more Crop insurance proceeds Excess Golden Parachute payments Proceeds paid to an attorney 1 2 3 4 5 6 Y 8 a A B C e W9 on File Indicate if a W9 is on file for this vendor or employee The default is N for No Terms e Terms Description of the vendor s or employee s payment terms e g Net 30 Net on Receipt etc Enter a free form description of up to 15 alpha numeric characters of how soon after the invoice date the vendor expects to be paid and if there are any discounts Please note entering data here has no effect on an A P Entry apte transaction as no discounts are computed based on the data entered in this field 2011 Cast amp Crew Entertainment Services LLC 62 PSL3 User Manual Due Days Number of days from the invoice date until the invoice is due Enter the Due Days here ifany Please note if you enter a number in this field the Invoice Due Date field defaults in A P Entry apte when entering a new inwice The Invoice Due Date equals the Invoice Date Due Days Other Information Defaults Comment Free form field to input any additional comments regarding the vendor which can hold u
202. nput the State Employer Identification Number of the company for tax reporting purposes This field can hold up to 15 alpha numeric characters Company Info 2011 Cast amp Crew Entertainment Services LLC e Project ID Project ID number associated with the database production assigned Please note this field is only used for some major studios If your studio is independent leave this field and the Uploadable and Downloading fields blank Contact Info e Enter the company s point of contact in the Contact Name field as well as the Phone Number if applicable Helpful Hints Y Make sure to input all white colored fields as white fields are required before saving in PSL3 v To save this entry select either Save icon located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and clears the screen most common 00 Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes x exit to menu v To delete an unused Company Code place your cursor in the specific Company Code you want to delete and press the F10 Key or select the Delete icon fu Red strike through lines appear which are deleted upon saving v To search for an existing Company Code press the F7 Key or select the Find icon when the screen is clear All records appear in
203. nsactions for any errors as well as to make sure the transactions listed are indeed the ones you want to post You can print the Edit List or view it straight from your screen If you need to make any corrections do so in the Journal Entry jete screen After accepting the changes generate another Edit List to verify the corrections Once you re satisfied with the changes move forward with the Posting Register Posting is the act of permanently transferring a transaction to the Bible Report General Ledger bdbr Open gt To access the Post J E Transactions Edit List jepost screen click the J E module from the menu tree see following screen shot Listed are the Edit List and Post Reports You will notice once you click either report the other also becomes selected as you can view both reports from the same screen gt The Post J E Transactions Edit List jepost screen is also located in the Report module under the Journal Entry sub folder gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter osted Transaction Editor gifix GIL Transaction Changes glfixp Import an Excel File amp lint a PR a GL aj Checks 3 Budget Cost Za Closing 3 Recurring Batch 3 Report aj PSL3 Help E E E E ttt 2011 Cast amp Crew Entertainment Services LLC The screen then appears Batch Reference Production Company
204. nt Totals Only Sub totals and or Company Sub totals to display Once saved the newly created format will now display as an option in the Report ID field within the Trial Balance Report gltb screen Please note all PSL3 databases are already pre set with the SUMMARYTB and DETAILTB Report ID formats as default options and if you are associated with a studio then that studio s customized 2011 Cast amp Crew Entertainment Services LLC 232 PSL3 User Manual format 2011 Cast amp Crew Entertainment Services LLC GENERAL LEDGER 233 Chapter 9 6 Additional G L Inquiries and Reports PSL3 offers additional G L Inquiries and Reports which are listed below Open gt To access the following G L Reports click the G L module from the menu tree see following screen shot gt These additional G L Reports are also located in the Report module under the General Ledger sub folder gt You can also access these reports by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter aj Budget ay Cost 3 Closing 3 Recurring Batch 5 Report aj PSL3 Help To select criteria for the following reporting screens press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored f
205. nt for each employee The Payroll Entry prent screen is not used to enter new Payroll transactions only loaded Payroll invoices Please contact your Cast 8 Crew Payroll Coordinator to issue a new or revised Payroll invoice if needed If no changes need to be made on the Payroll Interface file the Payroll Entry prent screen can be skipped and you can proceed to post the invoice in the Post P R Transactions prpost screen Open gt To access the Payroll Entry prent screen click on Tab 6 or press ALT and the number 6 Key simultaneously to open the screen gt Payroll Entry prent can also be accessed in the P R module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC PAYROLL as a Setup aj AP a Pio aj Pic a JE Sa PR Load C amp C Invoice printr ue EA e Ist prpost Post prpost History Report prhist Accrued Holiday Report acvhrpt Invoice Report prinvp Print Payroll Checks prekprnt Payroll Wasils Report prwasis a GL 3 Checks aj Budget 5 Cost a Closing 5 Recurring Batch B Report 5 PSL3 Help eee EEE t The screen then appears 2011 Cast amp Crew Entertainment Services LLC 132 PSL3 User Manual gt SiSsibie O de Number Batch Eff Date Prod Descri
206. nt to delete and press the F10 Key or select the Delete icon fu Red strike through lines appear which are deleted upon saving v To search for an existing Series Code press the F7 Key or select the Find icon when the screen is clear All records appear in which you can scroll through using the Arrow icons First Prior Next and Last l e O or by pressing the Page Up or Page Down Keys until you find the code needed 2011 Cast amp Crew Entertainment Services LLC Chapter 2 6 Location Code Entry Use Location Code Entry suloc to set up Location Codes for tracking expenses by location Please note if you are not tracking location expenses you must setup at least a default Location Code e g 0000 to be used in the transaction entry screens You can also use the Location Code like a Free Field Code to track other items such as all travel costs for all locations if you prefer Please note a Location Code record can not be deleted once it has been used in PSL3 If you would like to print a list of all Location Codes entered in the database click the Report module then Setup amp Maintenance sub folder Listed is the Location Codes List Report Open gt To access the Location Code Entry suloc screen click the Setup module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu
207. nterface Amounts Translation 0000 Account File name of file containing bugdet Prior to the import process first save the Movie Magic or EP Budget dsc or Text Tab delimited txt format file to your computer If you are importing from Movie Magic select File gt Export gt C amp C Format If you are importing from EP Budgeting select File gt Export gt Other gt C amp C Format Interface File e Select File Choose the Text Tab delimited txt or dsc file you wish to load Please note budgets are loaded one at a time Budget Information e Budget Name Input the name of the budget you are importing which can hold up to six alpha numeric characters After entering the new Budget Name PSL3 asks Budget is not in the database Do you wish to create it Select Yes Please note each Budget Name must be unique Immediately to the right of Budget Name input the description of the budget which can hold up to 50 alpha numeric characters e Production Press the F2 Key or right click in this field if the Production Code for the budget does not already default Create Budget Lines With 2011 Cast amp Crew Entertainment Services LLC 274 PSL3 User Manual e Press the F2 Key or right click in any of these fields Series Location Set and Currency to choose the necessary codes ifthey don t already default The codes selected will be associated with the budget lines once created Make sure
208. nvoice Number from the vendor s invoice which can hold up to 15 alpha numeric characters depending on your studio e Date Date of the invoice which is separate from the Effective Date of the transaction 2011 Cast amp Crew Entertainment Services LLC o PSL3 User Manual NOTE Please email a request to support castandcrew com to make the Invoice Number and Invoice Date white mandatory fields e Due Date Date by which the invoice needs to be paid If the Due Days field in Vendor Entry apven was entered for this vendor then this field automatically defaults with the amount of days specified e Amount Dollar or other currency amount due for the invoice e Discount Amount by which the check amount is reduced Invoice Amount Discount Amount Check Amount The discount can be input by using a dollar amount or percentage for example you can enter 10 in this field and PSL3 will automatically calculate the amount for you NOTE Please email a request to support castandcrew com to deactivate the Discount field This field will no longer be accessible in your database Check Information Combine Defaults to O zero which means PSL3 will generate one check for all invoices for the same vendor If you want a separate check for each invoice input a number between 1 through 9 for each A P Entry apte transaction Hold Check mark this option if the vendor will be picking up the check The
209. o save this entry select either Save icon located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and clears the screen most common O 2011 Cast Crew Entertainment Services LLC so PSL3 User Manual ec Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes X exit to menu v To delete an unused Set Code place your cursor in the specific Set Code you want to delete and press the F10 Key or select the Delete icon m Red strike through lines appear which are deleted upon saving v To search for an existing Set Code press the F7 Key or select the Find icon when the screen is clear All records appear in which you can scroll through using the Arrow icons First Prior Next and Last l or by pressing the Page Up or Page Down Keys until you find the code needed 2011 Cast amp Crew Entertainment Services LLC SETUP 51 Chapter 2 8 Additional Optional Setup Screens PSL3 offers additional optional Setup Screens which are listed below Open gt To access the following Setup Screens click the Setup module from the menu tree Additional Setup Screens are also listed in in the Setup module then Reports sub folder see following screen shot gt You can also access these screens by typing the screen
210. ocated on the toolbar the transaction appears in which you can proceed with the necessary modifications Effective Date Date of the transaction that is recorded and affects the Estimated Final Cost Report efcrpt should default with today s date after generating the Reference Number You can always change the Effective Date by typing over the defaulted date or by right clicking in that field for the calendar selection to appear Please note you can not input a date that is in a previously closed period If the Variance was created in either the EFC Entry efcent or Cost Report EFC Worksheet efcws programs the Effective Date defaults upon entering the Reference Number with the date previously input in either screen 2011 Cast amp Crew Entertainment Services LLC ec Pick a date lt lt lt January 2011 ale Goji 17 18 19 20 21 22 NOTE Please email a request to support castandcrew com if you need a transaction s Effective Date changed and include the Reference Number s Please be advised depending on your specific studio s guidelines the Support Department may need to obtain approval from your Studio Finance Executive before proceeding e Description Explanation of this Variance transaction as a whole which can hold up to 30 alpha numeric characters This Reference Description defaults in the distribution lines If the Variance was created in the EFC Entry efcent program the description defaults
211. odule then Maintenance sub folder 2011 Cast amp Crew Entertainment Services LLC 276 PSL3 User Manual WARNING Please be advised if you are importing a budget file from Movie Magic PSL3 imports both Header and Sub accounts on occasion This works fine for creating the Chart of Accounts which does not include any amounts however the result for the budget is that the budget amount doubles the original amount The solution is to manually delete Header Accounts from the budget in Budget Amount Entry bdent not Chart of Accounts Entry glca NOTE Please email the budget file in Text Tab delimited txt or dsc format or both formats to be sure to support castandcrew com should you encounter any problems with the file import The Support Department is happy to assist in troubleshooting and or loading the file for you upon request 2011 Cast amp Crew Entertainment Services LLC Chapter 11 2 Create a Budget A budget is a financial document that allocates a Production s financial transactions to a group of accounts each of which describes a component of film making and enables financial reporting Use the Create a Budget bdgl program to create a new budget by copying in the account number data from your Chart of Accounts glca Once the budget is created use the Budget Amount Entry bdent screen to add the budget amounts for each account Ifthe Chart of Accounts glca were added after you created th
212. of able to access this field Statement Input the Bank Statement balance This amount is zero when you begin your first Bank Reconciliation As you clear items this amount changes Your Bank Statement is reconciled when the statement balance equals the checkbook balance Difference Difference amount balance Cleared amount Statement amount Difference amount balance Please note you are nof able to access this field Start to populate data gt To proceed with the clearing process press the F1 Key then S option or select Start located in the top right hand corner of the screen Once you select Start the transaction details at the bottom of the screen are displayed You are then able to indicate whether an item is cleared along with it s Clear Date Transaction Details e Cleared To manually mark an item as Cleared enter the letter C in this field You also have the option to automatically mark all checks or deposits as Cleared by selecting either Clear All Checks or Clear All Deposits located in the right hand corner of the screen In addition you have the option to automatically mark all checks or deposits as Uncleared by selecting either Unclear All Checks or Unclear All Deposits e Clear Date Once you have marked an item as Cleared the Clear Date defaults with the date input as the Statement Date Please note you are able to change the Clear Date Please note you are not able
213. olbar the transaction appears in which you can proceed with the necessary modifications Please note the only fields you are able to modify in the Reference Header section are the Reference Description and State Worked fields All other fields in the Reference Header section are not accessible Distribution Lines e After inputting the Reference Number in the Reference Header section the distribution lines of the specified transaction default To change the defaulted codes of the original transaction press the F2 Key or right click in any of these fields Account Series Location Set 1099 Insurance Free Field s Description Amount and 3rd Party Please note if you press the F2 Key or right click in the Amount field a calculator displays for your convenience ee Calculator NOTE Please note P C Entry pcent distribution lines will not appear in the Posted Transaction Item Editor glfix if they were automatically created by PSL3 therefore you are not able to make changes to them in this program P C distribution lines only appear in this screen if they were manually created An alternative to make changes to automatically created P C distribution lines is to do so in the Journal Entry jete screen 2011 Cast amp Crew Entertainment Services LLC 164 PSL3 User Manual WARNING Please be advised PSL3 does not allow you to save the change s unless the original debit and or credit amount remains the same as
214. ollowing are brief descriptions of the menus you can access from the program menu bar File The File menu allows you to set up printer pages and exit the program Edit The Edit menu allows you to edit and find retrieve all or some transaction entries Programs The Programs menu shown at the beginning of this section provides another option for opening programs Although it uses a menu format instead of a tree format the programs are organized as they are in the program tree Options The Options menu provides a mouse based way of accessing keyboard shortcuts for working with fields working with entries and for opening Help You can also use it to exit close a program Favorites The Favorites menu provides quick access to programs you ve added to your PSL3 favorites This function allows you to add and quickly access bookmarked programs Help The Help menu provides several types of help as well as about the program information 2011 Cast amp Crew Entertainment Services LLC te PSL3 User Manual Chapter 1 4 ICONS AND SHORTCUTS PSL3 provides several methods for interacting with the program including icons keyboard shortcuts and mouse shortcuts You can pick the method that best suits your work style You may want to print the following tables to use as a quick reference Toolbar Icons Toolbar icons are displayed at the very top of each PSL3 screen The following tables describe the PSL3 icons f
215. or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC 52 PSL3 User Manual anks subank Batch Maintenance batchent Control AP suapctrh Currencies sucur Default Accounts suacct Employees pcemp Free Field1 sufree1 Free Field sufree2 Free Field3 sufree3 Free Field4 sufree4 Insurance suins Locations suloc Productions suprod Recurring Batch rbcre Company Code sucomp Report Group Entry surpt Series suser DataBase Info sudbinfo Sets suset States sustate Users suuser Vendo pir fanven 1 aj Reports Control system suctrl Line Type Entry sulntyp Additional Setup Screens are as follows Batch Maintenance Entry batchent Change Password newpass Control A P Information Entry suapctri Default Accounts Entry suacct Employee Entry pcemp Free Field Code Entry 1 4 sufree Insurance Code Entry suins Database Information Entry sudbinfo State Code Entry sustate Report Group Entry surpt also listed in Additional G L Entry Screens 2011 Cast amp Crew Entertainment Services LLC SETUP 53 e User Entry suuser e System Control Information Entry suctrl e Line Type Entry sulntyp 2011 Cast amp Crew Entertainment Services LLC POLS VENDORS O VENDORS 37 Section 3 VENDORS This section will address the following programs
216. or program toolbars which are as follows Please note if an icon is colored gray instead of blue the action is not available 5 nl 3 H Function SE First entry m Free a al U sa Peal ee IF u cy ejj Find entries allie PE Hi a a arr Cancel changes Field Field Field Field Field Record entry or field field Field Field Field Field Field Field Field Description Go to the first entry Go to the previous entry Go to the next entry Go to the last entry Add a new entry Mark the entry for deletion Mark the distribution line for deletion Find entries based on search entera Save the changes made since the last save and leave the current entry displayed on the screen Example use interim saves while entering a transaction with many distribution lines Save the changes including deletions since the last save clear the screen and leave the Program open Cancel all changes and new entries since the last save clear the screen and leave the Program open Save changes and new entries and close the program Display detailed information if available for the field Displays a dropdown list of the available entry choices for the field 2011 Cast amp Crew Entertainment Services LLC HOW TO USE THIS MANUAL to IL l i ID i i Help Field B P Clear Field c el Cancel entry Field B MAN Save to PDF Field NN Zoom in Field E MAN Zoom out Field e
217. or select Start located in the top right hand corner of the screen Make sure to input all white colored fields as white fields are required before the Start option is made available Once you select Start the worksheet at the bottom of the screen becomes available You are able to make changes to the light blue colored fields which include Cost to Complete EFC Variance and Description If you leave the Description field blank PSL3 defaults the description to EFC Entry Variance in Variance Entry bdve Please note if you press the F2 Key or right click in the light blue worksheet fields a calculator displays for your convenience 2011 Cast amp Crew Entertainment Services LLC Once all EFC changes have been made save the changes by pressing the F1 Key then A option to Accept which saves and clears the screen or select the Accept icon located on the toolbar A Variance transaction is created and the Variance Entry bdve Reference Number displays on the screen 2011 Cast amp Crew Entertainment Services LLC 304 PSL3 User Manual Chapter 12 2 Variance Entry A Variance is an estimate that deviates from the amount budgeted for that estimate usually the difference between the actual costs of Production and the budgeted costs The Variance Entry bdve program allows you to create or modify a Variance transaction Once an EFC Variance change has been created PSL3 automatically adjusts the Cost to Complete
218. or to posting To move forward with posting select Posting Register followed by either the Print Preview or Spreadsheet option this will transfer the transaction s to the Bible Report bdbr 2011 Cast amp Crew Entertainment Services LLC 134 PSL3 User Manual Report Formats e Report Format Report Sort and Description Of are all sorting options available for you to select per your preference Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format gt Spreadsheet Generates an Excel format report and appears instantly on your screen You are still able to print from the Excel format Please note if you select this option you are able to have additional sorting options within Excel Once you select Posting Register followed by either the Print Preview or Spreadsheet option PSL3 displays the following message prompt a Register printed Has the register printed correctly If you select No PSL3 asks Would you like to reprint the register If you still select No you will receive a prompt notifying you the posting process is not done therefore you are still able to make any needed changes If
219. orksheet efcws screen for your records Although PSL3 allows you to select any ofthe three previously mentioned options the result of entering an EFC or Variance in either Variance Entry bdve EFC Entry efcent or in the Cost Report EFC Worksheet efcws screen is exactly the same Open gt To access the EFC Entry efcent screen click the Budget or Cost module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC UE EA EA E E The screen then appears O 2011 Cast Crew Entertainment Services LLC 3 Setup a AP a Pio Ba Pic sa JE a PR a GL ii Checks a Budget 4 Cost Cost Report eferpt Cost Bible Report fefcrpt2 Average EFC Report avgefc Cost Detail Report costinff EFC Summary Variance Report efedift Episodic EFC Report efeser EFC Entry efcent Y nuve EFC Worksheet efcws Account Variance Report bdvar Reference Variance Report bdvep a Closing aj Recurring Batch jj Report 3 PSL3 Help 300 PSL3 User Manual Ed ts ole i gt il is Bu Bat DEMO FILM DEMO DATABASE Compan x Rof Ef Date From M Combine End Date ast ext avon f mime a miine F include committed FT include inactive accounts Source Al source currency F Budget amount as activity Target Dollars F Ope
220. osing 3 Recurring Batch a Report ii PSL3 Help EEEE The screen then appears 2011 Cast amp Crew Entertainment Services LLC PETTY CASH 1 33 a pcpost Post P C Transactions SEE File Edit Programs Options View Favorites Help 1B10 Q1Q101 1512410 HA Post P C Transactions Print Batch EEE allbatches Reference All reference numbers Preview vendor E Allvendors Spreadsheet Production All productions Company MAA All companies Bank All banks Currency All currencies Report Type Edit List AAA O Posting Register E Report Format Report Sort Description Of O Account Number O Account Number Account Number Reference Number Entry Order O Series Clear All Account per Line Location O Set Cancel Exit Help Enter a batch number leave blank for all Post P C Transactions Selection Criteria e To select an entry press the F2 Key or right click in any of these fields Batch Reference Vendor Production Company Bank and or Currency to select the item s needed You can also choose multiple entries by holding down the Control Key and simultaneously using the mouse to select By making a selection this isolates the report to only display items based on the code s selected If you wish to select all unposted P C transactions leave all fields blank Report Type e Defaults to Edit List to review your P C entries and make any necessary modifications pri
221. ough using the Arrow icons First Prior Next and Last l l l O or by pressing the Page Up or Page Down Keys until you find the code needed 2011 Cast amp Crew Entertainment Services LLC 2 PSL3 User Manual Chapter 2 5 Series Code Entry Use Series Code Entry suser to set up Series Codes for tracking expenses by series episode Please note if you are not tracking series expenses you must setup at least a default Series Code e g 0000 to be used in the transaction entry screens You can also use the Series Code like a Free Field Code to track other items such as all travel costs for all series if you prefer Please note a Series Code record can nof be deleted once it has been used in PSL3 If you would like to print a list of all Series Codes entered in the database click the Report module then Setup amp Maintenance sub folder Listed is the Series Codes List Report Open gt To access the Series Code Entry suser screen click the Setup module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter Setup Banks subank Batch Maintenance batchent Control AP suapctrl Currencies sucur Default Accounts suacct Employees pcemp Free Field1 sufree1 Free Field2 sufree2 Free Field3 sufree3 Free Field4 suf
222. p to 30 alpha numeric characters Petty Cash Check mark this option if this vendor or employee will be using Petty Cash Once check marked the P C Advance Account field becomes accessible to input the account number Status Inactive Check mark this option if you would like to mark the vendor or employee inactive in the database Ifthe Inactive field is check marked PSL3 blocks all users from using the vendor in the transaction entry screens NOTE Ifyour database has duplicate vendor records you can check mark the Inactive field for one of the vendors or email a request to support castandcrew com for a Vendor Merge Please specify which Vendor ID Number you would like to remain in PSL3 Currency Code Currency Code representing the currency in which this vendor is normally paid To add a new currency use the Currency Code Entry sucur screen located in the Setup module Default Account Expense Account Number most often used when you enter invoices for this vendor The Default Account selected automatically defaults in the transaction distribution lines for this vendor but you can override it Press the F2 Key or right click to select the account number If the account number doesn t exist in PSL3 you can add it by pressing the F5 Key or selecting the Zoom icon e located on the toolbar This zooms into the Chart of Accounts Entry glca screen in which you can add the account number immediately Once saved pres
223. partment may need to obtain approval from your Studio Finance Executive before proceeding e Description Explanation of this P O transaction as a whole which can hold up to 30 alpha numeric characters This Reference Description defaults in the distribution lines If this field is left blank PSL3 defaults the distribution description with the description of the first account number selected e Status Overall status of the transaction Status types of the entire P O are as follows gt O Open The P O transaction status is Open and appears as a commitment on the Estimated Final Cost Report efcrpt gt C Closed The P O transaction status is Closed either by the P O lines being relieved to A P Entry apte or by manually closing the P O PSL3 updates the status automatically when relieving the P O to A P Entry apte Batch Information e Codes that are attached to the transaction These fields are pulled from the User Entry suuser screen located in the Setup module if setup beforehand To change the defaulted codes press the F2 Key or right click in any of these fields Batch Production Company and Currency to make your selection 2011 Cast amp Crew Entertainment Services LLC PURCHASE ORDER Vendor Information e Select the vendor needed by pressing the F2 Key or by right clicking in the Vendor ID field Once the list of vendors appears you can scroll through to find the vendor or click on the col
224. ployees Vacation and Holiday Accrual Account totals ran by Social Security Number This report displays the Invoice Number Check Number Reference Number and Balance sorted by the employee s last name e Payroll Invoice Status Report prinvp Use prinvp to display the status of each Payroll invoice This report displays the Invoice Number Reference Number Description and Status Posted or Not Posted sorted by invoice 2011 Cast amp Crew Entertainment Services LLC PAYROLL 20 e Payroll Was Is Report prwasis Use prwasis to track and report all changes made to a Payroll Inwice file after being loaded into PSL3 This report can be ran by Payroll Check Number Employee Number Week Ending Date and Reference Number The report displays the WAS what the original data was in the Payroll Inwice File before loaded into PSL3 and IS what the data s now detailing the changes for all distribution fields for each transaction on the Payroll Inwice File NOTE The reports are available in either Print Preview and or Spreadsheet formats NOTE Please email support castandcrew com if you don t see a specific PSL3 report currently listed as an option in your database 2011 Cast amp Crew Entertainment Services LLC POLS GENERAL LEDGER Secti GENERAL LEDGER 209 Section 9 GENERAL LEDGER This section will address the following programs gt Chart of Accounts Entry gt Chart of Acco
225. prompt bar located above the Setup menu Then press Enter Setup Banks subank Batch Maintenance batchent Control AJP suapctri Currencies sucur Default Accounts suacct Employees pcemp Free Field1 sufree1 Free Field sufree2 Free Field3 sufree3 Free Field4 sufree4 Insurance suins Locations suloc Productions suprod Series suser DataBase Info sudbinfo Sets suset States sustate Users suuser Change Password newpass vendor Entry apven a Reports Control System suctrl Line Type Entry sulntyp The screen then appears 2011 Cast amp Crew Entertainment Services LLC 36 PSL3 User Manual Company e Code Input the code identifying the company which can hold up to three alpha numeric characters After entering the new Company Code PSL3 asks That Company Information Entry is not in the database Would you like to add it Select Yes e Name Input the name of the company which can hold up to 30 alpha numeric characters e Name on Reports Input the name of the company as how you would like it to display on reports which can hold up to 50 alpha numeric characters Address Enter the company s Address City State and Zip Code if applicable Tax Info Federal Tax ID Input the Federal Employer Identification Number of the company for tax reporting purposes This field can hold up to 15 alpha numeric characters e State Tax ID I
226. ption Company Status Bank Currency Number Total Debits Total Credits Account Sers Locs Sets in FF1 FF2 Description Emp Amount Transaction reference number Enter search criteria or add data Reference Information e Reference Number System assigned number that is also referred to as transaction number This automated number is generated after loading the Payroll Interface file in the Load Interface C amp C Payroll Invoice printr screen To bring up the Payroll transaction type in the Reference Number previously assigned and press Enter the F7 Key or select the Find icon located on the toolbar the transaction appears in which you can proceed with the necessary modifications If you forgot to write down the Reference Number assigned you can also bring up the Payroll transaction by pressing the F2 Key or right clicking in the Invoice Number field to choose from the list Effective Date Date of the transaction that is recorded on the Bible Report bdbr and appears as an Actual Cost on the Estimated Final Cost Report efcrpt should default with the date the Payroll Interface file was loaded into PSL3 You can always change the Effective Date by typing over the defaulted date or by right clicking in that field for the calendar selection to appear Please note you can not input a date that is in a previously closed period 2011 Cast amp Crew Entertainment Services LLC PAYROLL 183 ce Pick a date 7a A
227. pup screen listing the available relevant data for a field To permanently transfer a transaction to the general ledger The second phase in film making which starts when principal photography begins and ends The member of the production staff who determines the propriety of all financial production accountant production accounting program number transactions and ensures that they are documented in accordance with company policies and procedures and with applicable government requirements The production accountant receives or generates all financial documentation for the production The scheduling oversight and recording of the expenditure of all funds to produce a motion picture or a television show The number on a program tab A graphical hierarchical method of showing program groups and the programs within program tree O 2011 Cast Crew Entertainment Services LLC ass PSL3 User Manual Term purchase order purchase order relieving show timecard trial balance unit production manager variance vendor vendor number voided check week ending wildcard zero balance Definition them The tree may be expanded to show lower level branches or collapsed to show only higher level branches A record of expenses or of a financial commitment that serves as an approved written contract for goods or services Posting the accounts payable transaction that contains the lines transferred from
228. r representing the account for the Petty Cash Box Custodian from which Petty Cash will be disbursed usually an Asset account P C Clearing Chart of Accounts number representing the account from which all P C invoices will be cleared usually a Liability account This account number is the credit entry also known as the offset account for P C expenses after you post the P C transaction s Please note if you will not be using a P C Clearing account you can input the same account number from the P C Box field here Company Information e Code Input the Company Code associated with the Bank Code Helpful Hints v Make sure to input all white colored fields as white fields are required before saving in PSL3 v To save this entry select either Save icon A l located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and clears the screen most common ee Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes X exit to menu v To delete an unused Bank Code place your cursor in the specific Bank Code you want to delete and press the F10 Key or select the Delete icon fu Red strike through lines appear which are deleted upon saving v To search for an existing Bank Code press the F7 Key or select the Find icon CY when 2011 Cast amp C
229. range of certain account numbers when selecting a Budget Code input the account numbers in these fields To restrict PSL3 to only display information for a single account number input the same account in both the From and To fields Then press the F7 Key or Find icon Ly located on the toolbar for the budget lines to appear To display all account numbers leave both fields blank Selection Criteria e If you would like to look for certain Series Location and or Set Codes when selecting a Budget Code input the codes in these fields You can also look for a certain budget amount by check marking the Amount field and inputting an amount Then press the F7 Key or Find icon Q located on the toolbar for the budget lines to appear To display all codes and amounts leave these fields blank Account Lines Account Number Chart of Accounts Number for this budget line Please note you are not able to access this field Series Series Code for this budget line Please note you are not able to access this field Location Location Code for this budget line Please note you are not able to access this field Set Set Code for this budget line Please note you are not able to access this field Currency Currency Code for this budget line Press the F2 Key or right click in this field to change the Currency Code if needed Amount Budget amount for this budget line To change the amount simply type in a new amount Please note if
230. ransactions Edit List gt Defer Open Items gt Modify Open Items gt Void Open Items gt 1099 Reporting Screens gt Additional A P Screens Reports 2011 Cast amp Crew Entertainment Services LLC so PSL3 User Manual Chapter 5 1 A P Entry Accounts Payable is the obligations to suppliers of merchandise or services purchased on an open account In the A P Entry apte program you can record amounts that your production owes to vendors but has not yet paid Whether your production uses purchase orders or not you can input invoices before issuing a check for the payment process Entering new A P invoices looking up modifying setting up recurring batches transferring P O distribution lines and deleting unposted A P transactions can be done in the A P Entry apte screen Open gt To access the A P Entry apte screen click on Tab 1 or press ALT and the number 1 Key simultaneously to open the screen gt AIP Entry apte can also be accessed in the A P module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter da Setup Ea AP a Vendor Entry apte dit List appost Post appost Open Items Report apopenp Defer Open Items ckdef Yoid Open Items apyoid2 Ea Checks 5j 1099 a Pio a Pic a JE a PR a GL ii Checks aj Budget ii Co
231. rate the report gt Print Combined Report Opens the Print Dialogue box and sends the report combining all Series Location and Set Codes onto one report directly to the printer gt Print Individual Report Opens the Print Dialogue box and sends the report separating each Series Location and Set Codes into separate reports directly to the printer gt Preview Combined Report Generates a PDF format report combining all Series Location and Set Codes onto one report and appears instantly on your screen You are still able to print from the PDF format gt Preview Individual Report Generates a PDF format report separating each Series Location and Set Codes into separate reports and appears instantly on your screen You are still able to print from the PDF format gt Spreadsheet Generates an Excel format report and appears instantly on your screen You are still able to print from the Excel format Please note if you select this option you are able to have additional sorting options within Excel gt TSV Spread Generates a Text txt file in which you save to your computer and Open With the desired program of your choice This option is usually selected in lieu of the Spreadsheet option in the instance the report exceeds the number of lines allotted in Excel The TSV Spread option does not have line limitations whereas depending on the version of Excel the Spreadsheet option may 2011 Cast amp Crew Ente
232. ree4 Insurance suins Locations suloc Productions suprod Recurring Batch rbcre Company Code sucomp Sets suset States sustate Users suuser Change Password newpass vendor Entry apven a Reports Control System suctrl Line Type Entry sulntyp The screen then appears 2011 Cast amp Crew Entertainment Services LLC Fields e Production Input the Production Code associated with the Series Code e Series Input the code identifying the series which can hold up to four alpha numeric characters After entering the new Series Code PSL3 asks That Series Code is not in the database Would you like to add it Select Yes e Description Input the name of the series which can hold up to 30 alpha numeric characters Helpful Hints v Make sure to input all white colored fields as white fields are required before saving in PSL3 v To save this entry select either Save icon located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and clears the screen most common O 2011 Cast Crew Entertainment Services LLC a PSL3 User Manual ee Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes X exit to menu v To delete an unused Series Code place your cursor in the specific Series Code you wa
233. rew Entertainment Services LLC RECURRING BATCH a rblist List of Batches BI 1 191 151 1 O F Include references nter a batch number To select criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank Batch Info e Starting and Ending Batch Numbers to include in the report To restrict the report to only include information for a single Batch Number input the same batch in both the Starting and Ending fields To select all Batch Numbers leave both fields blank Reference Info e Include References Check mark this option to include the list of Reference Numbers for each Batch Number selected By check marking this option the report includes the reference header details for each transaction Print Preview the Report Located in the top right hand corner of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format 2011 Cast amp Crew Entertainment Services LLC POL GLOSSARY O GLOSSARY 351 Section 15 GLOSSARY The Glossary lists terms and their meanings as used in this document Te
234. rew Entertainment Services LLC SETUP 31 the screen is clear All records appear in which you can scroll through using the Arrow icons First Prior Next and Last g l l l O or by pressing the Page Up or Page Down Keys until you find the code needed 2011 Cast amp Crew Entertainment Services LLC 32 PSL3 User Manual Chapter 2 2 Production Code Entry Production is the second phase in film making which starts when principal photography begins and ends Use Production Code Entry suprod to set up a Production Code for your database Most PSL3 databases only use one Production Code but you can set up additional codes if needed A common Chart of Accounts must be used for all Productions within a database If a Production requires a unique Chart of Accounts then it is suggested to create a new database Please note a Production Code record can not be deleted once it has been used in PSL3 If you would like to print a list of all Production Codes entered in the database click the Report module then Setup amp Maintenance sub folder Listed is the Production Codes List Report Open gt To access the Production Code Entry suprod screen click the Setup module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter Setup Banks subank Batch Maint
235. ria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 e Account Vendor Totals Report accvt Use accu to print a total for each Account Vendor combination Only paid or voided A P distributions contribute to the totals This report converts all amounts to the base currency This report can be ran by Starting and Ending Dates a range of Vendor ID Numbers Starting and Ending Account Numbers and Multiple Currency as selection criteria 2011 Cast amp Crew Entertainment Services LLC ns PSL3 User Manual A P Open Items Report apopenp Use apopenp to view which A P invoices have been posted but not yet paid This report can be used to determine which A P transactions you want to pay with your next check run You can enter a range of Vendor ID Numbers Aging Date Effective Date as well as include Detail and ltems Past Selected Aging Date as selection criteria The report can be sorted by Vendor Number or Vendor Name A P Vendor Analysis Report apvena Use apvena to track A P transaction activity by vendor You can choose the Report Type Vendor ID Vendor Name State or Invoice and include the Transaction Type Unposted Open Paid and or Void You can also enter a range of Vendor ID Numbers Start and End Dates Multiple Currency etc as selection criteria A P Vendor Inquiry apving Use apving to look up information on posted A P transa
236. rm _ Definition accounts payable Obligations to suppliers of merchandise or services purchased on an open account available A program feature that is available for use that is not inactive bank reconciliation balancing cash The procedure of reconciling the bank balance reflected on a ledger to the bank balance reflected on a bank statement for a given period to balance a bank statement batch The method of identifying documents to be input to an accounting system as a group to control data flow in data processing a group of items entered into a unique numerical identifier and held until processed bible The report containing the transactions for all of the penods entered into the computer auditing system budget A financial document that allocates a production s financial transactions to a group of accounts each of which describes a component of film making and enables financial reporting and is classified as above the line or below the line budgeting The act of translating a script into a budget chart of accounts The master list of all the accounts used to track production costs expenses assets liabilities and income check on demand A single quick turnaround computer check produced to immediately pay an invoice check register A report normally in check number order that identifies the checks written over a time period and that provides information such as the check date and amount a numerical record of posted
237. rovide you the Payroll Entry prent Reference Number for this invoice Upon selecting Yes you may also receive the following warning message if your Payroll Interface file contained errors cc Payroll Errors Encountered Payroll Errors have been Encountered Do you still wish to load If you select No you will receive a prompt notifying you the loading process is not done If you select Yes you will then receive the prompt confirming the selected Payroll invoice is now loaded in which PSL3 will provide you the Payroll Entry prent Reference Number for this invoice With this new Reference Number you can still make any needed changes in Payroll Entry prent before posting as it is created with an unposted status 2011 Cast amp Crew Entertainment Services LLC 180 PSL3 User Manual Chapter 8 2 Payroll Entry Payroll Entry prent allows you to modify the Payroll data that was loaded into your database through the Load Interface C amp C Payroll Invoice printr screen Each Payroll transaction is equivalent to a single Payroll inwice which may include many employees displaying a number of accounts such as Labor Fringe FICA etc In Payroll Entry prent you can change almost any distribution coding e g account series location set etc on the Payroll Interface file You can also add a line to split amounts for each employee as well as delete a line However you can not change the invoice total or the total amou
238. rssunsnnnennnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnsnnnnnnnnnnnnnnnnnnnnnnn nn 161 G L Transaction Changes Report uusrunssnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnsnnnnnnnsnnnnnnnsnnnnnnn nn 165 importan Excel Filen riai eier 168 PAYROLL 175 Load Interface C amp C Payroll INVOICE oommcccconnccccnnnnncncnnnnnncnnnonnnnnnnnnnrnnnnnnrr rra 176 PAYTOMMIENtY coran de cecacecieceuntensucde E E A a T 180 Post P R Transactions Edit List se ch 188 Load Payroll Other COMpaNy cccconnccccconoccccnnnncncnnnonancnnnnnnnrnnnnnnnrrnnnnnnrr rra rra 194 Print Payroll CHECKS ici A al sdeavesteceavels 198 Payroll History Report iii a 200 Additional Payroll Screens Reports ursussnennnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn 204 GENERAL LEDGER 209 Chart of ACCOUNTS EMtr ys iccceisccccecicecdeccctcrecstcnsssveccusaeretcecedzeccbsserstcuesdveccbeinertesesdzecstvazsrstcesedee 210 Chart of Accounts Listing Re Port ccccccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeaeeeeeesaeeeeeesaeeeessaeeeeessaneeeees 215 Trial Balance Report z a a ae cians oes a ves eee ale cans eee a aa i 218 Bible Re Dorta TER FERFREUEERFEREFERSEFEUPFERFEESEEEUEERREEFEFEULERFSEERERFEREUESEROLEEREPEEEFREERFEEFRELFEORESEREE 224 Additional GIL Entry S cree NS iii da tet aves 231 Additional G L Inquiries and ReportS ccoooccconnccccnncnonnnonnnnnonnncnnnncnnnrnnnnnnnnnnrnnnnernnnrrnanennnn 233 CHECKS 237 Pre Check Printing Re ports vn i ceeceedseccctisekegccsaazccest
239. rtainment Services LLC 250 PSL3 User Manual Below is a sample of the Combined Bible Report bdbr with Include Detail check marked 09 10 2011 PSL TRAINING DEMO Page i 3 23 pa Bible hn bebe Currency selected ell currencies Printed ia Dollars 05 fi CABADIAN DOLLARS Ci 4 800060 1 000008 CANADIAN DOLLARS C3 3 390000 3 000000 CASADIAN DOLLARS 21 2 3001 1 000000 Sete Range 03 01 11 te 03 30 11 Report se for wenden 0000033 CAST AND OD DETETA only Start Acct Fiset Acooust Production DOO IISI DIO DATABASE Serses Al fad Aset Leet Account Companys ALI tocerion Ai ineurencer ALI Set ali Current activity caly Fri ali Source Ali free Abi Ft Paberi All Comp ret se Distribution e Sade Pembrr sic Seth Pabor invzase Paker 202 Bunker Venter bmp E Mi LES ia sche e Sug Aecuns ER AS AJP CLEARING 19500 ga ur ze 11 11 OTAN EU r 7 TOTAL A P CLEARING 20 934 15 TOTAL A P CLEARING 0 934 15 TOTAL A P CLEARING 20 934 05 As AD On ar SES us ca um oew i Cig Dist Invesdi2463 gt us 0 00 CANT AFD CREW ENTERTA a Cle Diet Imvobdi2412 3s 0 00 CAST AD CD ar Cle Diet Imvobiizar2 us 0 00 CAST SD chew ar us 29 630 00 os 3 063 97 28 694 09 38 634 85 EQUAL BELOV ME LIFE GEMER RR AI S A GAANO TOTALS 0 00 2011 Cast amp Crew Entertainment Services LLC GENERAL LEDGER 231 Chapter 9 5 Additional G L Entry Screens PSL3 offers additional G L Ent
240. ry Screens which are listed below Open gt To access the following G L Screens click the G L module from the menu tree see following screen shot gt You can also access these screens by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter ii Budget ii Cost 3 Closing ji Recurring Batch 3 Report ii PSL3 Help To select criteria for the following screens press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields e Asset Disposition Maintenance Entry assetdis Use assetdis to find all transactions coded to A Assets or any other Free Field Code and provide the Method of Disposition description s This screen allows you to not only input the Method of Disposition next to items flagged as Assets but also input the Recovered Amount and Disposition Date Once entered and saved you can generate the Asset Recovery Report or Bible Report bdbr to display the reporting details Report Group Entry surpt Use surpt to customize your preferred Trial Balance Report gltb format This screen allows you to categorize and group together Account Types Assets Liabilities Capital Income and Expenses based upon a range of account numbers and Company Codes You are able to provide your own descriptions for each account grouping and select whether to include Control Accou
241. ry reference Vendor Number every vendor Employee Number every employee Select AP by Due Date if Vendor ID Vendor Name Enter a bank code I E To select criteria press the F2 Key or right click in most fields to make your selection You can also simply type in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank Bank Info e Bank Bank Code representing the bank to be used in the next check run By choosing a Bank Code the report displays only open A P items coded to the Bank Code selected e Currency Currency Code representing the currency to be printed in the next check run By choosing a Currency Code the report displays only open A P items coded to the Currency Code selected Please note if you have selected the Bank Code the Currency Code defaults as it is attached to the bank Selection Criteria e Press the F2 Key or right click in any of these fields Production Batch Number Reference Number Vendor Number and Employee Number to choose the necessary codes ifthey don t already default By making a selection this isolates the report to only 2011 Cast amp Crew Entertainment Services LLC 240 PSL3 User Manual display items based on the code s selected Date Selection e Select A P by Due Date Indicate if you want to restrict the A P open items included in the report to those that have a Due Date on or before the date entered
242. s are pulled from the Load Interface C amp C Payroll Invoice printr screen To change the defaulted codes you can press the F2 Key or right click in any of these fields Batch Production Company Bank and Currency and make your selection Invoice Information e Invoice Number Cast 8 Crew assigned invoice number generated from the Payroll Edit file If you forgot to write down the Reference Number assigned you can also bring up the Payroll transaction by pressing the F2 Key or right clicking in this field to choose from the list Payroll Information e Total Debits Total amount of the debit entries calculated in the distribution lines that defaults from the Payroll Edit file Please note you are not able to access this field e Total Credits Total amount of the credit entries calculated in the distribution lines that defaults from the Payroll Edit file Please note you are not able to access this field Entering a positive amount in the distribution lines Amount field increases the Total Debits field Entering a negative amount input a minus sign before the number in the distributions line Amount field increases the Total Credits field Debits and credits must equal before you can save the transaction Distribution Lines The distribution lines automatically default from the Payroll Edit file To make any necessary coding changes press the F2 Key or right click in most of these fields Account Series Location Set Insuranc
243. s denominated in one currency two three etc or all currencies To choose multiple Currency Codes press the F2 Key or right click in the field and hold down the Control Key while simultaneously using your mouse to select Each currency in your database and its conversion rate are listed in the report heading Target Currency Base currency set up in the System Control Information Entry suctri screen located in the Setup module defaults This Currency Code is what all transactions are converted to on the report Each currency in your database and its conversion rate are listed in the report heading Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format gt Spreadsheet Generates an Excel format report and appears instantly on your screen You are still able to print from the Excel format Please note if you select this option you are able to have additional sorting options within Excel Below is a sample Detail Trial Balance Report gltb broken down by Assets Liabilities etc containing one line Expenses 2011 Cast amp Crew Entertainment Services LLC GENERAL LEDGER 05 05 2011 TUE NEW SUCH DATARAGE Page 1 5
244. s the F1 Key then F option or select the Fetch icon e to fetch the account back to the Vendor Entry apven screen P C Advance Account Petty Cash Advance Account Number that automatically defaults in the P C Entry pcent distribution lines for this vendor Press the F2 Key or right click to 2011 Cast amp Crew Entertainment Services LLC VENDORS e select the account number If the account number doesn t exist in PSL3 you can add it by pressing the F5 Key or selecting the Zoom icon o located on the toolbar This zooms into the Chart of Accounts Entry glca screen in which you can add the account number immediately Once saved press the F1 Key then F option or select the Fetch icon G to fetch the account back to the Vendor Entry apven screen Please note this field only becomes accessible when the Petty Cash field above is check marked Tin Name Official name of the Tax ID holder if different from the Vendor Name field The TIN Name is used as the primary name for 1099 reporting purposes and the Vendor Name is used as the secondary name Please note if the Vendor Name and Tin Name are the same leave this field blank State Worked State the vendor or employee is currently employed for 1099 reporting purposes ICR 1099 Information e First Name MI Last Name Enter in how you would like the name to read for 1099 Independent Contracting Reporting purposes Helpful Hints v Make sure to
245. saction unposted and include the Reference Number s Please be advised depending on your specific studio s guidelines the Support Department may need to obtain approval from your Studio Finance Executive before proceeding NOTE Please note you are nof able to re print a Posting Register once the transaction s are posted therefore if you need a copy of the report sent to you please email a request to support castandcrew com with the approximate date and time that the report was ran PSL3 houses all generated reports on a server 2011 Cast amp Crew Entertainment Services LLC 194 PSL3 User Manual Chapter 8 4 Load Payroll Other Company The Load Payroll Other Company pr2psi program is used to load Payroll invoices generated from Payroll companies other than Cast amp Crew Production has the option to use a 3rd Party Payroll company for their extra s Payroll locally or when in another country Upon importing should your Payroll Data file encounter any errors e g illegal invalid account series location set etc this usually means that the file has codes that differ and or do not exist in PSL3 To correct this add the necessary codes in PSL3 then review the Edit List again or load the file with the errors and make the corrections in the Journal Entry jete screen Once the Payroll Data file is imported PSL3 creates a new unposted journal entry transaction which you can still modify before posting NOTE P
246. sary codes ifthey don t already default Some fields allow you to choose multiple codes for a particular field in which you can press the F2 Key or right click in that field and hold down the Control Key while simultaneously using your mouse to select By making a selection this isolates the report to only display items based on the code s selected Print Preview the Report Choose from the following options to generate the report gt Print Press the F1 Key then R option or select the Print icon to open the Print Dialogue box and send the report directly to the printer gt Preview Select the Preview icon 4 to generate a PDF format report which appears instantly on your screen You are still able to print from the PDF format 2011 Cast amp Crew Entertainment Services LLC 168 PSL3 User Manual Chapter 7 5 Import an Excel File The Import an Excel File xlint program allows you to import data from an Excel Spreadsheet into PSL3 as a transaction All Transaction Types P O A P P C J E and V A can be imported in this screen except Payroll transactions The transaction loads in to PSL3 with an unposted status therefore you are able to make any necessary modifications before posting NOTE Please note prior to the file import please see the following Excel template as to how to format and enter in data Please note the PSL3 Excel template contains a total of twelve columns A L including Free Fields 1 throu
247. scription AM AM American MDY EU European DMY IN International YMD e Bank Type Bank Type in which the checks for this bank will print Press the F2 Key or right click to view and select the Bank Type options along with their descriptions which are as follows ES Bank type Banktype Description US US United States CA Canada MX Mexico Check Printing Information e Check Form Input the form that matches the check stock you are using to print checks The most common Check Form is LASER A Check Form is needed before you can print checks so if you are not sure which Check Form to select it is suggested to select LASER for the majority of independent databases if needed the Support Department can make the necessary check alignment adjustments Press the F2 Key or right click to view and select the Check Form options along with their descriptions which are as follows 2011 Cast amp Crew Entertainment Services LLC MICR Bottom wPre Printed Cols MICR LASER FORM VISTA CHECK FORM NOTE Please note PSL3 is compatible with MICR Check Printing and has it s own Check Form MICRFM or MICRLA If you would like to have this feature set up please email support castandcrew com for more information e Prefix Character s usually a number to be printed at the beginning of all check numbers For example if the number 3 was input in this field and the next available check number to print was 000123
248. sheet efcws screen for your records Although PSL3 allows you to select any ofthe three previously mentioned options the result of entering an EFC or Variance in either Variance Entry bdve EFC Entry efcent or in the Cost Report EFC Worksheet efcws screen is exactly the same Open gt To access the Cost Report EFC Worksheet efcws click the Cost module from the menu tree see following screen shot gt You can also access this report by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter 2011 Cast amp Crew Entertainment Services LLC 5 Setup a AP a Pio a Pic sa JE a PR a GL 3 Checks aj Budget Ea Cost Cost Report efcrpt Cost Bible Report eferpt2 U EEE EEE EEE Average EFC Report avgefc Cost Detail Report costinff EFC Summary Variance Report efedifh Episodic EFC Report efeser EFC Entry efcent EFC Worksheet efcws Account Variance Report bdvar Reference Variance Report bdvep Closing 58 Recurring Batch 3 Report 5 PSL3 Help The screen then appears 2011 Cast amp Crew Entertainment Services LLC 312 PSL3 User Manual 1x O Budget Penod CUR Type PSL Standard F inactive Accounts Stat Date Detail F Budget Amount as Activity End Date ff Summary F Open kems as Actual Costs F Committed Costs F Subtotals Company El 0 M Detail M Detail F Detail From first expense Insura
249. sly using your mouse to select To run the report by a specific transaction type A P C K J E P C P O and or P R use the Source Code field By making a selection this isolates the report to only display items based on the code s selected Include Detail Check mark to include detail distribution data Inactive Accounts Check mark to include accounts that had no activity distributions posted to them during the period or date range selected or that have a zero dollar balance Beginning Balance is Activity Check mark to consider active accounts that have a non zero Beginning Balance Show Series Separation Check mark if you want transactions for each Series Code displayed separately If selected the report is broken down by account number then Series Code Location Separation Check mark if you want transactions for each Location Code displayed separately If selected the report is broken down by account number then Location Code if Series Separation is not check marked first Set Separation Check mark if you want transactions for each Set Code displayed separately If selected the report is broken down by account number then Set Code if Series and or Location Separation is not check marked first 2011 Cast amp Crew Entertainment Services LLC 222 PSL3 User Manual Multiple Currency e Source Currency If you have more than one currency in your database you can choose to include only transaction
250. ssessessesssssessessesnssssssssessessesacsaesaesnesnesnsseesseseesesacssessesnesnesesneseeseeaeeneess 13 ACCESSING AND LOGGING INTO PSL3 0 ccceeeeeee cnet ee ee cece nese ae ee nn annnnnnnnnnnnnnn anne nnnnn nenn 14 Opening the PSL3 Web Page cscsssssessssssssssesssssessessesessessesnsseessesessessessessessesneseeseeseeseeneesesnessesneseseeseeseeneenes 14 Loggingiin ii dsd 14 Selecting adatabas iii 15 UNDERSTANDING PROGRAMS AND COMMAND SCREENG ceeeeeeeeeeeeeeeeeeeeeeeeeeeeees 16 Program Menu Bar 0 u an 2a 16 ICONS AND SHORT CUTS cocina einen 18 TOON Dar NCO NSF ie 18 FunctioniKeys ii A it 19 Name Keys and Key Combinations nunususnsnsnsnnnnnnnnnannnnnnnannnnnnnnnnnnnnnanananananananannnananannanananananannnannanananann 20 SETUP 25 Bank Code Entra 26 Production Code Entry Po K ANASA ANNAA Enar ACEP aS T Anin ae Eea n ae KUSKE EE EEY 32 Company Code Entry naeh 35 Currency Code Enlry nal 38 Series Code Entiy it A At AA Nah ada aia a 42 Location Code Ent ada 45 Set Codes A TT 48 Additional Optional Setup ScreenS ooocconnccccnncconnnnnonennnnncnnnnnnnnncnnnnnnnnnrnnnnnrnnnrrnnnnrrnnnrenanenns 51 VENDORS 57 Vendor Enttty ivonne le ie 58 Vendor Listing ROD scission earra a a a aaa a aaa ada naasa iadan 65 Additional Vendor Screens ReportS ooccomnccconncoonnccconcconnncnoncnnnnncnnnnrnnnnennnnnnnnnrrnnnncrnnnrenanenes 69 PURCHASE ORDER 73 P O E aa 74 P O Edit
251. st ii Closing aj Recurring Batch ii Report 5 PSL3 Help E EE E E EEEE Et The screen then appears 2011 Cast amp Crew Entertainment Services LLC ACCOUNTS PAYABLE o ag B B B 2 DIE Number Batch EN Date if Production Description Company Status Bank Currency D State Worked Number Combine E Hold Name Date Due Date Number Amount Date tf Discount Amount ws PO Number Account Sers Locs Sets 9 in IFFI FF2 FFS FF4 Description Amount 3rd Transaction reference number Enter search criteria or add data a zi Reference Information e Reference Number System assigned number that is also referred to as transaction number To generate the next sequential Reference Number press the F4 Key or select the Add icon located on the toolbar You can also right click outside a field in which the Add option appears to add the next record Effective Date Date of the transaction that is recorded on the Bible Report bdbr and appears as an Actual Cost on the Estimated Final Cost Report efcrpt should default with today s date after generating the Reference Number You can always change it by typing over the defaulted date or by right clicking in that field for the calendar selection to appear Please note you can nof input a date that is in a previously closed period 2011 Cast amp Crew Entertainment Services LLC 2 PSL3 User Manual ce Pick a date NOTE Please emai
252. t Print Edit Opens the Print Dialogue box and sends the report directly to the printer gt Preview Edit Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format gt Import Opens the Print Dialogue box sends the report directly to the printer and begins the importing process Once you select Import and the report has printed PSL3 displays the following message prompt a Register printed Q i Has the report printed correctly If you select No PSL3 asks Would you like to reprint the register If you still select No the interface process is not done If you select Yes you will receive a secondary prompt confirming the Payroll invoice is now loaded in which PSL3 will provide you the Journal Entry jete Reference Number for this invoice With this new Reference Number you can still make any needed changes in Journal Entry jete before posting as it is created with an unposted status 2011 Cast amp Crew Entertainment Services LLC 1 PSL3 User Manual Chapter 8 5 Print Payroll Checks The Print Payroll Checks prckprnt screen allows you to print onsite location Payroll checks from the convenience of your own printer The Accountant is notified by email that the Payroll Check file is available to print from PSL3 Ifthis is your first time printing Payroll checks it is recommended to print a test Alignment to ensure that all check form fields
253. t Report Open gt To access the Bank Code Entry subank screen click the Setup module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter Bank E Batch Maintenance batchent Control AP suapetrl Currencies sucur Default Accounts suacct Employees pcemp Free Field1 sufree1 Free Field sufree2 Free Field3 sufree3 Free Field4 sufree4 Insurance suins Locations suloc Productions suprod Recurring Batch rbcre Company Code sucomp Report Group Entry surpt Series suser DataBase Info sudbinfo Sets suset States sustate Users suuser Change Password newpass Vendor Entry apven 5j Reports Control System suctrl Line Type Entry sulntyp The screen then appears 2011 Cast amp Crew Entertainment Services LLC gt a E B B a DIE Code Name Starting Branch Ending Address Last Used Contact Currency Phone Date Format Account Bank Type Check Form Prefix Cash in Bank Code AJP Clearing AP Discount PC Box PC Clearing Bank Code Enter search criteria or add data E Bank Information Code Input the code identifying the bank which can hold up to three alpha numeric characters After entering the new Bank Code PSL3 asks That Bank Code Entry is not in the database Would you like to add it Select Yes
254. t the Find icon CU located on the toolbar the transaction appears in which you can proceed with the necessary modifications from there Please note your are nof able to add or delete lines to a posted Journal transaction while in the Journal Entry jete screen 2011 Cast amp Crew Entertainment Services LLC JOURNAL ENTRY 155 After you make the necessary modification s make sure to save PSL3 creates a new unposted Journal Entry Reference Number reflecting the new distribution change s which is referred to as a Journal Entry WAS IS as the new transaction displays the WAS what the original transaction data was before being changed in the Journal Entry jete screen and S what the transaction data is now after the change s detailing the original distribution line values as well as what they reflect now PSL3 automatically updates the Reference Description of this new unposted Journal transaction to WAS IS FROM REF original Journal Entry Reference Number Please note you still have to post the new Journal Entry WAS IS transaction in the Post J E Transactions jepost screen Helpful Hints Y Make sure to input all white colored fields as white fields are required before saving in PSL3 Y To save this entry select either Save icon located on the toolbar Y You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and c
255. tch Number Frequency Frequency Code assigned to the recurring batch D Daily W Weekly M Monthly and Q Quarterly Upon selecting a batch in the Batch Number field the Frequency field defaults if you entered it in the Create Establish Recurring Batches rbcre screen Times Number of times the recurring batch is set up to process Upon selecting a batch in the Batch Number field the Times field defaults if you entered it in the Create Establish Recurring Batches rbcre screen Count Number of times the recurring batch has actually been processed PSL3 automatically calculates the Count field Process Check mark this option to process the recurring batch in the transaction entry screen in which it was originally created Process Batch gt To proceed with the recurring batch process press the F1 Key then P option or select Process Batch located in the top right hand comer of the screen PSL3 then displays the following prompt 2011 Cast amp Crew Entertainment Services LLC RECURRING BATCH 345 ce batch number Batch number for new Journal entries none Batch number for new AYP transactions 0110101 Batch number for new Purchase orders none Batch number for new Petty cash advances none Batch number for new Petty cash receipts none Batch number for new Per diems none Batch number for new Variances none Batch number for accounts payable transactions Please note you ca
256. te pl ff Start Date End Date if ti Edit List Closing Register Close Period Current period ending date a a Current Period e Start Date First date of the Current Period before the closing process Please note you can not access this field e End Date Last date of the Current Period should default to today s date but you can change it by typing over the defaulted date or by right clicking in that field for the calendar selection to appear lt lt lt January 2011 gt gt gt sun M Tue Wo Thu Fri Sat E 2109 4 a 16 8 e EA EN E dE RAE We ada er 23 24 25 26 27 28 29 30 31 OK Cancel help Next Period e Start Date First date of the Next Period before the closing process should default to the next date after the Current Period End Date Please note you can not access this field e End Date Last date of the Next Period This field can be left blank if you are not sure of the 2011 Cast amp Crew Entertainment Services LLC 334 PSL3 User Manual next time you are going to close the period WARNING Please be advised if you input an End Date in the Next Period section PSL3 does not allow you to input any transactions past the date entered in this field However if you need to remove this date block this can be done in the System Control Information Entry suctrl screen located in the Setup module then Reports sub folder by removing
257. tead To make any necessary coding changes press the F2 Key or right click in these fields and make your selection e Description Explanation for this distribution line which can hold up to 30 alpha numeric characters Employee Number Number of the employee who will receive payment This number is usually for your records only Amount Dollar or other currency amount for this distribution line Type over the debit or credit to change the amount If you are entering a negative amount input the minus sign before the number After making changes total debits must equal total credits In addition the invoice total and the total amount for each employee must stay the same Please note if you press the F2 Key or right click in the Amount field a calculator displays for your convenience 2011 Cast amp Crew Entertainment Services LLC 186 PSL3 User Manual ce Calculator Helpful Hints v Make sure to input all white colored fields as white fields are required before saving in PSL3 v To save this entry select either Save icon located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and clears the screen most common ec Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes x exit to menu v To add another distribution
258. ted weekly during production Initiate a program command to do something The original financial statement covering the period from the beginning of the production to the current reporting period Usually refers to a manually produced check that was typed on a typewriter not printed by the computer system See also manual check A program feature that is not available for use and typically is colored gray An individual working for a company that is contracted to perform certain services in which the individual does not take direction in how the services are to be provided a person performing work that does not require supervision or direction See also employee An occurrence of using a program You may run concurrent instances of the PSL3 program that is you may have more than one copy of the program open An entry made to a journal that represents a transaction The bank used by a production on location may have correspondent banking relations established with home office bank used primarily for payroll check cashing 2011 Cast amp Crew Entertainment Services LLC GLOSSARY 353 Checks which have been typed or handwritten rather than generated by the computer manual check nickname system See also hand typed A short alternative name for PSL3 programs usually eight or fewer characters petty cash pick list post production The distribution of cash to individuals on a production for various expenses A po
259. the P C vendor s Advance Account The second automated distribution lines displays the account number for the P C Box Custodian set up in the Bank Entry subank screen crediting the P C Box Custodian s account Accounted for Amount Total amount total cash receipts that is being received from the P C Vendor After inputting the Accounted for Amount PSL3 automatically creates one distribution line The automated line displays the Advance Account Number for the P C Vendor set up in the Vendor Entry apven screen Amount Distributed Read only field that sums the amounts coded to Expense Account Numbers in the distribution lines As you enter amounts coded to Expense Accounts this field totals those amounts The Amount Distributed must equal the Accounted for Amount before you can save the P C Entry pcent transaction Please note you are not able to access this field Distribution Lines PSL3 automatically creates distribution line s once you enter an amount in the Amount Advanced and Accounted for Amount fields e First Amount Advanced Distribution Line This automatically created distribution line is created if you enter an amount in the Amount Advanced field lt displays the Advance Account Number for the P C Vendor set up in the Vendor Entry apven screen the debit from the P C vendors Advance Account Second Amount Advanced Distribution Line This automatically created distribution line is created if you enter an amount
260. the original transaction Also please be advised there is not an Audit Trail when using the Posted Transaction ltem Editor glfix Helpful Hints v Make sure to input all white colored fields as white fields are required before saving in PSL3 v To save this transaction select either Save icon located on the toolbar v You can also press the F1 Key then U option to Update which saves and remains on screen or press the F1 Key then A option to Accept which saves and clears the screen most common ee Command Command U Update database with changes A Accept changes and clear screen C Cancel discard changes x exit to menu v To add another distribution line press Enter or Tab where the last line was entered v To insert a distribution line in between already existing lines place your cursor where you want to add and press the F4 Key or select the Add icon A new line is added beneath v To delete a distribution line place your cursor in the line you want to delete and press the F10 Key or select the Delete icon fu A red strike through line appears which is deleted upon saving v To search for an existing entry press the F7 Key or select the Find icon Ey when the screen is clear All records appear in which you can scroll through using the Arrow icons First Prior Next and Last O l O or by pressing the Page Up or Page Down Keys until you find the entry needed 2011
261. to access the following fields Check Number Number of the check Effective Date or Check Date Effective Date of the transaction or check Type Types include Dep Deposit and Cmp Computer Check Reference Number Reference Number of the transaction Reference Description or Vendor Name Reference Description of the transaction or name of the vendor or payee Amount Amount of the transaction 2011 Cast amp Crew Entertainment Services LLC 260 PSL3 User Manual Before proceeding with the reconciliation process PSL3 provides you a variety of reporting options Summary Worksheet Edit etc to viewthe Bank Reconciliation details which are located in the right hand comer of the screen In addition PSL3 also provides the option of Reconciling Items which is a screen that allows you to input the description and amount of an item s in the event the Bank Reconciliation does not balance You can delete the reconciled item s once it actually processes Reconcile To proceed with the reconciling process press the F1 Key then R option or select Reconcile located in the right hand corner of the screen This opens the Print Dialogue box and begins the reconciling process Once you select Reconcile PSL3 displays the following message prompt ES Printed Correctly Has the report printed correctly If you select No PSL3 asks Would you like to reprint the register If you still select No
262. to input all white colored fields as white fields are required before proceeding in PSL3 Account Numbers Create New Accounts Check mark this option to create new account numbers from the budget you are importing Imported budget line account numbers that do not exist in the Chart of Accounts or that exist in the Chart of Accounts but do not exist in the Budget Name you are importing will be copied into the budget Ifthe Create New Accounts box is left unchecked PSL3 will not create new account numbers from the budget as there may already be a Chart of Accounts for this Production If you print the Edit List the newly created account numbers are identified as NEW if left unchecked the report identifies the account numbers as ACCOUNT NON EXISTENT ignored Process Duplicate Budget Amounts If the Budget Name exists and already has budget lines but you are importing additional budget lines you must tell PSL3 what to do wth budget amounts if the import file contains account numbers that duplicate the existing account numbers Otherwse if this is a new Budget Name leave the default setting as is nothing will be affected Masks Combine Add import file budget amounts to existing budget amounts The result is the sum of the import file budget amounts and the existing budget amounts Replace Replace the existing budget amounts with the import file budget amounts The result is the import file budget amounts Preserve Leav
263. to wid To void a single Check Reference Number enter the same number in both the From and To Reference Number fields Generally you would use the Check Number fields to void checks and leave the Reference Number fields blank except in the instance there were duplicate Check Numbers and you wanted to wid only one of those checks If you entered a Check Number to void all checks with that number would be voided however if you entered a Check Reference Number only one of the duplicate Check Numbers would be voided For example ifin A P Entry apte you entered the same Manual Check Number to pay two separate A P transactions and then posted those A P transactions this Manual Check Number would have two different Check Reference Numbers associated with it If you wanted to void only one ofthose checks you would need to enter the Check Reference Number not just the Check Number To view a check s Reference Number you can run the Check 2011 Cast amp Crew Entertainment Services LLC CHECKS 251 Inquiry Report cking located in the Checks module The Check Reference Number is displayed in the header section Void or Reissue e Void Checks Select this option to void the selected Check Number s which changes the original check s status to V oid It also creates a new reversing check record that has the effect of canceling the original check which is created in the Current Period This reversing check record is a duplicate of the ori
264. transactions posted NOTE Please note if you need to make distribution changes to posted items this can be done in the Posted Transaction ltem Editor glfix screen located in the J E module depending on your User ID and studio permissions You can also email a request to support castandcrew com if you need a transaction unposted and include the Reference Number s Please be advised depending on your specific studio s guidelines the Support Department may need to obtain approval from your Studio Finance Executive before proceeding 2011 Cast amp Crew Entertainment Services LLC ACCOUNTS PAYABLE 103 NOTE Please note you are nof able to re print a Posting Register once the transaction s are posted therefore if you need a copy of the report sent to you please email a request to support castandcrew com with the approximate date and time that the report was ran PSL3 houses all generated reports on a server 2011 Cast amp Crew Entertainment Services LLC 104 PSL3 User Manual Chapter 5 3 Defer Open Items The Defer Open Items ckdef program allows you to defer an open A P or P C transaction payment from your next check run The Defer Open Items ckdef screen also allows you to change a transaction s A P Discount Amount or A P Due Date You can also determine if an open item has been deferred if you enter the open item s Reference Number and press the Enter Key Open gt To access the De
265. u can not access this field e Total Marked for Export Displays the total dollar amount marked for export for the selected Card Number s Please note you can not access this field Start to populate data gt To proceed with the exporting process press the F1 Key then S option or select Start located in the top right hand corner of the screen Once you select Start the transaction details at the bottom of the screen are displayed You are then able to mark a transaction for export and select the account number and Envelope Number if any P Card Transaction Details Export Check mark to indicate that a given line item should be part of the A P Entry apte or Import an Excel File xlint export process Account Number Chart of Accounts number associated with a given transaction Press the F2 Key or right click to choose the account number If the account number doesn t exist in PSL3 you can add it by pressing the F5 Key or selecting the Zoom icon a located on the toolbar This zooms into the Chart of Accounts Entry glca screen in which you can add the account number immediately Once saved press the F1 Key then F option or select the Fetch icon 6 to fetch the account back to the P Card View Re port pcardlp screen Envelope Number User defined code or number associated with a given transaction to correspond with receipts submitted to the accounting office This field can hold up to eight alpha numeric
266. u can not input a date that is in a previously closed period 2011 Cast amp Crew Entertainment Services LLC PETTY CASH 1 25 ec Pick a date lt lt lt January 2011 ale Goji 17 18 19 20 21 22 NOTE Please email a request to support castandcrew com if you need a transaction s Effective Date changed and include the Reference Number s Please be advised depending on your specific studio s guidelines the Support Department may need to obtain approval from your Studio Finance Executive before proceeding e Description Explanation of this P C transaction as a whole which can hold up to 30 alpha numeric characters e Status Overall status of the transaction This field is marked with a U for an Unposted entry until you post it in the Post P C Transactions pcpost screen As long as the transaction is marked with an unposted status you are able to modify it Once posted it is marked with a P for Posted PSL3 updates the status automatically NOTE Please email a request to support castandcrew com if you need a transaction unposted and include the Reference Number s Please be advised depending on your specific studio s guidelines the Support Department may need to obtain approval from your Studio Finance Executive before proceeding 2011 Cast amp Crew Entertainment Services LLC 126 PSL3 User Manual Batch Information e Codes that are attached to the transactio
267. ultaneously using your mouse to select By making a selection this isolates the report to only display items based on the code s selected e Employee Sort Order Check Sort Order and Format are all sorting options available for you to select per your preference Multiple Currency Source Currency If you have more than one currency in your database you can choose to include only transactions denominated in one currency two three etc or all currencies To choose multiple Currency Codes press the F2 Key or right click in the field and hold down the Control Key while simultaneously using your mouse to select Each currency in your database and its conversion rate are listed in the report heading Target Currency Base currency set up in the System Control Information Entry suctri screen located in the Setup module defaults This Currency Code is what all transactions are converted to on the report Each currency in your database and its conversion rate are listed in the report heading Print Preview the Report Located in the top right hand corner of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still 2011 Cast amp Crew Entertainment Services LLC PAYROLL 203 able to print from the PDF format
268. ultiple Currency etc as selection criteria Cost Detail Report costinff Use costinff to run costs by Insurance Free Field s Series Location or Set Codes This report can include P O s and can be ran by a range of Accounts Start and End Dates Multiple Currency etc as selection criteria EFC Summary Variance Report efcdiff Use efcdiff to view the Estimated Final Costs that have changed during the given period summarized to the Header Controlling Account Level This report includes the following columns Account Number Description Previous EFC Variance and Current EFC Episodic EFC Report efcser Use efcser to generate a report of EFC s by episode such as a recurrent television show This report can be ran by Series Start and End Dates Multiple Currency etc as selection criteria Reference Variance Report bdvep Use bdvep to print a list of Variances entries for one date or for the entire reporting period sorted by Account Order or Entry Order This report can be used in conjunction with the Bible Report bdbr to show how and why account balances do not match the budgeted amounts NOTE The reports are available in either Print Preview and or Spreadsheet formats NOTE Please email support castandcrew com if you don t see a specific PSL3 report currently listed as an option in your database 2011 Cast amp Crew Entertainment Services LLC POL CLOSING D CLOSING 331
269. umber Batch Eff Date Production Descr pbon Ompany Status Currency ID State Worked P O Number P O Amount Name Expiry Date Remaining P O Type Account Sers Locs Sets 9 n FFIIFF2IFF3 FF4 Description Amount St 24d Transaction reference number Enter search criteria or add data A at Reference Information e Reference Number System assigned number that is also referred to as transaction number To generate the next sequential Reference Number press the F4 Key or select the Add icon located on the toolbar You can also right click outside a field in which the Add option appears to add the next record Effective Date Date of the transaction that is recorded on the Bible Report bdbr and appears as a Committed Cost on the Estimated Final Cost Report efcrpt should default with today s date after generating the Reference Number You can always change it by typing over the defaulted date or by right clicking in that field for the calendar selection to appear Please note you can nof input a date that is in a previously closed period 2011 Cast amp Crew Entertainment Services LLC PSL3 User Manual cc Pick a date lt lt lt January 2011 HE Goji 17 18 19 20 21 22 NOTE Please email a request to support castandcrew com if you need a transaction s Effective Date changed and include the Reference Number s Please be advised depending on your specific studio s guidelines the Support De
270. umn headers Name City or Vendor to sort alphabetically or numerically If the vendor does not exist in PSL3 you can add it by pressing the F5 Key or selecting the Zoom icon o located on the toolbar This zooms into the Vendor Entry apven screen To search for a vendor while zoomed into the Vendor Entry apven screen type the wildcard character using the asterisk in the Vendor Name field For example if you want to see if vendor John Smith exists you would type John or Smith and press the F7 Key or select the Find icon Q located on the toolbar PSL3 displays how many records for that criteria exist by selecting the Arrow icons First Prior Next and Last l l O located on the toolbar or by pressing the Page Up or Page Down Keys until you find the vendor needed Once you locate the vendor press the F1 Key then F option or select the select the Fetch icon e to fetch this record back to the P O Entry poent screen P O Information e P O Number Number of the P O which can hold up to ten alpha numeric characters depending on your studio usually production assigned The P O Number is used in A P Entry apte to transfer the P O lines Expiry Date Date by which the goods ordered by the P O should be received this date should appear on the P O If the goods haven t been received by this date and the P O is still Open the P O would be considered past due P O Type User defined code to track
271. unts Listing Report gt Trial Balance Report gt Bible Report gt Additional G L Entry Screens gt Additional G L Inquiries and Reports 2011 Cast amp Crew Entertainment Services LLC 210 PSL3 User Manual Chapter 9 1 Chart of Accounts Entry Chart of Accounts is the master list of all account numbers used to track Production costs including Assets Liabilities Capital Income and Expenses The Chart of Accounts Entry glca screen is used to set up Chart of Accounts search for account numbers and add delete modify accounts Setting up your Chart of Accounts accurately is one of the most important functions in PSL3 If the account numbers are set up correctly then the reports generate properly and are placed in the correct category Type Line Post and Sub Many users create their Chart of Accounts through the Import a Budget screen located in the Budget folder in which there is an option to Create New Accounts Please be advised that PSL3 only imports budget files from EP Movie Magic Budgeting and only accepts dsc or txt file formats Please note PSL3 does not allow more than one Chart of Accounts per database NOTE Please email a request to support castandcrew com if you would like the PSL3 Import a Budget from EP Movie Magic Step by Step Guidelines emailed to you In the Import a Budget bdint screen the option to Create New Accounts is displayed Also please email a request to support c
272. using the Arrow icons First Prior Next and Last l or by pressing the Page Up or Page 2011 Cast amp Crew Entertainment Services LLC ACCOUNTS PAYABLE Down Keys until you find the entry needed 2011 Cast amp Crew Entertainment Services LLC os PSL3 User Manual Chapter 5 2 Post A P Transactions Edit List Use the Post A P Transactions Edit List appost screen to review and post A P transactions You can post transactions one at a time or all transactions at the same time if you prefer It is recommended to first generate an Edit List a list of the transactions you ve selected prior to posting The purpose of the Edit List is for you to review the A P transactions for any errors as well as to make sure the transactions listed are indeed the ones you want to post You can print the Edit List or view it straight from your screen If you need to make any corrections do so in the A P Entry apte screen After accepting the changes generate another Edit List to verify the corrections Once you re satisfied with the changes move forward with the Posting Register Posting is the act of permanently transferring a transaction to the Bible Report General Ledger bdbr Please note checks are posted automatically when they are printed Open gt To access the Post A P Transactions Edit List appost screen click the A P module then click the A P Entry sub folder from the menu tree see followin
273. ution field then press lt Page Up gt or lt Page Down gt to go through the distribution lines one page at a time Move your cursor one character left or right Move the cursor up or down the column of distribution lines Move the cursor back one field Move the cursor back one field Blank out a field Deletes the character to the left of the cursor Restore the previous value of the field Cursor must not leave the field between the entry and the restore SETUP SETUP 25 Section 2 SETUP This section will address the following programs gt Bank Entry gt Production Code Entry gt Company Code Entry gt Currency Code Entry gt Series Code Entry gt Location Code Entry gt Set Code Entry gt Additional Optional Setup Screens 2011 Cast amp Crew Entertainment Services LLC 26 PSL3 User Manual Chapter 2 1 Bank Code Entry Use Bank Code Entry subank to set up a Bank Code for each bank account you intend to use during Production This screen is also where you can set up a Petty Cash Bank if needed The data you enter in the Bank Code Entry subank screen can be changed at any time except that the Bank Code itself can not be changed Please note a Bank Code record can not be deleted once it has been used in PSL3 If you would like to print a list of all Bank Codes entered in the database click the Report module then Setup amp Maintenance sub folder Listed is the Bank Codes Lis
274. where the information will be printed and make the necessary adjustments accordingly NOTE Please email a request to support castandcrew com to have your scanned check alignment adjusted You can also fax us a copy at the following number 818 848 4780 Please be sure to send an email or call to let us know you have faxed the check copy in Once you have selected Print PSL3 will take you through a series of prompts to ensure you are printing the desired checks and choosing the correct printer which are in order as follows ec Warning A If necessary replace plain paper with check stock now 2011 Cast amp Crew Entertainment Services LLC 246 PSL3 User Manual ee Items Selected Checks Lines Open tems Extra Stubs Forms Needed cc Information L You are about to print checks in check run 57 1 check FB Print ckprnt Senerai Page Setup Appearance Print Service Name HP LaserJet 4240 PCL_cesip6 Pere Status Accepting jobs FT Print To File Copies Number of copies 15 2011 Cast amp Crew Entertainment Services LLC IMPORTANT Window Message e Once the checks have printed the last prompt you will see is the IMPORTANT window Since the checks in PSL3 print before the check data is saved to the database the IMPORTANT Window gives you the opportunity to verify that the checks actually printed correctly Until you go through all ofthe previous dialogue boxes and
275. which you can scroll through using the Arrow icons First Prior Next and Last l l l O or by pressing the Page Up or Page Down Keys until you find the code needed 2011 Cast amp Crew Entertainment Services LLC 3 PSL3 User Manual Chapter 2 4 Currency Code Entry Use Currency Code Entry sucomp to set up a Currency Code for each currency you intend to use during Production A Currency Code record includes the exchange rate so reports can be printed in both local currency and base currency Please note a Currency Code record can not be deleted once it has been used in PSL3 If you would like to print a list of all Currency Codes entered in the database click the Report module then Setup amp Maintenance sub folder Listed is the Currency Codes List Report Open gt To access the Currency Code Entry sucomp screen click the Setup module from the menu tree see following screen shot gt You can also access this screen by typing the screen or acronym name in the blue prompt bar located above the Setup menu Then press Enter Setup Banks subank Batch Maintenance batchent Employees pcemp Free Field1 sufree1 Free Field sufree2 Free Field3 sufree3 Free Field4 sufree4 Insurance suins Locations suloc Productions suprod Recurring Batch rbcre Company Code sucomp Report Group Entry surpt Series suser DataBase Info sudbinfo Sets suset Stat
276. wide using a web browser such as Internet Explorer Mozilla Firefox etc Opening the PSL3 Web Page Opening the PSL3 web page for your PSL3 database Start by opening the PSL3 web page in Internet Explorer using the internet address User Name and Password supplied by the Support Department via email You may want to add the web address to your browser s list of Favorites for easy access For example Welcome to Tabbed Browsing Windows Internet Explorer SA v e https studio castandcrew com File Edit View Favorites Tools Help SADA DS O ASS AAA SOSA As To access your PSL3 database Type this address in the address field of your internet browser and press Enter The first time you visit the PSL3 web site a screen appears asking whether you want shortcuts created PSL3 burpsiga1 Create shortcut s A Would you like to create desktop and start menu shortcuts For PSL3 burpsiqal If you choose to create shortcuts the next time you want to access PSL3 you can double click the shortcut on the Desktop or click the PSL3 Start menu item as shown in the following example fa Cast and Crew PSL3 burpsigai Logging in You ll need a User Name and Password to access PSL3 which is supplied by the Support Department via email Upon logging in to PSL3 you have the option to change your Password in the Change Password newpass screen located in the Setup module 2011 Cast amp Crew Entertainment Services
277. y position and contact information Cast amp Crew Website Info To learn more about Cast amp Crew and all it s services including PSL3 Support please visit the following website https www castandcrew com 2011 Cast amp Crew Entertainment Services LLC HOW TO USE THIS MANUAL 13 PSL3 System Requirements Recommended System Requirements for PSL3 Client Computers Hardware Intel Pentium 4 GHz Processor or higher Video Processor with minimum 128MB Video Memory Minimum 2 GB RAM 80 GB Free Hard Drive Space larger databases may need additional storage for reports Software Operating System Windows XP Pro 32 bit Windows Vista and Windows 7 Java Version 1 5 07 Web Browser Internet Explorer 7 0 or later Mozilla Firefox 7 0 or later Internet Access choose one of the following Broadband Internet Service Provider DSL or Cable Modem Dedicated Internet Access Corporate LAN providing at least 128 kbps throughput for the PSL3 Workstation Printer For a complete list of compatible printers please email support castandcrew com or contact the Support Department at 818 848 0999 For magnetic MICR Check Printing use MICR toner for On Site Check Printing USB Printers not supported 2011 Cast amp Crew Entertainment Services LLC 4 PSL3 User Manual Chapter 1 2 ACCESSING AND LOGGING INTO PSL3 PSL3 is a completely internet based system that can be accessed world
278. your company s different classifications of P O s which can hold up to 3 alpha numeric characters This field is similar to a Free Field Code in that you determine your own codes for each P O Type Please note P O Types do not appear as search criteria in the Bible Report bdbr as they only appear in the P O Edit List poedtl and P O Report poentp Amounts e P O Amount Dollar or other currency amount due for the P O e Amount Remaining Dollar or other currency amount of the P O distribution lines that have not been Closed Transferred or Relieved in other words this is the amount remaining to be relieved e Amount Distributed Dollar or other currency amount that should match the Amount Remaining Please note you are not able to access this field Distribution Lines 2011 Cast amp Crew Entertainment Services LLC PSL3 User Manual e Account Number Chart of Accounts number that will be debited or credited on this distribution line Press the F2 Key or right click to choose the account number If the account number doesn t exist in PSL3 you can add it by pressing the F5 Key or selecting the Zoom icon a located on the toolbar This zooms into the Chart of Accounts Entry glca screen in which you can add the account number immediately Once saved press the F1 Key then F option or select the Fetch icon e to fetch the account back to the P O Entry poent screen NOTE The Series Location Set and Fre
279. ype A B C D E F G Only Expense Accounts have a Line Type Allow Posting Indicate Y N if you want to include only account numbers that can have transactions posted to them Sub Account Indicate Y N if you want to include only Sub accounts or only Header and Standalone Accounts Subtotal Level Indicate if you want to include only accounts with a specific Level Ifso enter a number between 0 through 9 e Integrity Check e Integrity Check Only Check mark this option to view if there are any errors or formatting issues within your Chart of Accounts Selecting this option will generate the Chart of Accounts Integrity Check Report in which the errors are display in bold if any Print Preview the Report Located in the top right hand comer of the screen you can choose the following options to generate the report gt Print Opens the Print Dialogue box and sends the report directly to the printer gt Preview Generates a PDF format report and appears instantly on your screen You are still able to print from the PDF format gt Spreadsheet Generates an Excel format report and appears instantly on your screen You are still able to print from the Excel format Please note if you select this option you are able to have additional sorting options within Excel 2011 Cast amp Crew Entertainment Services LLC 218 PSL3 User Manual Chapter 9 3 Trial Balance Report The Trial Balance Report gltb
280. ype in the criteria in the allotted fields If you wish to include all criteria information leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3 Check Information Company Company Code representing the company to be used in the check run Bank Bank Code representing bank to be used in the check run Currency Currency Code representing the currency to be printed in the check run Please note if you have selected the Bank Code the Currency Code defaults as it is attached to the bank Starting Check First check number in which the check run will begin The check number should default upon selecting the Bank Code but you can change it The Starting Check Number Information is pulled from the Bank Entry subank screen if it has been setup Check Date Date that will print on the check s should default to today s date You can always change it by typing over the defaulted date or by right clicking in that field for the calendar selection to appear Please note you can nof input a date that is in a previously closed period 2011 Cast amp Crew Entertainment Services LLC 24 PSL3 User Manual ce Pick a date lt January 2011 e Allow ZERO Checks to Print Check mark this option if you want to print zero dollar amount checks NOTE Please email a request to support castandcrew com to have the Allow ZERO Checks to Print option automatically

PSL3 User Manual - Cast & Crew Entertainment Services

Contents

Download Pdf Manuals

Related Search

Related Contents

PSL3 User Manual - Cast &amp; Crew Entertainment Services

Contents

Download Pdf Manuals

Related Search

Related Contents

PSL3 User Manual - Cast & Crew Entertainment Services