Working with Borrowing Base Certificates
Contents
1. Click Save 9 Verity the File Name and File Format Tab delimited Click OK 10 Click on the Print button Page 22 ShyhetLni Uso Mara We will use the Accounts Receivable Aging Report as an example 1 ick on Reports gt Accounts Receivable 2 Choose Aged Receivables under Report List 3 Click on the EXCEL button 4 Make any necessary changes on the Aged Receivables window Click OK 5 Accept the default to create a new Microsoft Excel workbook and click OK amp Peachtree will start the automatic export of the aging to an Excel spreadsheet and start Excel ShyhetLni Uso Mara How To Print A Report To A File In Peachtree cont 7 The Excel spreadsheet will be formatted similar to the one below ick on Format gt Style 9 In the Style window uncheck all boxes except for Font 10 Click on the Madify button Page 24 ShyhotLni Uso Mara How To Print A Report To A File In Peachtree cont lick the Font tab and then change the font to Courier New and click OK 18 Type in the filename ARAging and then the aging date in the format MMDDYY ie zARAGing030302 In the Save as type list click Formatted Text Space Delimited Click Save Page 25 How To Print A Report To A File In QuickBooks We will use the Accounts Receivable Aging Report as an example 1 Glick on Reports 2 In the Report Finder window choose Customers2. amp Receivables Select A R Aging Detail in the report list 3 Click on the Modify Report Giition to change add report options 4 Make any necessary changes to the report format Please refer to the A R Detail file layout for required fields 5 Click OK c 08 Sza How To Print A Report To A File In QuickBooks cont amp Click on the Display button to preview the report 7 Check the report and resize the columns as necessary To change the size of a column point the cursor at the small diamond to the right of the column Drag the small diamond to the left or right to adjust the column width In the example the Name column needs to be adjusted to show the full address 8 Click on the Print memes SE eal rau button per fran CEEE Rock Caste Construction m AIR Aging Detail Mon mem Page 27 Sueset Link User Manual How To Print A Report To A File In QuickBooks cont 9 In the Settings tab choose File as the printer option Accept the default setting of ASCII text file 10 Click Print 11 Type in the filename ARAging and then the aging date in the format MMDDYY i e ARAging030302 In the Save as type list accept the default Text txt Click Save Foo e pe iea EST B enr Study Link User Mara General Print to File Instructions These instructions will help you set up a Text Only Printer which will allow you to print reports t
3. browser s File menu to save the report to a file You can also Copy and Paste reports from your browser into other programs like Microsoft Excel or Word edge fe tn 1 When the report you want is on screen click your mouse on the upper lett comer of the report Holding the mouse button down drag to select the part of Ine report you want fo copy Your selection will be highlighted when iis selected 2 Click Edit gt Copy trom your browser menu or right click on your selection and click Copy from the context menu 3 Switch to the program or document you want to paste the data into on the point in the document where you want the data to be displayed 5 Click Edit gt Paste from the program s menu or right click on the document and click Paste in the context menu Page 32 fter you have successfully pasted the data into the new document you can save the document lor later use reformat it the way you d like to see it print it from the new program or use the pasted data to do calculations Eug x ie ee ee pp c tee armon Aden net Ca ees Du Sir SEIEN vu wrurg um Bs SEES ma Ei 3s Bur Sent Em kefen a eee eaa ens a AEE P EA E EE M UE Page 3 Uploading Files Click on Upload Files from the StuckyNet menu Click on the Browse button to the right of the type of file you will upload Monthiy sexe 0 Cia
4. StuckyNet Link User Interface Manual Contents Introduction Technical Information General Information Logging In e Session Timeout Changing Your Password Working with the Borrowing Base Creating a New Certificate Editing a Saved Certificate Deleting a Saved Certificate Pending Status of a Certificate Viewing a Pending Certificate Reviewing Historical Certificates Calculating Availability Reports Saving Reports e Loan Ledger Report Loan Status Report Ineligible History Printing Reports Uploading Supporting Documentation Uploading Files Uploaded Files History AR Aging File Specifications Extracting Data From Popular Accounting Packages AccuBooks Business Works Microsoft Excel Microsoft SEM Peachtree QuickBooks General Print to File Instructions Page Introduction StuckyNet Link offers you 24 hour access to your current loan status ledger and ineligible balances through a user friendly web interface Additionally the system enables you to complete your borrowing base posting online and frees you from the costly burden of printing packaging and shipping back up reports saving you hundreds of dollars per month If you ve used the Internet before you will immediately feel comfortable navigating your way through your loan information in StuckyNet Link All the familiar web elements are here from menus and hyperlinks to tables and forms We want
5. dices tasse Femeie iia a cie In the Look in box click on the drive or folder containing the file Highlight the file you want to upload and click Open The filename will appear in the field of the file type In the sample below an AIR Aging file will be uploaded to the system pese fare al tal Daly esee at cook teen i shen Regoes i Monthly ay aging I nan i M opis post Page da amp Click the Upload button 7 status bar on screen will let you know that the files are being uploaded Make sure to wait while your files are uploaded If you navigate to a diferent page or close your browser the file upload will be cancelled 8 A list of all the files uploaded will be displayed after a successful file transfer Files uploaded successfully e s 1 Page 5 Stupor Lik Uso Mara Upload History Upload history shows the names of the supporting documents that you ve uploaded using StuckyNet Link Upload History m ED me f 1 Click on Upload History on the StuckyNet menu 2 Use the default dates to display a current report or select new from to dates 3 Click Show Report to display the report in your browser Upload History Daily Files er rl cer ense haerere tenes eorn escnensan seta Taco arro Ge Tiao avene Monthly Files a Fecerunt musei Please provide the following information for the A R Aging f
6. e hyperlink for the posting you wish to review The certificate will be displayed in a non editable format Page 8 Calculating Availability New Collateral Balance Collateral Balance Sales Additions Credit Memos Adjustments Cash Removals Discounts Non AR Cash New Net Collateral Lesser Of 1 New Collateral Balance Ineligibles Advance Rate Reserves 2 Collateral Limit Total Collateral Lesser Of 1 Sum of all New Nat Collateral fields 2 Revolving Limit Sum of non revolving New Net Collateral fields 3 Total Line Limit Collections Cash Removals New Loan Balance Sum of Loan Balances Collections Advance Request New Availability Total Collateral New Loan Balance The availablity calculation may involve factors not listed here If his formula does not give you the same availability number as your borrowing base or loan status report contact your collateral analyst Page 8 Loan Status Report Loan Status LL x c o c memo AF uso soms com amssssse 0m zenpoooo OUDORS teatro 1718A2556 Tos am cer aomu tagean ayazma am ique oss O veaenma O ataa The loan status report is an overview of all the loans in your account as of the last time the system data was updated This report does not include any pending or saved borrowing base certificate information in its calculations Loan Ledger Report Displays the line item ledger of activity for eac
7. g me CEeeemwo wow pa E The certificate number can be from one to six characters The certificate number must be unique If you duplicate a certificate number you will be prompted to enter a new number The certificate number can only contain alphanumeric characters Unacceptable characters will be changed to a dash character One recommended format for the certificate number is to use the date in the form of mmddyy e g use 112502 for Nov 25 2002 Enter the date of the certificate or use the calendar button E to select a date Entering an invalid date wil cause the date to be recorded as the current date Click the New Certificate button A blank certificate will be displayed Leang Tyre BL MEL senses P ede Nenos I q aiai rd e coas a ae ceu Newcomer 24 00000 22 060 00 The text fields with a gray background are for your data entry Text fields with a white background are calculated If you type over a calculated field it will revert back to its original value The beginning balances on each certificate are pulled directly from the most recently updated data and do not reflect any other saved or pending borrowing base certificates Use the Tab key to move between text fields If you hit the Enter key instead of Tab your borrowing base posting may be submitted accidentally If you submit the posting before you are finished just open the borrowing base again in edit made
8. h loan in your account This report often requires Landscape mode when printed Loan Ledger we SN E Tabu mes A 1 Click Loan Ledger Report from the menu 2 Selectihe Loan Number you want to view the ledger for 3 Use the default dates to display a current report or select new from to dates 4 Click Show Report to display the report in your browser Loan Ledger vun om 18 listor Displays the ineligibles and reserves for each loan in your account Ineligible History annie ag me maus 1 em Waws 1 1 Click Ineligible History from the menu 2 Select the Loan Number you want to view the ineligibes for 3 Use the default dates to display a current report or select new fronito dates 4 Click Show Report to display the report in your browser Ineligible History The header columns for this report are based on the most recent ineligible reserve postings for your account The column headers will match the latest neligible reserve figures posted but might not match older rows seni nat Printing Reports Each reportincdesa Printbuton BB in the top ight comer of the raport screen Use this button to send the current frame to the printer Depending on your browser type and peinter modal some printad raporte may eut of the rightmost part of the screen If you have a problem set your printer orientation to landscape mode before printing Saving Reports Click Save As in your
9. iles Customer Information Customer Number Customer Name Street Address Ciy State Zip Code Telephone Number Items 1 and 2 are required AR Aging Information 1 Customer Number 2 Invoice Number 3 Invoice Date 4 Due Date 5 Transaction Type 6 POR 7 Transaction Amount All items except Item 6 are required Page a7 How To Print A Report To A File In Accubooks We will use the Aging Report as an example 1 Click on A R gt Reports gt A R Aging Report eta UM Me EA DE ag A PM Dat Fur Ge fat in Sh Dae Wom S PENGUN ori e anata 1 2 Inthe A R Aging Report window choose the third button on the Send Output To section to print to a file 3 Type in ARAging ark the date of the aging report in MMDDYY format i ARAging030502 txt Use txt as the extension for the filename Click OK Page 8 ShyhetLnk Uso Manual How To Print a Report To File In BusinessWorks We will use the Aging Report as an example 1 Click on the Accounts Receivable button Click on Reports gt Aging Report 2 Click on the Print Device button 3 Click on File and type in a filename CARAging txt then click OK to export the report to a flat file Page 29 Sight Uso Mara How to Export Data from an Excel Worksheet The flat file format is used to create text fles that can be opened in most other programs For example this format is required by mainframe programs and is often necessar
10. o a text file 1 Click Start Settings gt Printers 2 Double click the icon for Add Printer 3 Follow the Add Printer Wizard instructions Specify Local Printer when prompted 4 Select Generic and Text Only printer Click Next 5 Select FILE when prompted for the port to Use with the printer Click the Next button 6 Name the printer whatever you like You will probably not want to use this printer as the default 7 Print a test page when prompted Each time you print to this new Text Only Printer you will be prompted for a filename to print into For this test call the file TEST PRN and put itin the root of your C drive CATEST PRN 8 To check whether the page printed properly run Notepad and open the file CATEST PRN You should see the text from the Add Printer Wizard test 9 Ifyou were successful adding the Text Only Printer and creating the test file tals all you need to do Whenever you need to create a report as a text file so that you can send it electronically just select your Text Only Printer and specify a fle name Page 29
11. reasons itis recommended that you use the system s menu options to move through the website instead of using your browser s Back Forward and Refresh buttons You are limited to five connections to the system at any one time New connections can be created if you close your browser without logging out of the system or have multiple browser windows logged into the system at the same time If you receive a message stating that your user ID is being reported as already logged in wait ten or twenty minutes for a new session to become available or call your collateral analyst to free up the connections Changing Your Password You may be required to change your password both the first time you log in and on a periodic basis When required to change passwords you will be prompted to do so immediately after logging into the system To change your password you must enter your current password a new password and the same new password in the Confirm Password field New passwords are required to be at least five characters in length and contain at least one alpha character A Z or a z and one numeric character 0 9 Passwords are case sensitive If you forget your password please call your collateral analyst and it wil be reset Page Creating a New Borrowing Base Certificate Click on Borrowing Base Posting from the menu Enter a certificate number in the Certificate field under the heading New Certificate Borrowing Base Postin
12. see next section Pages 5 Enter your posting information then click Save to submit the certificate when you are finished 6 After saving the certificate will be displayed in a non editable printable format with the data you ve entered in a bold font You may print a copy for your records or review the Certificate later as a saved pending or historical posting Page 6 Editing a Saved Certificate Your borrowing base posting is stored as a saved certificate from the time it is first saved until your lender s next scheduled download Once the lender downloads the certificate it will be Considered pending and you will nat be able to edit or delete it Savod Cortfiestos e 1 Click on Borrowing Base Posting from the menu 2 Click the Edit button or click the hyperlink for the certificate you want to edit 3 The certificate will be displayed with your original data in the editable fields Change the information you need to then click the Save button to resubmit the certificate when you are finished 4 Beginning balances and rates will be set to thelr current values which may be different from the values of the original posting 5 It you make a mistake while editing a saved posting you can use the Reset button to return the values to their original state Deleting a Saved Certificate Savod Cortfiestos EI Edi 1 Click on Borrowing Base Posting from the menu 2 Click the Delete button nex
13. t to the certificate you want to delete The certificate you want to delete will be displayed 3 Click Delete again to confirm the deletion of the certificate 4 A message will prompt you that the posting has bean deleted Page Pending Status of Certificates A borrowing base certificate is held in a pending state from the time the collateral analyst downloads the posting until it is accepted into the system Pending postings are displayed on the loan ledger with a different color background and the word Pending in the Coll column inane 70805 Pending Pending postings show up in the borrowing base posting program with a View button next to them You may review a pending certificate but not edit delete or make changes Viewing a Pending Certificate Ponding Corthcatos Cars cans Mees 1 Click on Borrowing Base Posting from the menu 2 Click the View button next to the certificate you want to review The certificate will be displayed in a non editable format with the data entry fields formatted in bold text The beginning balances and rates on pending certificates are the same values they were when the posting was submitted Reviewing Historical Certificates 1 Click on Borrowing Base History from the menu 2 Select a From Date To Date range 3 Alist will be displayed of the certificates submitted within the date range Each certificate is displayed as a hyperlink 4 Click th
14. y for government reporting 1 Open the Excel Workbook that you want to save to a flat file 2 Click on CTRL A to select the entire worksheet 3 Click Style on the Format menu and then click to clear all check boxes except Font Modity the Font tab and then click a non proportional font for example Courier New from the Font list lick OK twice The format style of your workbook is now changed so that the column width is based on the number of characters that can be placed in the column 7 Adjust the column widths to suit your preferences Lo 8 Onthe File menu click Save As In the Save as type list click Formatted Text Space Delimited a Page 20 How To Print To A File In Microsoft SBM We will use the Receivables Report as an example 1 Click on Reports gt Sales gt Receivables Trial Balance 2 In the Receivables Trial Balance Reports click on the drop down and choose Historical Aged Trial Balance 3 Clickthe New button 4 Type AR Aging Report for Option 5 Click on the Destination button Paez How To Print To A File In Microsoft SBM cont 6 In the Destination section click on File 7 Click on the Brox Er DIG d 8 Type the filename ARAging followed by the aging date in the format MMDDYY i e ARAging030302 and use the extension prn Change the Save as type list to Tab Delimited Files
15. your experience with StuckyNat Link to be easy to use and understand Both novice and experienced Internet users can benefit from the information in this booklet Please read through it once to gat an overview of what StuckyNet Link has to offer and then keep it for reference if you should need it at a later time Technical Information Minimum System Requirements Microsoft Internet Explorer 6 or greater with 128 bit encryption Or Netscape 7 or greater with 128 bit encryption 56Kbps modem or other high speed Internet connection Internet Service Provider ie MSN AOL Earthlink Also Recommended Workstation access to electronic copies of supporting documentation Scanner for converting paper documents to an electronic format Microsoft Excel Lotus Notes or other spreadsheet software Pages Logging In Your collateral analyst will assign you a client code usemame and password Enter these codes in the corresponding fields on the login screen Be aware that the password is case sensitive Session Timeout For security reasons your session will end after 20 minutes if you are not actively using the system If your session ends you will be required to log in again Your session will also end if you close your browser window switch to a different website within the same browser window and then try to return using the Back button and possibly when you use the browser s Refresh or Reload function For these
Download Pdf Manuals
Related Search