Home

Chapter 7 - Reporting

1. Premium and Sum Insured Profle Aggregate Exposures Aggregation Report Im Automatic Invitations To Renew Generate Automatic Renewals Invoicing Automatic Renewals Print Invoices Automatic Upgrade Print Documentation Bordereau Report Ryno Bordereau Report Savannah Broker Analysis Report Broker Quote and Policy Report Refine by Description You can specify the date at which you want to report on active policies Home Account Selection Change Password All Options Favourites Report Cabinets Logout Active Policy Count by Class Report Run Report Specified Date Click Run Report once you have entered the date required and the following screen is displayed A Ibais Pulse Test Selection for 11 2 Active Policy Count by Class Report Printing Options Preview Mode Printer DEFAULT Ibais User Manual 7 71 O BA Insurance Systems Chapter 7 Reporting Select Preview if you want to view the report on screen Use the Printer drop down menu to select to email the report to yourself or send it to Report Cabinets or leave as default to send to printer Click Run Report once you have made your selections An example of the report is shown here Completed Page of 1 4 D Pl Search Search Next Actions REP 15823 10173 actions BA INSURANCE SYSTEMS Run Time 27 APR
2. 7 50 Brokerage Taken Report nnns na nnn nnn 7 52 Consolidated Brokerage Earned Report 7 53 ez Pile 7 b4 Accessing Client Statements 7 54 RUM LS 010 7 55 SUNRISE POLICIES REQUIRING CLOSURE ccccccccccccccccssseesssssseeceeeeeeeeeeeeeeeseeaaeesesesseeeeeeeeeeeeeeeessesaaaags 7 58 Ibais User Manual BA Insurance Systems GENERAL LEDGER DETAILS REPORTS cecceceeccecceccecceccencaecceccecceccecceccecceccesceeceeseenaesaecauccesceneesaenees 7 60 GASH RECENSE 7 62 CREDITOR FULL LEDOERREPORR ce ane SEI PUR ea a ns ra 7 64 MT D INCOME BY COMPANY BRANCH BY EXECUTIVE BY 7 65 DEBTOR HISTORY REPORT 7 67 LISTING OF CLAIMS BY CLAIM 2 1 triti re vetri rere rerit perna 7 68 ACTIVE POLICY COUNT BY POLICY CLASS 0 2 7 70 Ibais User Manual BA Insurance Systems Chapter 7 Reporting Chapter 7 Reporting Overview This document details Generating and Storing of Reports in bais How to Access the Reporting Functions The system is driven
3. INSURANCE 115 be Chapter 7 Reporting Ibais User Manual O BA Insurance Systems Ibais User Manual O BA Insurance Systems Chapter 7 Table of Contents CHAPTER 7 HEPOFCIHIBN 7 1 Quid ee 7 1 HOW TO ACCESS THE REPORTING FUNCTIONS 7 1 aiseriupeich ig 7 1 Running Reports to Report Cabinets ins 7 4 Viewing the Reports in the Report 7 5 Saving Reports to a 7 7 How to create new 7 7 BROKING REPORTS cq 7 9 UR RENTE TUN 7 9 OUBAGENT COMMISSION RATE da da eq 7 10 BROKING REPORT WITH SUBAGENT DETAILS SELECTION REPORT sise 7 12 KEF RERO 7 14 Dales Oy IV EE 7 15 Earned Amounts DY INVOICE 7 16 PORTFOLIO HE 7 17 EXPIRED POLICY TT 7 18 SUSPENDED POLICY TRANSACTIONS REPORT cccccccssccccssssssssssseececeeeeeeseeceeeeeeaasssssseeeeeeeeeeeeeeesseeesaaaas 7 19 POLICIES WITHOUT POLICY NUMBERS asian qoe
4. Gem Jewellers Pty Ltd and as Gem Jewellers Pty Ltd 01 04 07 120215 PPMV0700072 73 100 00 3 148 88 NSW M Mike Jones PMV 30 05 2006 0 0 00 07 76 80 00 50 00 Gem Jewellers Pty Ltd and as Jewellers Pty Ltd 01 04 07 01 04 08 120216 0501 0700072 9 0 2 996 96 NSW M Mike Jones PMV REA 20 05 2006 0 0 0 00 Gem Jewellers Pty Ltd and ss Gem Jewellers Pty Ltd 01 04 07 01 04 08 120217 06050100 0700072 2 950 00 NSW Mike Jones PMV 30 05 2006 0 00 0 00 177 00 80 00 295 00 50 00 lt FSRA Details By Client This Broking report enables you to see your clients FSRA status and report on the dates and versions of the FSRA documentation issued to any client The report can be run for one or more selected clients or for the entire database You can select to include only those clients with missing items if required Run Report FSRA Details keport Specified Clients blank All BE Selected Clients Client Name Input the client code s or Click on Selected Clients to look up the codes Leaving this field BLANK will run the report for all clients in the database Clients with Missing Items Only Tick this box only clients with missing items are to included in the report Ibais User Manual 7 26 O BA Insurance Systems Chapter 7 Reporting Completed Page of 9 Id4 bb Search Search Next Actions REP 14763 1
5. Company Wide Reports _ AP Creditors Age Analysis REP 14572 14591 23 11 07 11 06 100 7 22102 oy Invites Type Summary REP 14572 14588 23 11 07 10 57 096 o Report h et REP 14572 14583 23 11 07 10 48 100 1 This Field defaults to X Should you wish to Print an Click to view individual report Click to select or Click the buttons on the the report tool bar to Select All or Clear Select Refresh File Listing Print Selected Select All Clear Select This will Print the Selected Click to Refresh File Listing reports Once you have selected the Report to view you will go into the following print preview screen Ibais User Manual 7 5 O BA Insurance Systems ompleted Page of 1 A Insurance Systems Pty Ltd bois Invoice Type New Business Rebroked Rnls Renewals Endorsements Reversed NB Reversed Rnl RP Endorsements Joumals Af s Totals for Grand Totals Click on the Actions drop down menu to display the options defaults Click to select the function you wish to perform Gross Amount 41982183 66 424963 24 5721789 48 1298285 10 8539295 49 1152939 58 868934 10 6374 94 38859682 38 38859682 38 K4 b bl Chapter 7 Reporting Sales by Invoice Type Summary Report sort by Company Branch Al Brokers Fee Fee GST 99512 47 674 00 34994 34 1231 30 6283 25 10591 23 1212 63 0 00 9 761 91 69 10 3 679 10 164 81 514 12
6. Executive Division Subagent No Selecting Y for Exec Debtor will select only Net Sub Agents Status Note This report is unsuitable for printing and must be run to Spreadsheet Ibais User Manual 7 21 O BA Insurance Systems Chapter 7 Reporting Example of the report A EL Microsoft Excel Home Insert Page Layout Formulas Data Review View Developer Add Ins Cut Im A AutoSum c Calibri 11 sp Wrap Text General Y E HA EK la 43 Copy E a m Fill Z Paste E fad Merge amp Center 9 550 399 Conditional Format Cell Insert Delete Format gs Sort amp Find amp J Format Painter a _ 1780 5 Formatting as Table Styles C2 Clear Filter Select Clipboard Tu Alignment Number Styles Cells Editing Al Client No phqghumeaylnifdxfircvscxggbwkfnqduxwfnfo28703 XLS Read Only B D E G H 1 K T M N Client NolClient Nar Contact P Postal Adi Postal Adi Postal Adi Postal Adi Postal Coc Mailing Cc Telephon Fax Telex Email Parent Gre Exec Division Salutatior FSRA 2 ANDROOL Andrea Halpine PO Box 30 Christchurch Mrs Andre 3667536 3795395 andrea abbott co r BEST N 3 DAFFOO1 Daffy Daffy P O Box45 Takapuna 953 DrDaffyD 489920 489921 daffy xtra co nz BEST COM Rt Honour N 4 FREDOO1 Fred Brown STAPO 897644 Fred Jones Mr Fred Jc04 556 7788 STAPO
7. 01 change AGT Agent 08050061 01 01 2009 Combined Business Pak CHANOT change AGT Agent 09010081 28 02 2003 INSTRV Travel Sunrise CHANO3 TESTING 03 AGT Agent 08020017 01 03 2009 MMHP Merc 1 change AGT Agent 09010069 02 03 2009 INSTRV Travel Sunrise CHANO3 TESTING 03 AGT Agent 09010072 06 03 2009 INSTRYV Travel Sunrise 03 TESTING 03 Agent 09010073 07 03 2009 INSTRY Travel Sunrise CHANO3 TESTING 03 AGT Agent 09010075 08 03 2009 INSTRV Travel Sunrise CHANO3 TESTING 03 AGT Agent 09010076 08 03 2009 INSTRV Travel Sunrise CHANO3 TESTING 03 AST Agent 09010076 08 03 2009 INSTRV Travel Sunrise CHANOZ TESTING 03 Suspended Policy Transactions Report This report shows transactions that have been Suspended It should be run as part of a regular housekeeping function Click on Suspended Policy Transactions Report and the following will appear E Ibais Insurance Software R35 report selection Suspended Policy Transactions Printing Options Preview Mode 72 Printer DEFAULT 2 Run Report Click Run Report to view or print the report Ibais User Manual 7 19 O BA Insurance Systems Chapter 7 Reporting A Sample of the Suspended Policy Transactions Report is reproduced below BA TRAINING 4 BAIS Date Entered By Type Policy Class Insured Suspended Policy Transactions 17 DEC 2007 10 50 28 09 2007 cham Chan New Policy Merc DAVE DAVES TEST D
8. For all these fields leave blank or specify the selection required You can report on one client or if only for a selected client input the client code or look up Debtors Detailed Ageing Reports Run Report must match ALL criteria to be included on report eo options Debtor iter Company All Companies Currency All Currencies Select to Tor rt on Il Debtor All Debtors include or Executive All Executives exclude outstanding Alternate Executive All Alternate Executives funded amounts leave Division All Divisions items as No Input Subagent All Subagents Yes if you want Exclude Funded Items Y N No Include All items to report on Overdue Only Y N No Display All Outstanding items overdue only Report Type Options Ageing Date 29 10 07 This should usually be left at the default today s date Include Broking or Subagent Amts or Neither No Broking or Subagent amounts Detailed Report or Summary by Sort Category Detailed Report You can display the report with No Broking Subagent Sort Options Amounts Sort and Total Category None Sort by Debtor Only With Broking Amounts Sort by Debtor Code or Debtor Name Sort by Debtor Name With Subagents Amounts Select sort by Debtor Reports can be sorted by Executive Alternative Executive Division You can run the report Detailed or Code or Name Summary by Sort Category Subagent None sort by D
9. Ibais User Manual 7 17 O BA Insurance Systems Chapter 7 Reporting An example of the report follows Completed Page of 1 4 b b Search Search Next Actions REP 15446 99407 actions XLS BA INSURANCE SYSTEMS Run Time 15 APR 2010 11 24 Portfolio Analysis Report Summary For Policy End Date from 01 05 2010 to 30 04 2011 bois emey AUSTRALIAN DOLUS Company Branch 0 BA INSURANCE SYSTEMS Net Due to Subagent Bus Total Policy Class Gross Amount Commission Premium Insurer Subagent Count Allianz Club Marine Pleasure Craft 6 635 15 766 88 112 17 5 721 51 64 64 6 47 7 40 403 Commercial Motor Vehicle 1 034 44 90 00 900 00 935 44 9 00 0 90 1 O71 Commercial Package 34 927 02 4 519 03 28 620 13 24 606 09 58 75 6 22 57 Fire 7 830 32 680 00 A 4 400 00 7 104 32 0 00 0 00 2 3 47 General Property 12 666 61 150 00 1 000 00 934 00 0 00 0 00 3 079 Householders 9 223 48 1 274 27 6 371 35 7 830 87 0 00 3 502 Householders Accidental Damage 1 155 00 150 40 1 752 00 575 28 4 21 0 59 Travel Sunrise 1 054 53 16 10 805 00 871 82 0 05 0 63 Public Products Liability 3 196 53 399 90 2 666 00 2 593 25 0 00 2 10 4 107 53 3 396 66 2 644 50 2 528 00 p 0 00 2 09 QBEMM Motor Pack 4 824 99 i 310 20 4 138 12 3 701 84 0 00 3 26 Motor Vehicle 5 312 02 3 463 70 gt 4 626 94 4 746 94 0 00 3 66 QBETestPA 631 34 74 85 499 00 409 18 d 0 00 0 39 Personal Accident 2 897 50
10. Account Selectic Pas AN Up T 1 c ioi te ert rit perse abun ien dT ice EU LXI eta e 2 sb Outstanding Renewals by Client by Debtor utstanding Renewal Report by Client h 4 Outstanding Company Branch Renewals by Pr s Division Description Outstanding Renewals Report EH with Schedules Renewal Report The following Sort Select NIE criteria can be input Schedule Insurer Company Branch Division Insurer Policy Class Client Code Expiry Date Range BEES Policy Class Description Client From Both Division and Policy Class are multi value fields which means several can be included at a time Expiry Date From Completed Bj of 8 b Search Search Next Actions REP 14763 10400 actions M XLS BA INSURANCE SYSTEMS 2 Outstanding Renewals Report by Client by Debtor 01 JUN 2008 17 33 Company Branch 0 BA INSURANCE SYSTEMS bois Division com Period Start 01 06 2008 Period End 01 09 2008 Memo No Start Insured Name insureds Address Class Description Brokers Name Premium 07060004 Antz Pantz Pty Ltd PO Box 123 BUSINESS NetSub Brokers 100 00 AUD North Sydney NSW 2058 This is example MICKEY MOUSE PTY LTD 12 CENTRAL STREET BUSINESS RE ONE the re po rt etSub Brokers DISNEYLAND showing who the PIGOUT Harry and Mary Smith Box 12245 BUSINESS NetSub Brokers Broker is for each North Sydney
11. Brokerage Earned Reports This function allows you to run Brokerage Earned Reports The report shows in detail all fees commission sub agent s commission and GST earned in a selected period or transaction date range Ibais User Manual 7 50 BA Insurance Systems Chapter 7 Reporting Brokerage Earned Report S Financial Year If you nominate a From and To date range Financial Month leave the Financial Year amp Month blank Transaction Date From Transaction Date To Company Company Branch Selected Currency No Currency Selected Printing Options Summary Only Preview Mode Printer DEFAULT Input the selection criteria on which you want the report to be based input the Company and Currency or leave blank to include all Companies and Currencies If you do not have multiple companies and currencies you can leave it blank Click Run the Report A sample Brokerage Earned Report is reproduced below Ay Ibais Insurance Software ee DES Completed Page of 4 Id 4 b b Search Search Next Actions REP 12293 actions z BA TRAINING Run Date 08 NOW2007 Run Time 17 14 Brokerage Earned Report For Al records in file o Company 0 B A I S Currency AUD 3 Client Fees Commission Nett Broker Amounts Tr Date Sys Doc No Reference 0 Client Name Claims Bk Chgs Broker Fees Rebate Fee Gst Broker s Comm
12. Run Report Once you have selected your report criteria click on Run Report The following is a sample of this report run as a Summary Only but you can also select to run the report in full Detail Ibais User Manual 7 64 O BA Insurance Systems Chapter 7 Reporting Webpage Dialog Completed Page of 3 4 D p Search Search Next Actions REP 15905 57443 actions Y XLS BA TRAINING Run Date 18 JUL 2011 14 48 Creditor Full Ledger Report BA Insurance Systems AUD Eff Date 328730 94 114072 51 114072 51 Charges account for 5 FIRE SERVICE LEVY CREDITOR NSW FIRE SERVICE LEVY CREDITOR VIC Global Underwriting Services Lloyds of London Certain Underwriters at Lloyds NRMA Insurance Ltd APOIHIST R30 Creditor Full Ledger Report by Co Br by Currency by Creditor Code by Tran Date by Reference Page 1 of 3 MTD Income by Company Branch by Executive by Client This report produces a Month To Date Income report by Company Branch The report allows you to filter by Executive leave blank for all Executives Year defaults to current year and Month defaults to end of current quarter Note Year and Month are mandatory to run this report Executive can be left blank if you want to run the report for all Executives Ibais User Manual 7 65 O BA Insurance Systems Chapter 7 Reporting Home Account Selection Change Password All Options Favourites Report Cabinets L
13. Subagent 21485 35 0 00 4799 22 2043 94 5357 36 1783 16 304 16 0 00 20883 83 20883 83 Run Tim Subagent 651 2118 00 0 0 486 68 203 52 39 36 179 2 30 42 0 0 2559 20 2559 20 You will note the report job name The report may be deleted from the temporary file Ibais User Manual 7 6 This will allow you to Store this permanently report BA Insurance Systems Chapter 7 Reporting Saving Reports to a Cabinet If you select to Store this report permanently the following screen is displayed Save Report Pemanently to a Cabinet Subrat Cancel Available Cabinets Available Drawers 6 General Reporting Company Wide Reports End of Day C Reports for Staff Meeting End of Month il C Reports for Management Meeting You must select a cabinet from the list above Select an existing draw from the above list or create a new drawer below Create new draw New Drawer Details Drawer Description Report Description Creditors Analysis Access for Me Only 7 Report Purge Details Auto Purge After Date Auto Purge Days w Submit Cancel You must select a cabinet in which to save the report Once cabinet is selected a list of drawers is displayed as above Select the drawer you wish to place the report in If you don t have a drawer within the cabinet one must be set up How to create a new drawer At the Cre
14. 13 01 10 04 04 09 01 06 09 01 01 10 09 03 10 09 03 11 01 01 10 11 05 09 11 05 09 11 05 09 31 12 09 14 05 09 11 523 76 11 523 76 0 00 0 00 0 00 100 00 100 00 82 33 46 63 14683 14680 14681 14682 14741 14884 7 24 1152 38 1152 38 9 00 0 00 0 00 50 00 50 00 8 33 7 00 7 00 0 00 0 00 5 000 00 5 000 00 0 00 50 00 50 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 50 00 50 00 50 00 0 00 0 00 BA Insurance Systems Chapter 7 Reporting Broking Transactions for Insurer The Broking Transactions for Insurers Report allows you to list all transactions within a specified date range for a specified Insurer To access the report go to Broking Report Home Account Selection Change Password All Options Favourites Available Forms and Reports Type SelectType Category select Category v Favorites Type Category Sub Category Administration Broking Broking Reports Refine by Description broking Refine Report Cabinets Logout Sub Category Select Sub Category iv Form Report Click to Run Broking Administration Broking Exception Reports Broking Transactions for Insurer Creditor Outstanding with Broking Details Debtor Outstanding with Broking Details Favorites Yes No No No No Ibais User Manual 7 25 Insurance Systems C
15. 500 00 2 500 00 2 447 50 9 00 1 97 BUSINESS 46 357 59 6 555 44 25 799 11 27 828 44 43 02 20 35 20 35 BURGLARY INSURANCE 554 19 75 00 i 300 00 419 19 0 00 0 24 0 24 OWN DAMAGE amp LIABILITY 10 965 57 1 282 00 9 400 00 9 445 37 7 41 7 43 pulse 42 051 37 2 3 785 00 26 160 00 36 641 99 2063 2063 ZED TEST CLASS 247 88 0 00 0 00 100 00 195 36 1 008 008 Totals for New Renewal 195 773 04 21 569 43 1 575 74 126 802 32 139 536 39 76 100 00 100 00 Totals for 195 773 04 21 569 43 1 575 74 126 802 32 139 536 39 76 100 00 100 00 Totals for Company Branch 0 195 773 04 2 21 569 43 1 575 74 126 802 32 0 00 76 100 00 100 00 Totals for Currency AUD 195 773 04 21 569 43 1 575 74 126 802 32 0 00 76 100 00 100 00 Grand Total 195 773 04 21 569 43 1 575 74 126 802 32 139 536 39 76 100 00 100 00 BKTRANS R165 Portfolio Analysis Report Expired Policy Report This report lists all policies that have passed their expiry date but have not been renewed lapsed or cancelled Development Account BA DEV Expired Policies Expired Policies Report Account Executive Period From Period To Printing Options Summary Only Preview Mode Printer DEFAULT Run Report Ibais User Manual 7 18 O BA Insurance Systems Chapter 7 Reporting Development Account BA DEV Page Control Completed Page B of 40 search Se
16. Client Code Selected Division No Code Bl Company Branch Sort Sequence Client Name Next Sort Sequence Client Name Selected Clients 21 Selected Client Name Include Allocated Items This allows you to include any allocations Do Not Print If All Items Dated After against outstanding items In most cases leave this field blank only input a date if you want to exclude ALL items younger than the date Run report After all the fields have been completed you must now run the report Statements can be run on all clients by leaving the field blank or if only for a selected client input the client code or look up by clicking on the hyperlink Ibais User Manual 7 55 BA Insurance Systems Chapter 7 Reporting Home Account Selection Change Password All Options Favourites Client Statements Run Report Statement Date 08 11 07 Message To Appear On Statement Please pay all outstanding invoices urgently Run Type Individual Company Branch All Selected Executive No Executive Selected gt Selected Division No Code s Sort Sequence client Name Next Sort Sequence Client Name Selected Clients Bm Selected Clients BB WOOD Geppetto and Pinoccio Wood Client Name Include Allocated Iterns B Do Not Print If All Items Dated After This will allow you to preview or print the statements Web Page Dialog Statem
17. australia Phone 65747000 Fax 65747000 Executive STAPJ Alternate Exec Contact Name FSRA Client Retail Disclosure Document Covering Schedule FIRE 00 TESTOM Loss of Rent Removal of Debris BUSINESS INTERRUFTION Annual Gross Profit 5 Dead Months BURGLARY Contents 5 Stock 5 MONEY Whilst in Transit 5 On Premises Business Hours 5 This is an example of the Detailed version of the report Note This version will only display the schedule for Text Based schedules and Sunrise schedules Search 59 Kid DDI Renewal Report with Text Schedule No Premium Details For Policy End Date from 01 05 2008 to 01 09 2008 Sort by Company Branch Policy Class PBI BUSINESS 06060025 27 06 07 27 06 08 Memorandum Inception Renews Date Invoice No 3442 Policy No pbi Insurer SR cgu insurance Division COM Subagent Commercial Search Next Actions REP 14763 10402 actions Run Date 01 JUN 2008 This is an example of the No Premium version of the report This version is identical to the Detailed version but excludes On Premises Non Business Hrs 5 On Premises 24 Hours LIABILITY Limit of Indemnity TESTING ITESNT ASDFAKSDFK information GST VAT Reporting premium Please refer to the Accounting chapter of the manual for instructions on available GST VAT reports and how to run them Ibais User Manual 7 33 BA Ins
18. 05100018 Mr E Fudd x 290 00 34 80 2 355 20 05100008 Mr H Dumpty J B T j 120 00 i 0 00 il 120 00 05100017 Mr H Dumpty 4 3 70 00 0 00 70 00 05100017 Mr H Dumpty i x 91 88 0 00 91 88 05100023 Mr H Potter 1 1000 00 4 0 00 1 1500 00 05100024 Mr H Potter 1 4 i 1400 00 0 00 1800 00 05100024 Mr H Potter 4 j 3 811 78 0 00 1 822 74 05100024 Mr H Potter d 1 611 79 0 00 822 75 R R Hood 1 4 0 00 0 12 05100007 Ms R R Hood i 2 i A 5 270 00 il 355 00 05100001 fardvark Ente d 3 124 00 124 00 Ms R R Hood 1 x x 0 00 0 03 05100007 R Hood 1 290 00 1 1 375 00 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 13 10 05 AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR AR Ibais User Manual 7 51 O BA Insurance Systems Chapter 7 Reporting Brokerage Taken Report This function allows you to run Brokerage Taken Reports The report shows in detail all fees commission sub agent s commission and GST
19. 1 079 67 156 16 0 00 120750 26 12 237 29 120750 26 12 237 29 As Spreadsheet you are able to rearrange the data Please Note Commission 4 269 819 06 45 059 66 582 112 35 189 930 78 748 897 60 138 601 49 269 791 95 0 00 3 929 631 81 3 323 631 81 Commission GST 376692 63 1357 74 46353 09 19894 70 74083 89 12813 38 26563 34 0 00 330832 55 330832 55 All Company Branches Premium 33518705 82 346920 41 4678396 25 951751 84 7236207 15 937788 84 685577 58 0 00 30636200 75 30636200 75 Print Preview Open as a Spreadsheet Search Premium GST 3325939 06 35043 07 440381 04 101519 14 728518 42 90930 69 71943 05 396 00 3011034 15 3011034 15 FBC UUHT 151918 41 3731 80 52943 07 6430 95 2564 96 3946 38 8516 51 0 00 133336 38 133336 38 Store this report permanently Delete this re ort Search Mext Fire Levy 2300479 02 6335 40 203106 93 141260 66 82379 97 20461 13 42722 35 3960 00 2501658 56 2501658 56 Actions Stamp Duty 2503678 23 35833 59 312306 18 97998 91 409653 05 82093 16 59891 21 2018 94 2397160 55 2397160 55 Policy Fee 31891 36 0 00 22947 00 1510 00 752 40 7060 00 10975 39 0 00 37860 57 37860 57 Nett Due to Insurer 35381575 69 374924 88 4745520 76 1012980 48 7603042 94 951627 85 542430 88 6374 94 32411425 20 32411425 20
20. 8585885858858883333343 223222288888321 amp 878585858865228 882328837 7588238585258 031007 0310 08 Ibais User Manual 7 13 O BA Insurance Systems Chapter 7 Reporting Key Reports Following is a listing of the Key Reports reference A brief description of each report is provided for your i Key Reports b n Sales by Invoice Type Sales by Invoice Type Report Earned Amounts by Invoice Type Report Renewal Report with T ext Schedule Portfolio Analysis Monthly Sales by Client Cancellation Report This report gives a list of transactions invoiced whether paid or not It shows each transaction type in detail or summary Earned Amounts by Invoice Type This report gives a list of transactions that have been allocated detail or summary Renewal Report with Text Schedule It shows each transaction type in This is a renewal report specifically designed for Text schedule users Please refer to the separate section in this chapter on Renewal Reports for additional details and instructions Portfolio Analysis This report analyses your current portfolio by Policy Class showing the premiums and commissions for each class Monthly Sales by Client This report is similar to the Sales By Invoice Type but is sorted by Client It shows the premiums and commissions processed for each client within the period selected Cancellation Report This report al
21. 00 0 00 0 00 0 00 0 00 36 3 60 0 00 0 00 0 00 39 60 0 00 0 00 0 00 0 00 168 16 80 0 00 0 00 0 00 184 80 0 00 0 00 0 00 0 00 72 7 20 0 00 0 00 0 00 79 20 28 80 316 80 03 10 07 APO 10002 Pymt to Sub SUB ABC 031007 APO 10002 Pymt to Sub SUB ABC 03 10 07 APO 10002 Pymtto Sub SUB ABC 03 10 07 APO 10002 Pymtto Sub SUB ABC 031007 APO 10002 Pymt to Sub SUB ABC 03 10 07 APO 10002 Pymt to Sub SUB ABC 03 10 07 APO 10002 Pymt to Sub SUB ABC 03 10 07 APO 10002 Pymt to Sub SUB ABC 03 1007 APO 10002 Pymt to Sub SUB ABC 03 10 07 APO 10002 Pymt to Sub SUB ABC 0 0 0 0 0 0 0 0 0 0 Total for company 0 and AUD j 4 j 129 12 98 d 1 142 78 Total for Company 0 all currencies j i 129 12 98 142 78 Grand Total all companies amp all currencies d d 129 12 98 1 4 1 142 78 BKEARNED R40 Brokerage Taken for a selected period Ibais User Manual 7 52 BA Insurance Systems Chapter 7 Reporting Consolidated Brokerage Earned Report This report allows reporting on Brokerage Earned across multiple databases at once It is designed specifically to go to spreadsheet Completed Page of 1 H 4 Search Search Next Actions REP 15139 36953 actions XLS BA INSURANCE SYSTEMS Run Date 12 JUN 2009 Run 1 Consolidated Brokerage Earned Summary Report For Financial Year 2008 and Financial Month 12 bois Earned Amounts Fin Comp Cur
22. 06070020 gt o o Account Selectior 2 to Change Password Renewals with Schedules Company Branch Transaction Date From BH Executive s EB 2 BB Client s Schedule of Cover Schedule of Insurance Schedule Inc Financials By Executive Warning Selecting any of the schedule flags may genera Ce cea Bl of 2 Insured Name Copy Cat Pty Ltd McHudden P L ULLADULLA BUS LINES Test Account Harry and Mary Smith Harry and Mary Smith Harry and Mary Smith Happy Gilmore Golf Aca Happy Gilmore Golf Acade Antz Pantz Pty Ltd Harry and Mary Smith MICKEY MOUSE PTY LTD John Doe Harry and Mary Smith ABC Promotions Document Testing Account Antz Pantz Pty Ltd Jay01 Jenell and sssoc K 4 DDI my my Search As with the report above the following Sort Select criteria can be input Company Branch Division Insurer Policy Class Client Code Expiry Date Range Both Division and Policy Class are multi value fields which means several can be included at a time Select the Schedule documents to be printed here To sort by Executive tick this box Search Next Outstanding Renewal Report Company BA INSURANCE SYSTEMS Period from 01 05 2008 to 01 09 2008 Class Description BUSINESS BUSINESS Commercial Package Public Products Liability Co
23. 10 06 05 10 25 10 10 25 10 10 28 10 11 28 10 11 28 10 11 28 10 10 25 10 11 28 10 10 29481 132 234 81 843 79 124 843 79 244 80 135 244 80 3455 88 i 183 3455 85 195 37 68 195 37 234 81 18 234 81 244 80 24 244 80 3518 30 157 3518 90 3518 90 142 3518 90 11218 90 j 72 11218 90 785 37 28 195 3 11218 30 158 11218 90 3455 85 i 2710101 2455 86 SE mind 0 Total for 1442 Amanda Curt 0 00 0 00 AROIHIST R10 Debtors History Report Page 1 of 18 Listing of Claims by Claim Number This report produces a listing of claims in Claim Number order with their corresponding financial transactions It can be accessed from the All Options selection then selecting Claims from the Type dropdown then Reports from the Category dropdown then selecting Listing of Claims by Claim Number as shown below Ibais User Manual 7 68 O BA Insurance Systems Chapter 7 Reporting Home Account Selection Change Password All Options Favourites Report Cabinets Logout Available Forms and Reports Type Claims Sub Category Select Sub Category v Favorites Type Category Sub Category Form Report Click to Run Claims Reports Record Sheet Claims Bordereaux Savannah Claims Bordereaux Claims Listing Claims Outstanding and Paid Claims Payment Summary Petplan 000 Claims Payment Summary Spreadsheet P
24. 1414 43 31280 15 1038 62 3173 24 107712 14 O Insurance Systems Chapter 7 Reporting Control Total Balancing Report Control Total Balancing Report Trust Accounting Trust Account Summary Report _ Trust Trial Printing Options 1 Balance Report Summary Only Control Total Balancing Report Preview Mode Brokerage Earned Printer Summary Report DEFAULT ge Run Report For this report you can simply select to Preview or send to your Printer Click Run Report when selection has been made A sample of a Control Total Balancing Report is reproduced below This function allows you to run a Control Total Balancing Report The report gives a full picture of your broking business including all outstanding debtor and creditor amounts and all received amounts The amount at the bottom of this report should equal zero It can be out a few cents as a result of rounding differences on part paid items which will clear on allocation of the balance of the relevant transaction Control Total Balancing Report Printing Options Preview Mode Printer DEFAULT Run Report Ibais User Manual 7 40 O BA Insurance Systems Chapter 7 Reporting Brokerage Earned Summary Report This function allows you to run a Brokerage Earned Summary Report The report gives an overview of the opening balance amount brokerage earned and taken during the period the closing balance and th
25. 2000 00 54 234323 42423 423 DRAUOO1 Or August Bellows 090907 2000 00 55 4243 HARRO1 Harry Constructions 050307 1500 00 44 1235655 Total for Debtors 11192 50 Royal Sun Aliance 100807 1500 00 123890 Total for Creditors 1500 00 Total for Currency AUD 12692 50 Total for Company 0 12632 50 Grand Total may be mixed currencies 12632 50 Trust Bank Movements Section 26 Report This report can be access via All Options Trust Accounting Reports selection or using the top drop down menus Type Insurance Category Reports Sub Category Broking then scroll to find Trust Accounting Reports It gives a list of all bank movements transactions in the selected Trust Bank as per the selection criteria set and includes the information Trust Bank code Creditor Debtor code number Transaction date Narrative and transaction amount The report is automatically sorted on the following fields in this order Ibais User Manual 7 47 BA Insurance Systems Chapter 7 Reporting Currency then by Company then by ADP Code then by Trust Bank then by Transaction Date Financial Month From amp To then by Creditor Debtor Once in the Trust Accounting Reports screen select Trust Bank Movements Section 26 Reports as shown below to input your selection criteria for the report Home Account Selection Change Password All Options Favourites Report Cabinets Logout Trust Accou
26. 2011 17 30 Active Policy Count by Class Report For Policies which were Active on 20 06 2010 bois Policy Description Class AALCML Allianz Club Marine Pleasure Craft API Professional Indemnity AUHH Calliden House Holders Sunrise CMV Commercial Motor Vehicle Commercial Package Domestic Motor Vehicle Fee Only Fire General Property HH Householders Householders Accidents Damage INSTRV Travel Sunrise ISR1 Industrial Special Risks LIA Public Products Liability MAT Marine One Off MJ Cat Insurance MMHP QBE Test Home MMMP QBEMM Motor Pack MV Motor Vehicle PANUAT QBETestPA Personal Accident BUSINESS MARINE TRANSIT OWN DAMAGE amp LIABILITY pulse Sports Combined Trade Credit Workers Compensation ZED ZED TEST CLASS Q3 9 3 Gh a u xu t Grand Totals BKREPORTS R36 Active Policy Count by Class Report Note Only policies which were active on the nominated date are included Page 1 of 1 Ibais User Manual 7 72 O BA Insurance Systems
27. Company Branch Foreign Rebate Fee GST Brokers Comm Brokers GST Subagent Subagent Overseas Claims GST GST Underwriter only if claims from trus Period Currency Excl Excl Commission Variance Trust Account Balances bagen retained G Total Profit in Total Gst in Trust Subagent Comm Total of all Trust in Trust amounts in Trust 2008 12 0 AUD 0 BAINSURANCE SYSTEMS 8067 37 20 00 2963 40 27274 78 544 05 18223 76 1621 25 11449 08 70113 69 Trust Account Balance 0 00 19999 37 209545 23 229544 60 Total for Currency AUD Earned Amounts for period 4 8067 37 30 00 2963 40 1 18223 76 1621 25 11449 08 70113 69 Trust Account Balance 19999 37 209545 23 229544 60 BKEARNED SUM R20 Consolidated Brokerage Earned Summary Report Page 1 of 1 Ibais User Manual 7 53 O BA Insurance Systems Chapter 7 Reporting Client Statements This function allows you run statements for your clients Accessing Client Statements Click on All Options on the top menu as shown below to display all available options Select from the Forms Report menu Client Statements Account Selection Password Options Favourites Logout Available Forms and Reports Category Select Category Sub Category select Sub Category Favorites Type Category Sub Category Form Report Click to Run No Accounting Maintenance Insurer Creditor Maintainance Processing Cancel Paymen
28. LTD 0 00 0 00 0 00 Ibais User Manual 7 11 O BA Insurance Systems Chapter 7 Reporting Broking Report with Subagent Details Selection Report This report produces a list of broking transactions with subagent details This report can be accessed by selecting Type Insurance then Category Reports then Sub Category Broking then clicking on Broking Report with Subagent Details Selection as shown below Home Account Selection Change Password All Options Favourites Report Cabin ts Available Forms and Reports Select Type Category Select Category Sub Category Sub Category Favorites Type Category Sub Category Form Report Click to Run Insurance Reports Broking Broking Exception Reports Broking Report with Subagent Details ansactions TO ISUure Debtor Outstanding with Broking Details Once in the report screen you can select a specific or multiple Transaction Types or leave as default for All set an Inception Date From and or Inception Date To or a range and or a Transaction Date From and or Transaction Date To or a range as required This shown on following screen Broking Report with Subagent Details Report Selection Clear Transaction Types to include B Transaction Types EB em Tran Type Use the Transaction Type dropdown button to select types required for report options shown here Cancel Renewal Cancellation Endorsement Inst
29. Trairee To Be Advised 125 J055 Toti Shu c Amoun te Fald b CilentbutMotTaken tom Creditor 1161 50 Toti brCurrenoy AUD 111 18 Toti frCompany 0 imay be ml sed ourrenole 6111 18 Grand To til All mpanle c and Al Currenole c 111 18 BKPEPO RATS RS3 Rekrn Premiums Report Unallocated Cash Listing This function allows you to run an Unallocated Cash Listing The listing shows all receipts which remain fully or partially unallocated Unallocated Cash Listing Printing Options Summary Only Preview Mode Printer DEFAULT Run Report Ibais User Manual 7 46 O BA Insurance Systems Chapter 7 Reporting For this report you can simply select to Preview or send to your Printer Click Run Report when selection has been made sample of an Unallocated Cash Listing is reproduced below Print Poll f1 gt B E 100 Close ls BA TRAINING Run Date 01 NOW 2007 Unallocated Cash Listing Company D BA hsurance Systeme Currency AUD AUSTRALIAN DOLLARS Debtor Name Creditor Name Date Net Amount voucher Refere nce Unalloc Desc ABC Pty Ltd 064206 20000 43 741852963 Pty Ltd 270407 1000 00 47 123456 ANTZ Fardvark Enterprises tas Antz Pa 314007 1837 50 76 CASH Advantage Premium Funding 010507 678 00 49 CASH Peep 050307 1200 00 44 1235655 BUB B01 Bubba Joe Constructions 010507 777 00 48 CASH ORAUOO 1 Cr August Bellows 090907
30. by entering part of the description Ibais User Manual 7 60 BA Insurance Systems Chapter 7 Reporting Samples of General Ledger Details reports are below A General Ledger Details Report by COA Run Time 22 SEP 2010 14 00 General Ledger Details Report Company Branch From 0 0 Chart of Account From 040 To 101 Financial Month From 10 April To 11 May Year 2004 Sub Journalld Account No Transaction Effective Narrative Credit Amount C F Balance DepositSlip Reference Account amp No Date Date No USD 4 445 10 USD DREC2 B Insurance Systems Pty Ltd B A Insurance Systems Pty Ltd 23 06 10 23 06 10 AR Sundry Rec 4161 Bank Insurance Broking USD Bank Insurance Broking USD 4 400 66 AUD 12 037 96 AUD DREC1 4091 14 01 10 14 01 10 RECPT PCTO20 23 224 30 AUD DREC1 4092 14 0110 14 01 10 AR RECPT PCTO12 26 408 56 AUD DREC1 4096 04 11 06 28 0110 AR RECPT DAVE1 26 419 56 AUD DREC1 4097 03 11 06 28 01 10 AR RECPT DAVE1 26 430 56 AUD DREC1 4098 03 11 06 28 01 10 AR RECPT DAVE1 26 441 56 AUD DREC1 4099 04 11 06 28 01 10 AR RECPT DAVE1 26 452 56 AUD DREC1 4100 03 1 06 28 01 10 ARRECPTDAVE1 26 463 56 AUD DREC1 4101 03 11 06 28 01 10 AR RECPT DAVE1 26 474 56 AUD CPAY1 20100311 11 03 10 11 03 10 AP PAY 704 CGU 24 247 25 AUD CPAY1 201003112 11 03 10 11 03 10 AP PAY 705 PCTO1 17 999 21 AUD CPAY1 20100311 3 11 03 10 11 0310 AP PAY 706 16 394 90 AUD DREC1 4153 1
31. defaults to All Banking Location defaults to All Tender Type use dropdown or set to All options displayed below Date Captured defaults to today s date but can be changed Transaction Date leave blank for all dates or enter specific transaction date s Client use the hyperlink to select client or enter client code manually Division use dropdown or keep as All and Executive use dropdown or keep as All If you select a particular Executive or Division these details will be included in the Report Footer Account Selection Change Password All Options Favourites Report Cabinets Logout Cash Receipts Listing Company Branch Equal to Currency Equal to Bank Code Equal to Banking Location Equal to All Tender Type Equal to All Date Captured Greater than or Equal to 18 07 2011 Date Captured Less than or Equal to 18 07 2011 Transaction Date Greater than or Equal to Transaction Date Less than or Equal to Client Equal to Division Equal to Executive Equal to Ibais User Manual 7 62 O BA Insurance Systems Chapter 7 Reporting When you have input all your selection criteria click on Submit to run the report If you need to clear any of your selection criteria set click on Clear to reset Example of the report BAIS Training Contiol 5 EA LLL Webpage Dialog ne gt Completed Page of 3 4 gt Pl Search Search Next Actio
32. insurers subagents statutory authorities etc To ensure that these reports will balance to each other there must be no processing done on the system between running one report and another that it is to balance to o Brokerage Earned Report Each of the reports can be selected from the left hand side You should run the Trust Account Summary first as this one creates the file used by the others Trust Accounting Reports Following is a listing of the Trust Accounting Reports A brief description of each report is provided for your reference Trust Account Summary Report This is the report required by ASIC for licensing of Brokers in Australia under current legislation The report consists of two parts Section 26 and Section 27 Trust Trial Balance Report This report gives a more detailed analysis of the Section 27 report Ibais User Manual 7 35 O BA Insurance Systems Chapter 7 Reporting Control Total Balancing Report This report gives a full picture of your broking business including all outstanding debtor and creditor amounts and all received amounts Brokerage Earned Summary Report This report gives an overview of the opening balance amount brokerage earned and taken during the period the closing balance and the amount available to draw Debtor Ageing Reports This report shows all invoiced items owed to you by a debtor this is broken down into current 30 60 and 90 days it also include
33. paa o Hep rant aene 7 20 CUSTOMER AND ADDRESS LISTING 7 21 REPRINT CREDIT CONTROL EET TERS sccscseacsecessescessassuadenssancieenndeadcpvesccesevedeabansisnncdesesdosdeeeesaceiseeesaaesseends 7 22 TRANSACTION LISTING BY TRANSACTION DATE ire 7 24 BROKING TRANSACTIONS FOR INSURER 998 7 25 a SAS CENT ete eau nee eee eee 7 26 mih A RERO ERR RR 7 27 Outstanding Renewal Report By Client 7 27 Outstanding Renewals By Client By Debtor RL 7 29 Outstanding Renewals Report With Schedules 7 30 Renewal Report With Text Schedule ss 7 31 REPORTING 7 33 TRUST ACCOUNTING REPORTS eene da nani bnt connnetbeceddondenex2 decasdaned dacctseteceddandeassP dacasdadaxceeuteoescuddanscass 7 34 Trust Account Summary Report dia 7 37 Trust Trial Balance vivimos Fas avete dii aal ictu ri pod Vin gusce zwar MU 7 99 Control Total Balancing sise 7 40 Brokerage Earned Summary Report 7 41 Debtors Ageing 7 42 ei eel ACD ONG 7 43 Return Premium 7 44 Unallocated Cash Listing 7 46 Trust Bank Movements Section 26 Report 7 47 Policy Transaction Exception report sise 7 49 Brokerage Earned
34. taken in a selected period or transaction date range Brokerage Taken Report Financial Y co o If you nominate From and Financial Month To Date range leave the Trans Date from 01 10 07 Financial Year and Month Trans Date to 51 10 07 blank Company No Company Branch Selected Currency No Currency Selected Printing Options Summary Only Preview Mode Printer DEFAULT Run Report 4 Input the selection criteria on which you want the report to be based input the Company and Currency or leave blank to include all Companies and Currencies If you do not have multiple companies and currencies you can leave it blank Click Run Report A sample Brokerage Taken Report is reproduced below BA TRAINING Brokerage Taken Report 29 NOW 2007 14 46 du pen Currency AUD AUSTRALIAN DOLLARS Tran Date from01 10 2007 to 31 10 2007 Tr Date Sys Doc No Reference Subagent Broker Fees Fee Gst Rebate ney Bk Comm Comm GST PFund f Subagent S fg GST UW Gst Claims Gst Variance Tot Amt Taken Agree Nett of Nett o S fg Comm fg GS 0 00 0 00 0 00 0 00 34 80 3 48 0 00 0 00 0 00 38 28 0 00 0 00 0 00 0 00 75 00 7 50 0 00 0 00 0 00 82 50 0 00 0 00 0 00 0 00 135 00 13 50 0 00 0 00 0 00 148 50 0 00 0 00 0 00 0 00 999 00 99 90 0 00 0 00 0 00 1098 90 0 00 0 00 0 00 0 00 20 00 2 00 0 00 0 00 0 00 22 00 0 00 0 00 0 00 0 00 300 00 30 00 0 00 0 00 0 00 330
35. 0 0 00 0 00 0 00 0 00 5 89 Totals for Summary 805657 01 4307 05 531 19 130689 65 11673 15 671636 49 3031 71 7282 90 5914 42 652694 85 330 32 33 04 134665 38 Grand Totals 805657 01 4307 05 531 19 13068965 11679 15 671636 49 3031 71 7282 90 5811 12 652694 85 330 32 33 04 134665 38 BKEARNED R100 Eamed Amounts by Invoice Type Summary Repo Page 1 of 1 Portfolio Analysis This report analyses the portfolio by Policy Class The selection criteria are displayed as below Home Account Selection Change Password All Options Favourites Report Cabinets Logout Key R rt a Key Reports Portfolio Analysis Run Report Sales Invoice Type Report Earned Amounts L by Invoice Type Company Branch Report Renewal Report 3 with Text Policy End Date From Schedule Portfolio Analysis Monthly Sales by Client Cancellation New Business Renewal l Report Underwriter Executive Alt Executive Division Month Select and sort by For an analysis of your entire active book of business leave the Policy End Date From and To BLANK Inputting dates in here will limit the report to policies expiring within the date range selected Use the Select and Sort drop down menu to select the sort criteria Depending on the selection made here there are two additional fields to input a range For example if you select Executive as the Select and Sort option then you can input the Executive code to start and stop at to limit the selection
36. 0 00 0 00 0 00 803 22 803 22 UAA Underwriting Agencies of Australia 60 days 4115 51 0 00 0 00 0 00 0 00 0 00 4115 51 4115 51 ZURICH Zurich Australian Insurance 90 days 748 00 0 00 0 00 0 00 0 00 0 00 748 00 748 00 Total for Currency AUD 212562 88 39079 24 136537 24 58108 62 1500 00 0 00 447797 98 446287 38 Total for Company 0 may be mixed currencies 100 212562 88 33073 24 136537 24 58108 62 1500 00 0 00 447787 98 446287 38 Grand Total may be mixed currencies 100 212562 88 33073 24 136537 24 58108 62 1500 00 0 00 447787 98 446287 38 Return Premium Reports This function allows you to run Return Premiums Reports The report identifies any transactions where a credit has been taken from the creditor but not yet paid to the client or paid to the client but not yet taken from the creditor SS Return Premium Report Run Report Company All Companies Currency All Currencies Report may be run for Underwriter Creditors Creditor Type Statutory Charge Creditors Subagents Underwriter Creditors Sort By Creditor leaving this field blank the report will sort by client name if you tick the field the report will sort by creditor Ibais User Manual 7 44 O BA Insurance Systems Chapter 7 Reporting Please Note Input the Company or Currency you wish to run the report for or leave blank to include all Companies and Currencies If you do not have multiple companies and currenci
37. 00 Suspense 0 00 Subagent Totals where the subagent is the debtor only Subagent Commission 0 00 Subagent GST 0 00 Grand Totals Companies and Currencies Suspense Subagent Totals where the subagent is the debtor only Subagent Commission Subagent GST Creditor Report This function allows you to run a Creditor Report The report shows broken down into days all items outstanding against a creditor Selection criteria can be used to narrow this down to Fully Part Paid Unpaid and Return Premium items if required Creditor Reports Company All Companies Underwriter Creditors Currency All Currencies Statutory Charge Creditors Subagents Creditor Type Underwriter Creditors Creditor All Creditors Detail Report a Enter Creditor you wish to report on or leave blank to Client Invoice Selection Options Report on ALL creditors Fully Pain E Click the box if you want the Part Paid E report in detail leaving blank Unpaid Will print in summary Return Premiums Click on the boxes to select the items to be reported on These options refer to whether the invoices are paid part paid etc by the client Ibais User Manual 7 43 BA Insurance Systems Chapter 7 Reporting Inout the Company and Currency you wish to run the report for or leave blank to include all Companies and Currencies If you do not have multiple companies and currencies you can leave it blank C
38. 001 pbi To Be Advised To Be Advised 0 To Be Advised TESTO10018 NELODODDE 01 To Be Advised To Be Advised 1 000 00 1 000 00 AD 1 00 5 000001 1 00 5 000001 Be Advised Ibais User Manual 7 30 BA Insurance Systems Chapter 7 Reporting Renewal Report With Text Schedule This report gives a range of sort select options and produces several versions of the report If you are using Text Based Schedules you will also be able to produce two detailed versions which include the full schedule NOTE You must select an Expiry Date From and Date To and at least one Sort Sequence to run this report Choose to include quotes by ticking here Choose to include notes and claim details by ticking here Report Clears Using the options in the drop down menu you can determine the Input the expiry date range to be reported on You must enter these dates to run the report treatment of EDI policies Sunrise Renewal Reports Outstanding Renewal Reports Renewal Report with Text Schedule Print EDI Policies Outstanding Date From Yes Print EDI Policies Renewal Report by Date To t Client Include Quotes Outstanding I gt gt Renewals by A Policy Class Description Detailed Summary Brief or No Premium Detailed Client by Debtor BE nclude notes and claim details Outsta
39. 0392 actions BA INSURANCE SYSTEMS Run Date 01 JUN 2008 Run Tim FSRA Details for Current Policies All Clients Customer Client Name FSRA Contact FSG Document FSG Date 3 SOA Document SOA Date PDS Document PDS Date Number Type BAIS BA Insurance Systems Pty Ltd R FSG000001 01 19 SEP 2007 06110007 07040009 SYDNEY HARBOUR HOTEL FSG233788 02 31 MAR 2008 02070002 BLACK JACK 06050004 Black and White 06070008 Joe Bloggs T As Plumbing Solutions 06110024 Blue Baloo 06070006 Brown Bros Printing FSG233769 02 20 MAY 2008 02040004 02040004 07090011 07090012 07090013 This is an example 07090014 07090015 of the report BRU 1 Bruce Lee T As Kung fu Master 30 APR 2008 08040022 08040022 R 1 CAFE RIO FSG000001 01 26 JUL 2006 06070034 CAMPBKO Kylie Campbell FSG000001 01 15 FEB 2007 07020009 CHRISSYS CHRISSYS CAFE R 04 MAY 2006 06050005 COPYC Copy Cat Pty Ltd FSG000001 01 14 MAY 2007 07050005 CRUIOO1 cruise sexy boots 06110023 DELL A Dell Monitor 08020010 08020011 DOE001 John Doe 07060012 GOOBERZ Gooberz GobStoppers FSG000001 01 04 JAN 2007 07010002 r soaret badev 04 JAN 2007 PDS23425 01 JAN 2007 HAPPY Happy Gilmore Golf Academy FSG000001 01 06 JUL 2006 07060005 Renewal Reports renewal reports are grouped under one menu in Broking Reports These reports are intended to assist with renewal procedures and to list all policies expiring within a selected date range Outstanding Renewal Report By Client
40. 1329165 09 0 00 BANK 080 Investment Bank Account number 080 116110 00 0 00 BRCOMM Brokers Commission 0 00 16274 47 BRCOMMGST GST on Brokers Commission 0 00 717 47 BRFEE Brokers Fee 0 00 51205 68 BRFEEGST GST on Brokers Fee 0 00 5121 05 BRUWGST GST retained for overseas underwriters 0 00 4140 00 CASHUNALLOC Unallocated Cash 0 00 424228 67 5 Claims Vero Insurance 7000 00 0 00 CL ALLIANZ Claims ALLIANZ AUSTRALIA INSURANCE LTD 14750 00 0 00 CL CRED Claims Creditor Claimants 124619 00 0 00 CL DEBT Claims Debtor Claimants 0 00 6187 00 CL TITANIC Claims Titanic Insurance 50000 00 0 00 RETPREMUW Return Premiums Underwriters Only 0 00 111514 64 ST FBC Stat Chg FBC Charges 0 00 458 08 ST FSLNSW Stat Chg FIRE SERVICE LEVY CREDITOR NSW 0 00 10524 27 ST FSLVIC Stat Chg FIRE SERVICE LEVY CREDITOR VIC 0 00 4190 40 ST SDNSW Stat Chg STAMP DUTY CREDITOR NSW 1198 43 0 00 ST SDQLD Stat Chg STAMP DUTY CREDITOR QLD 0 00 74 37 ST SDVIC Stat Chg STAMP DUTY CREDITOR VIC 0 00 1485 20 ST SDWA Stat Chg STAMP DUTY CREDITOR WA 0 00 220 00 ST WTCR Stat Chg WITHHOLDING TAX CREDITOR 318 42 0 00 SUB ABC Subagent ABC GST EXEMPT Sub Agent 993 73 0 00 SUB NATHAN Subagent DAVID NATHAN 6 03 0 00 SUB RMG Subagent RMG General Insurance 352 00 0 00 SUB SUB bagent SUBAGENT 0 00 8 63 Use the Actions drop down menu to select Email Report to Self VBScript A confirmation box is displayed as shown Ibais User Manual 7 3 O BA Insurance
41. 1700419 1700 43 Reversed Rnl 73974 65 305 00 30 50 5 712 75 671 28 49565 00 6351 73 0 00 13952 80 6517 48 0 00 69003 03 2498 10 249 81 RP Endorsements 1658 15 13 32 113 20 23 32 1218 85 152 05 0 00 201 66 143 74 0 00 1668 15 0 00 0 00 Totals for 1295241 54 3771 41 476 94 182 030 03 14678 28 398583 88 112008 89 6695 22 121505 29 58809 96 10350 00 1017192 62 10653 36 1065 34 Grand Totals 1295241 54 3771 41 476 94 182 030 03 14678 28 338583 88 112008 93 6695 22 121505 29 58809 96 10350 00 1017192 62 10653 36 1065 34 BKTRANS_R155 Sales by Invoice Type Summary Report Page 1 of 1 Earned Amounts by Invoice Type This report gives a list of transactions that have been allocated It shows each transaction type in detail or summary CORBARV BRARGR If you nominate a From and To date leave the Financial Year Month Financial Year blank Please Note Earned Date is Financial Month the date the transaction is allocated e Earned Date From To on bais Select and Sort Category RE NE al It no Select and Sort Category entered then report will display all Enter Range or Leave blank to include all To No Select or Sort Executive Detail or Summary Report Summary Report Executive Policy Class Underwriter Report can be in Detail Subagent or Summary Division DN Ibais User Manual 7 16 O BA Insurance Systems Chapter 7 Reporting Once you have input your selection criter
42. 3 32 3 32 CRN END New Client cou 9 22 1 86 33 20 0 00 16 76 157 10 SUB NET 12 11 07 1187 FREOOO1 07110001 0 00 0 00 0 00 ANDS INVB POL Fred Happy T as Happy Facials 0 00 0 00 2 640 00 0 00 2 640 00 1211207 1188 FREDO01 07110002 0 00 0 00 i 0 00 ANDS CRN POL Fred Happy T as Happy Facials 0 00 0 00 2 640 00 0 0 0 00 2 640 00 165 98 33 20 3 3 32 9 22 1 66 33 20 16 76 7157 10 BKREPORTS R380 Invoice Summary Report Invoice Number by Transaction Date with Subagent s Ibais User Manual 7 9 BA Insurance Systems Chapter 7 Reporting Subagent Commission Rate Listing This report produces a Subagent Commission Rate listing This report can be accessed by selecting Type Insurance then Category Reports then Sub Category Broking then selecting Subagent Commission Rate Listing as shown below Account Selection Change Password All Options Favourites Report Cabinets Logout Available Forms and Reports Select Type v Category Select Category v Sub Category Select Sub Category v Favorites Type Category Sub Category D Refine by Description Refine The report allows you to list all the Subagent Commissions There is only one option whether not you want to include Exec Debtors Net Subagents Home Account Selection Change Password All Options Favourites Report Cabinets Logout Subagent Commission Rate Listing Exec Debtor Net Subagent Click in this box if you
43. 4763 10405 action Search Processing Security Page il of Kd DDI BA INSURANCE SYSTEMS Run Date 01 JUN 2008 Run Ti bois Company Branch 0 Renewal Report with Text Schedule For Policy End Date from 01 05 2008 to 01 09 2008 Sort by Company Branch Policy Class PBI Premium 1000 00 BUSINESS BCIB Stamp Duty 134 64 SYDNEY HARBOUR HOTEL Memorandum 02070002 cbgjccj FSL 260 00 Client Commission Address Commission GST Phone Fax Executive Alternate Exec Contact Name vasdhvs Inception BBBBBBB 2000 Renewal Date 02 99990000 Invoice No Policy No ANDS Sheri Andrews Insurer Division Subagent 23 07 07 29 07 08 12851 Stat Lisb Vero Insurance COM Commercial nm Insurer GST Broker Fee Rebate Amt Policy Fee Fee GST 141 00 State Levy 500 00 Witholding Tax 0 00 Due To Insurer 50 00 50 00 Subagent Commission FSRA Client Retail ABC Client Payable 2235 84 Disclosure Document Subagent GST Covering Schedule ee FGBNDFTHJERT Building 5 900 000 Contents 5 Stock Loss of Rent Removal of Debris 5 BUSINESS INTERRUPTION Annual Gross Profit 5 Indeminty Period Months BURGLARY Contents 3 Stock 5 MONEY Whilst in Transit 3 On Premises Business Hours 5 On Premises Non Business Hrs 5 On Premises 24 Hours LIABILITY Limit of Indemnity Completed Page B of BA INSURANCE SYSTEMS bois Company Branch 0 Client ONELLY Address dogs eye road 1212
44. 5 06 10 21 06 10 ARRECPTPCTO001 21 615 50 AUD DREC1 4154 15 06 10 21 0610 AR RECPT PCTO08 25 826 06 AUD DREC1 4155 15 06 10 21 06 40 AR RECPT PCTO12 26 244 46 AUD DREC1 4156 16 06 10 21 06 10 AR RECPT PCT001 31 138 46 BA Insurance Systems Pty Ltd Bank Insurance Broking No 2 SEITTRSTPSTRPRETEIS B A Insurance Systems Pty Ltd Bank Insurance Broking No 2 B Run Time 22 SEP 2010 14 07 General Ledger Details Report by Policy Class Company Branch From 0 To 0 Chart of Account From 400 To 520 Financial Month From 10 April To 11 May Year 2004 Journal Id Account amp Voucher Transaction Number Date Account No Narrative Month Year Credit Amount AUD BINVB AUD BINVB B A Insurance Systems Pty Ltd 01 01 127400 01 07 10 27511 01 08 10 GST Deducted AUD BK INV 01 May BK INV 01 May Total Budget Dog Pet Share Plan 04 04 AUD BINVB AUD BINVB AUD BINVB AUD BINVB AUD BINVB AUD BINVB AUD BINVB AUD BINVB AUD BINVB AUD BINVB AUD BINVB B A Insurance Systems Pty Ltd 126493 26533 126584 126634 126855 126910 126956 127208 127257 01 10 09 01 11 09 01 12 09 01 01 10 01 02 10 01 03 10 01 04 10 01 05 10 01 06 10 19 01 10 19 01 10 19 01 10 19 01 10 24 03 10 24 03 10 24 03 10 03 05 10 03 05 10 BK INV 01 Apr BK INV 01 Apr BK INV 01 Apr BK INV 01 Apr BK INV 01 BK INV 01 BK INV 01 BK
45. 6 PBI 04 0006 PBI 04 0007 PBI 04 0007 PBI 04 0007 PBI 04 0008 PBI 04 0008 PBI 04 0009 PBI 04 0009 04 0009 PBI 04 0009 PBI 04 0009 04 0009 PBI 04 0009 PBI 04 0009 04 0009 PBI 04 0009 PBI 04 0010 Client Code PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT PIGOUT 0 2 001 OASJEOO1 OASJEOO1 0A amp JEO01 0A amp JEO01 0A amp JEO01 0 2 001 0A amp JEO01 0 2 001 0 2 001 PIGOUT Page 23 of Client Name Harry and Mary Smith t as Harry and Mary Smith tas Harry and Mary Smith tas Harry and Mary Smith tas Harry and Mary Smith t as Harry and Mary Smith tas Harry and Mary Smith t as Harry and Mary Smith t as Harry and Mary Smith t as Harry and Mary Smith t as Harry and Mary Smith t as Harry and Mary Smith t as Harry and Mary Smith t as Harry and Mary Smith t as Harry and Mary Smith t as Harry and Mary Smith t as Harry and Mary Smith t as Harry and Mary Smith t as Harry and Mary Smith t as Harry and Mary Smith t as amp J Entertainment trading s GOOD TIMES 20 100 00 8 J Entertainment trading as GOOD TIMES 10 100 00 amp J Entertainment trading as GOOD TIMES 10 100 00 amp J Entertainment trading as GOOD TIMES 10 100 00 8 J Entertainment trading as GOOD TIMES 5 100 00 8 J Entertainment trading as GOOD TIMES 5 100 00 amp amp amp a
46. 7 04 10 REV TEST WRITE AUD 13 05 10 13 05 10 TEST AP JNLC PETRA NEWSTART UNDERWRITING Test AP JNLD 08 PETRA NEWSTART UNDERWRITING N L AUD 13 05 10 13 05 10 Ibais User Manual 7 61 O BA Insurance Systems Chapter 7 Reporting Cash Receipts Listing This report produces a Cash Receipts listing This report can be accessed by selecting Type Accounting then Category Reports then selecting Cash Receipts Listing as shown below Home Account Selection Change Password All Options Favourites Report Cabinets Logout Available Forms and Reports Accounting Y Category Y Sub Category Select Sub Category Favorites Type Category Sub Category Form Report Click to Run Accounting Reports AP Creditor Master AP Creditor Trial Balance AP Creditors Age Analysis AR Customer Age Analysis AR Customer Trial Balance AR Debtor Master Bank Deposit Print Reprint Banking Summary Report Border Report for Reinsurance ash settlement bordereau savanna Cheque Details for UW Client Statements Credit Cards Due To Expire Report Creditor Full Ledger Report Creditor Statements Customer Executive Age Analysis Summary Customer Executive Age Analysis Customer Name and Address Listing Customer Transaction Executive Age Analysis Refine by Description Refine The report allows you to filter by Company Branch leave blank for all Currency defaults to All Bank Code
47. ANCE SYSTEMS Run Date 01 JUN 2008 Run Ti n Memorandum Inception Renewal Client Code Client Name Insurer Name Policy No Broker Fee Renewal Policy Date Date Type Class This is an example of the Brief version of the report Renewal Report Brief with no Schedule Details For Policy End Date from 01 05 2008 to 01 09 2008 Sort by Company Branch Client Phone 500 00 ANN 50 00 ANN COM 75 00 ANN PBI 0 00 ANN TRA 02 99990000 99341245 99990000 02 9999 0000 02070002 29 07 07 29 07 08 BCIB 19 05 07 19 05 08 ULL100 04 05 07 04 05 08 MCCUH 21 08 07 21 08 08 PIGOUT SYDNEY HARBOUR HOTEL ULLADULLA BUS LINES McHudden P L Harry and Mary Smith Vero Insurance Stat Liab ALLIANZ AUSTRAL 18 cgu insurance 20065454DCG3 Zurich Australian Int To Be Advised 22 08 07 07 06 07 09 06 07 22 08 07 27 06 07 19 07 07 19 07 07 24 07 07 01 07 07 01 07 07 28 07 07 27 07 07 11 08 07 22 08 08 07 06 08 09 06 08 22 08 08 27 06 08 19 07 08 19 07 08 24 07 08 01 07 08 01 07 08 26 07 08 27 07 08 11 08 08 PIGOUT Harry and Mary Smith ALLIANZ AUSTRAL 888000002 SCHEMEDOG ONELLY FIGOUT ONELLY ONELLY ONELLY THOMO1 ANTZ ONELLY ONELLY ONELLY Harny and Mary Smith Thomas Gail Antz Pantz Pty Ltd Jenell and assoc cgu insurance cgu insurance TESTO10017 To Be Advised Zurich Australian Ins PBIOG0001 cgu insurance cgu insurance cgu insurance pbi TESTO0000 5 000001 QBE
48. C COM Commercial Package 03050021 15 05 07 19 05 08 13308 COM000016 ALLIANZ AUSTRALIA INSURANCE LTD Commercial BUSINESS 06050008 04 05 07 04 05 08 12615 20085454DC G9 1 Commercial 7 32 400 00 9 00 0 00 100 00 0 00 0 00 0 00 2500 00 0 00 ANN 0 00 ANN 0 00 ANN 0 00 ANN 200 00 ANNA BBB 02 9999 0000 PULSE ISR5 65747000 02 9999 0000 65747000 PNEL 65747000 65747000 FBI 02 89200673 02 9999 1111 65747000 65747000 65747000 02 9999 1111 Search Next Actions REP 14763 10404 actions XLS This is an example of the Summary version of the report Premium Stamp Duty FSL Insurer GST Broker Fee Rebste Amt Policy Fee Fee GST Client Payable Premium Stamp Duty FSL Insurer GST Broker Fee Rebste Amt Policy Fee Fee GST Client Payable Premium Stamp Duty FSL Insurer GST Broker Fee Rebate Amt Policy Fee Fee GST Client Payable Run Date 01 JUN 2008 Run Ti Commission Commission GST State Levy Witholding Tax Due To Insurer Subagent Commission Subagent GST Commission Commission GST Stste Levy Witholding Tax Due To Insurer Subagent Commission Subagent GST Commission Commission GST State Levy Witholding Tax Due To Insurer Subagent Commission Subagent GST BA Insurance Systems Chapter 7 Reporting Search Next Actions REP 1
49. EBTOR 12 10 2007 mepj John Endorsement 07100034 Pleasure Craft TAKEN TEST TAKEON 16 10 2007 cham Chan Amend Renewal 06060010 Fire FLOO1 Flavio Test Client 16 10 2007 cham Mei Chan Endorsement 07100037 OBE Merc CHANDI change 16 10 2007 cham Chan Endorsement 07090020 Merc DAVE DAVES TEST DEBTOR 25 0 2007 VOLF JERRY OLD New Policy CGU Business Test CGU 1 change 250 200 VOL Jerry Volt New Policy CGU Business Test CGU CHANDI change BKTRANS_R35 Suspended Policy Transactions By Transaction Date By User Page 1 of 1 Policies Without Policy Numbers This report enables you to report on all policies in your database which still show To Be Advised in the Insurer Policy Number field On receipt of the policy documentation and policy number from the insurer you can add the Policy Number via the Policy Maintenance option in Transaction Entry Ibais Pulse Test Policies without Policy Numbers Selection nn Policies without Policy Numbers Transaction Date Transaction Date Select Executive No Executive Selected Printing Options Summary Only Preview Mode Printer DEFAULT Run Report Ibais User Manual 7 20 O BA Insurance Systems Chapter 7 Reporting An example of the report is reproduced below Completed Page E of 8 H 4 D Pl Search Search Next Actions REP 15545 154787 actions XLS BA INSURANCE SYSTEMS 23 JUL 2010 14 39 bois Policies w
50. Full Ledger Report Creditor Statements b Customer Executive Analysis Summary Customer Executive Age Analysis Customer Name and Address Listing 00 Customer Transaction Executive Age Analysis Debtor Refund Remittance Advice Debtors Detailed Ageing Reports Debtors Full Ledger Report GL Details Reports Selection GL Diarized Journal Listing GL Financial Reports GL Master File GL Recurring Journal Listing Refine by Description Refine Once in the report screen you can select a specific Customer Account No or leave as default for All and set a Transaction Date or Transaction Date range as per screen below Account Selection Change Password Options Favourites Report Cabinets Logout Debtors History Report Customer Account No Transaction Date Above or Equal to Once you have selected your report criteria click on Run Report The following is a sample snapshot of this report run in detail as opposed to Summary Only option Ibais User Manual 7 67 O BA Insurance Systems Chapter 7 Reporting Ibais Insurance Software EC E O _______ _ EE E 08 9 Completed H of 18 Kk lt b bl search Search Next Actions REPL TRAINING Run Date 18 JUL 2011 15 46 Debtors History Report Open Items for 1442 Amanda Curt Tran Date Curr Original Alloc Alloc Amount 06 05 10 27 10 10 21 10 10 27 10 10 27 10
51. INV 01 BK INV 01 27410 01 07 10 30 06 10 BK INV 01 27520 01 08 10 26 08 10 BK INV 01 GST Deducted AUD Total 2222242 j j AUD BINVB AUD BINVB AUD BINVB AUD BINVB AUD BINVB AUD BINVB B A Insurance Systems Pty Ltd 26383 26601 126925 127049 01 07 09 01 01 10 01 04 10 21 04 10 19 01 10 19 01 10 24 03 10 21 04 10 BK INV PCTSUB BK INV PCTSUB BK INV PCTSUB BK INV DAVE 127388 01 07 10 30 06 10 BK INV PCTSUB 127451 06 07 10 06 07 10 BK INV DAVE GST Deducted AUD Total Fire E SEE serres lt lt C Run Time 22 SEP 2010 14 20 General Ledger Details Report Insurance Details Company Branch From 0 To0 Chart of Account From 400 To 520 Financial Month From 10 April To 11 May Year 2004 Journal id Account No Transaction Effective amp No Date Date Narrative Client Code Reference PHP DREC1 PESO 23 12 09 23 12 09 AR RECPT PESO PESO PESO DEBTOR PHP CFCA10 20 0140 20 0140 Old Bal 1000 00 B A Insurance Systems Pty Ltd Clearing Foreign Exchange B A Insurance Systems Pty Ltd Total Clearing Foreign Exchange 431 AUD CJNLC 06 04 10 16 04 10 Test JNLC narrative 431 AUD CJNLD 16 04 10 16 04 10 Testing JNLD narrative B A Insurance Systems Pty Ltd Creditors Take On Clearing B A Insurance Systems Pty Ltd Total Creditors Take On Clearing AUD CINV3 03 03 10 03 03 10 MJHGBGH AUD 27 04 10 2
52. JOHNOO1 John Brown 6 Yell Street 09 776 5566 MOST MATTOO1 Matthew Park MOST NADIOO1 Nadine Goudie 33 Tranme Auckland Ms Nadine 09 456 3344 nadine xtra co nz BEST NEILOO1 Neil Austin BEST DAISO01 daisy Daisy P O Box 12 Browns Bay 753 Miss Daisy 479983 479984 daisyd xtra co nz BEST lt N N N N N N www dais Reprint credit control letters When necessary you can re print credit control letters To access this option go to Administration Broking Administration Reprint Credit Control Letters Ibais User Manual 7 22 O BA Insurance Systems Chapter 7 Reporting Account Selection Change Password All Options Favourites Report Cabinets Insurance Intermediaries NZ Ltd Welcome Ben Goudie Park BA Insurance Systems Favourites Task Management Insurance Manage all of your business contacts and activites from within Task Access all of your insurance processing functions and insurance client and Management The system can generate business relisted tasks upcoming y i nquiry routines Premium Funding is also available here renewals and you can enter tasks Le Task Management Insurance Claims Accounting including receipting payments clients insurers sub agents and general Accounting Administration his is 3 restricted zone Main undertaken hera Al rates t v L f W aK z D 0 Email support
53. Mercantile Muti 100044 Chubb Insurance TESTO10018 cgu insurance insurance cgu insurance Suncorp 01 TESTO100 TESTO10025 To Be Advised Completed bois Company Branch Client Address Phone Fax Executive Alternate Exec Contact Name FSRA Client Disclosure Document Company Branch Client Address Phone Fax Executive Alternate Exec Contact Name FSRA Client Disclosure Company Branch Client Address Phone Fax Executive Alternate Exec Contact Name FSRA Client ANTZ Antz Pantz Pty Ltd Page of 16 BA INSURANCE SYSTEMS Renewal Report Summary with No Schedule Details For Policy End Date from 01 05 2008 to 01 05 2008 K 4 DDI Sort by Company Branch 0 ci vasdhvs BBBBBBB 2000 02 58890000 BCIB SYDNEY HARBOUR HOTEL cbgjcci ANDS Shen Andrews Retail 0 ULL100 ULLADULLA BUS LINES 61 CHURCH STREET ULLADULLA NSW 2134 93341245 ANDS Sheri Andrews Retail Document GAW 0 MCCUH McHudden P L PO Box 1 SYDNEY NSW 2001 33930000 39390001 ANDS Sheri Andrews Ibais User Manual Policy Class Memorandum Inception Renewal Date Invoice No Policy No insurer Division Subagent Policy Class Memorandum Inception Renewal Date Invoice No Policy No insurer Division Subagent Search BUSINESS 02070002 29 07 07 29 07 08 12851 Stat Liab 5 Vero Insurance COM Commercial ABC AB
54. NSW 2060 123 ABC street BUSINESS NetSub Brokers po Beenleigh QLD 4207 5 PIGOUT Harry and Mary Smith P O Box 12345 BUSINESS NetSub Brokers North Sydney NSW 2060 ABCP001 ABC Promotions 123 Main Street BUSINESS NetSub Brokers Brisbane QLD 4000 06070029 01 07 Antz Pantz Pty Ltd PO Box 123 NetSub Brokers 10 000 00 North Sydney NSW 2089 01 4 108 BayRoad BUSINESS NetSub Brokers 25 000 00 Waverton NSW 2060 02070002 SYDNEY HARBOUR HOTEL cbgjccj BUSINESS NetSub Brokers vasdhvs 2000 8 PIGOUT Harry and Mary Smith Box 12345 NetSub Brokers 1 000 00 North Sydney NSW 2060 Ibais User Manual 7 29 O BA Insurance Systems Chapter 7 Reporting Outstanding Renewals Report With Schedules This report is intended for those using Standard Schedules who wish to print a copy of the latest schedule for each policy on the Renewals Report B Renewal Reports Outstanding Renewal Report by Client Outstanding Renewals by Client by Debtor Outstanding 1 Renewals Report with Schedules Renewal Report with Text Schedule l Completed BA INSURANCE SYSTEMS bois Memorandum No Status 07050005 06050008 03050021 07050008 02040007 07110016 07110017 07060005 07060006 07060001 06060005 07060004 07060003 07060002 08060009 07060012 06060020 06060025 07090001 07060013 07080004 06070028 07070002 06070031 07070003 07070004 07070005 07070006 06070015
55. OB Brown Bros Printing BUSINESS 1 500 00 300 00 50 00 PBI000003 07090012 01 08 07 01 08 08 BROB Brown Bros Printing BUSINESS 1 500 00 300 00 50 00 PB101000004 07090013 01 08 07 01 08 08 BROB Brown Bros Printing BUSINESS i 1 500 00 300 00 50 00 PB101009005 07090014 01 08 07 01 08 08 BROB Brown Bros Printing BUSINESS i 1 500 00 300 00 50 00 10000002 07090015 01 08 07 01 08 08 BROB Brown Bros Printing BUSINESS i 1 500 00 300 00 50 00 PBI0100030 Total Client BROB Brown Bros Printing 7 500 00 250 00 07080002 01 09 07 01 09 08 JHETOO1 Jhet Sparrow BUSINESS Zurich Australian Insurance 4 000 00 0 00 Total Client JHET001 Jhet Sparrow 4 000 00 0 00 06060002 21 08 07 21 08 08 PIGOUT Harry and Mary Smith Travel Zurich Australian Insurance 1 000 00 0 00 06060003 22 08 07 22 08 08 PIGOUT Harry and Mary Smith Bankers Blanket Bond El ALLIANZ AUSTRALIA INSURAN 10 000 00 400 00 Total Client PIGOUT Harry Smith 5 Pig Out Cafe 11 000 00 400 00 06070027 24 07 07 24 07 08 THOMO1 Thomas Gail BUSINESS 25 000 00 2 500 00 Total Client 01 Thomas Gail 25 000 00 2 500 00 Total Exec Sheri Andrews 58 500 00 3 650 00 Ibais User Manual 7 28 O BA Insurance Systems Chapter 7 Reporting Outstanding Renewals By Client By Debtor This report is intended for Underwriting Agents as it also shows the Broker for each policy rather than just the Insured WEES e Se ARR RES EE jJ ELFEN FPE PRET All gt 2
56. Report Creditor Detail Report No Creditor Report Earned Amounts Life Non Life No Earned Amounts Life Non Life No Insurer Detailed Ageing by Insurer Type No Invoice Summary report No Monthly Earned Selection No Oustanding Claims by Insurer No Outstanding Claims Selection No Outstanding Premium Warranty Report No Outstanding Renewal Report No Sunrise Policies Requiring Closure No M No Trust Accounting Reports i No Unallocated Cash Listing No Underwriter Tax Invoice No Claim Record Sheet No Claims Oustanding and Paid No Comparison Between Government and Private Hospital No Refine by Description Ibais User Manual 7 34 O BA Insurance Systems Chapter 7 Reporting Selecting Trust Accounting Reports from the menu above displays the following screen Home Account Selection Change Password All Options Favourites e Trust Accounting 7 Trust Account Summary Report Trust Trial Balance Report w Control Total Balancing Report Brokerage Earned Summary Report Debtor Ageing Reports Creditor Reports Return Premiums Reports Unallocated Cash Listing B Brokerage Earned Reports Trust Accounting Reports Trust Accounting Reports are designed to provide information on the state of the business from trust banking perspective All of these reports provide information on funds either in the trust bank or owed to or from the trust bank or banks for the broker clients
57. Subagent Subagent Nett Profit Nett GST Premium Gst Comm GST Incl Comm GST Funding Incl S g Sifg Agmnt D5100001 fardvark Ente 100 00 10 00 0 00 0 00 100 00 05100021 Geppetto and 1 1 i 2400 00 240 00 288 00 28 80 3112 00 05100022 Geppetto and 3 5 600 00 60 00 72 00 7 20 628 00 05100029 Geppetto and 1400 00 140 00 168 00 16 80 2232 00 05100030 Geppetto and d 300 00 30 00 36 00 3 60 364 00 05100021 Geppetto and 1 5 d 2500 00 250 00 300 00 30 00 3200 00 05100027 Houdini i 1000 00 100 00 0 00 0 00 1000 00 03050001 Harry Smith t 107 20 10 72 0 00 157 20 05100025 Harry Smith t 0 00 0 00 0 00 0 00 03050001 Harry Smith t 5 120 00 0 00 170 00 05100025 Harry Smith t 4 3 4 1000 00 1 0 00 1500 00 05100020 fardvark Ente d 1 87 50 0 00 87 50 03050001 Harry Smith t 1 137 60 0 00 187 60 03050001 Harry Smith t T A 140 00 0 00 4 190 00 05100006 Horsin Around 4 3 240 00 0 00 390 00 Hungry Dog 1 0 00 1 0 00 d 0 02 05100005 Hungry Dog P 1 il 70 00 0 00 1 70 00 05100011 Mr amp Mrs M Gr 1 3 3 330 00 0 00 A 480 00 05100012 Mr amp Mrs M Gr 4 1 j 350 00 1 0 00 500 00 amp rs Gr 8 j 0 00 0 00 0 03 05100011 Mr amp irs M Gr 1 i 350 00 0 00 500 00 05100016 Mr E Fudd 113 75 4 0 00 4 163 75 fardvark Ente 3 3 0 00 0 00 0 03
58. Systems Chapter 7 Reporting Running Reports to Report Cabinets Every report that is run can be stored into a cabinet As shown in the following example ii Sales by Invoice Type Summary Report Click on the down arrow to Printing Options get a display of options Preview Mode DEFAULT Run Report DEFAULT Email to sheri bais com au as a Spreadsheet Email to sheri bais com au as a HTML Store in Cabinet General Reporting in the Temporary Drawer Store in Cabinet End of Day in the Temporary Drawer Store in Cabinet End of Month in the Temporary Drawer Click to select where you want to store the report Click Run Report and the following message will appear BScript x 1 Report Submitted to the Cabinet BAGENCAB in the drawer TEMPORARY_chac The report will then be placed in the selected Cabinet as a Temporary File as shown in Viewing the Reports in the Report Cabinets Once the function is complete you may exit Please Note A temporary drawer may only be accessed by the user that owns the drawer Ibais User Manual 7 4 O BA Insurance Systems Chapter 7 Reporting Viewing the Reports in the Report Cabinets Go into the Report Cabinets and the reports will now be displayed as follows Cabinet Report Interface Available Drawers lt TEMPORARY Chambers Cathy Available Cabinets a 2 General Reporting End of Day End of Month
59. This Renewal Report can be run Company Branch Exec and by Insured if none selected it will include all The date range captures policies expiring within the selected dates Ibais User Manual 7 27 O BA Insurance Systems Chapter 7 Reporting Account Selection Change Password All Options Favourites Report Cabinets 3 Renewal Reports Outstanding Renewal Report Outstanding Company Branch Renewal Report by Client Executive Outstanding Insured Renewals by Client by Debtor Period End Above _ Outstanding Renewals Report Period End Below with Schedules _ Renewal Report with Text Printing Options Schedule Summary Only Preview Mode Printer Run Report Completed Page of 6 Kid DDI Search 77 SearchNext Actions XLS BA INSURANCE SYSTEMS Outstanding Renewal Report D sa insurance svsrews This is an example n 5 ANDS Sheri Andrews of the report LS LE Period Start 01 07 08 01 09 08 Memo No Status Start End Quote Insured Insured Name Class Description insurer Name Premium Brokerage Brokers Fee Policy No 06070029 A 01 07 07 01 07 08 ANTZ Antz Pantz Pty Ltd pulse Chubb Insurance Company Austr 10 000 00 0 00 0 00 TESTO10018 Total Client ANTZ Antz Pantz 10 000 00 0 00 0 00 02070002 29 07 07 29 07 08 BCIB SYDNEY HARBOUR HOTEL BUSINESS 1 000 00 50 00 500 00 Total Client BCIB SYDNEY HARBOUR HOTEL 1 000 00 50 00 500 00 07090011 01 08 07 01 08 08 BR
60. action Narrative Amount Date KOOLOO1 14 12 09 Cash Rec 354854 943 30 BK HBG 15 12 09 Cash Rec 53411 5 966 50 GLENOO1 15 12 09 Cash Rec CASH 2 500 00 GLENOO1 15 12 09 Cash Rec CASH 1 047 77 GLENOO1 15 12 09 Cash Rec 2358 2 841 10 JAMEOOT 15 12 08 Cash Rec 562 1 798 50 1 15 12 09 Cash Rec 0045897 23 451 14 SANTOO 15 12 09 Cash Rec 5487612 5 748 70 SANTOO1 15 12 09 Cash Rec 548764 1 157 36 SANTOO 15 12 09 Cash Rec 44466 412 30 SANTOO 15 12 09 Cash Rec 221 115 00 SANTO01 16 12 09 Cash Rec 54654 1 834 11 GLENOO1 21 01 10 Cash Rec 1 1 500 00 ALLEOO1 29 01 10 Cash Rec 1234 1 199 00 GLENOO1 04 02 10 Cash Rec 00345 544 00 GLENOO1 04 02 10 Reverse Receipt 15 544 00 1442 06 05 10 Cash Rec CASH 234 80 BK HBG 06 05 10 Cash Rec 1111 1 512 65 JAMEO01 06 05 10 Cash Rec CASH 2 997 55 JAMEO01 06 05 10 Cash Rec CASH 2 997 45 TRAIOOT 25 10 10 Cash Rec 54838 128 550 62 1442 27 10 10 Cash Rec 77653 843 79 1442 27 10 10 Cash Rec 887643 244 00 1442 27 10 10 Cash Rec 8765 791 00 FROGO01 27 10 10 Cash Rec 1111 17 941 00 FROGO01 27 10 10 Cash Rec 122 175 00 FROGOO1 27 10 10 Cash Rec 4564 79 474 70 GLENOO1 27 10 10 Cash Rec 123 540 00 PITTOO1 27 10 10 Cash Rec 00987 4 205 20 PITTOO1 27 10 10 Cash Rec 887 720 16 SMITO02 27 10 10 Cash Rec 0098 3 494 48 GILMOO1 03 05 11 Cash Rec 00034 1 630 64 BKTRUST DET R20 Trust Bank Movements Section 26 Report 1 5 Policy Transacti
61. alment New Policy Renewal Inception Date From Inception Date To Transaction Dat sFrom Transaction Date To Once you have selected your report criteria click on Run Report The report produces the information in Memo Number ascending order The following is sample snapshot of this report run in detail as opposed to Summary Only option which is also available Ibais User Manual 7 12 O BA Insurance Systems Chapter 7 Reporting BAIS Training Page Control mn 77 Completed Page B of 17 4 bb Search Search Next Actions REP 15907 58794 actions XLS Run Time 20 JUL 2011 11 49 10 04 08 10 10 08 1040 07 10 1008 3934 011007 01 10 98 1 237 50 011007 0140 08 1337 50 011007 0140 08 1 683 00 011107 0140 08 131693 011007 0140 08 2 997 50 011007 0140 08 011007 0140 08 011007 0140 08 01 1007 0140 08 121107 0140 08 0210 07 0240 08 1040 07 1040 08 0310 07 0340 08 030408 0340 08 01 01 08 0340 08 0310 07 0340 08 03 04 08 0340 08 03710007 0310 08 D 031007 0310 08 m 031007 0310 08 03710007 0310 08 031007 0310 08 0310 07 0310 08 031007 0310 08 285 ST 0310 07 0310 08 0310 07 0310 08 4 051207 0310 08 Code TRAIN TRAIN ANDS ANDOS ANDS ANDOS ANOS ANDOS ANDS ANDS ANDS ANDS ANDS ANOS ANDOS ANDS ANOS ANDS ANDS ANOS ANOS ANDS ANOS ANOS ANDOS ANDOS ANDS ANOS ANDOS ANOS
62. arch Next Actions REP 15105 20609 actions XLS B Insurance Systems Pty Ltd 4 BAIS Executive Memo No Period End Class Insured Client Name Run Time 09 MAY 2009 09 52 Expired Policies To AGT Agent 07110042 01 01 2008 HH Householders 01 change AGT Agent 08020018 01 03 2008 MMHP Merc CHANO 1 change AGT Agent 08020040 01 03 2008 Merc 1 change AGT Agent 02020044 01 03 2008 MMHP Merc CHANO change AGT Agent 08020046 01 03 2008 MMHP QBE Merc CHANOT change AGT Agent 08060006 01 06 2008 MMHP QBE Merc CHANOT change AGT Agent 08060022 01 07 2008 AUHH Australian Unity Householder 1 change AGT Agent 08060007 01 08 2008 MMHP Merc CHANO1 change AGT Agent 08060023 01 08 2008 MMHP Merc CHANO change AGT Agent 07100037 01 10 2008 MMHP Merc CHANO 1 change AGT Agent 07100039 01 10 2008 MMHP Merc 1 change AGT Agent 08020016 01 10 2008 MMHP QBE Merc CHANO change AGT Agent 07120016 01 12 2008 Householders CHANO change AGT Agent 07120051 01 12 2008 Householders 01 change AGT Agent 07120024 05 12 2008 Householders 01 change AGT Agent 07120003 10 12 2008 Householders 01 change AGT Agent 08050003 01 01 2009 l QBE Merc 1 change AGT Agent 08050016 01 01 2009 TEST CLASS 01 change AGT Agent 08050058 01 01 2009 Combined Business Pak 01 change AGT Agent 08050060 01 01 2009 Combined Business Pak
63. ate a new draw option Click to indicate you wish to create a new drawer Create a new draw This will then enable the New Drawer Details field New Drawer Details Drawer Description Ibais User Manual 7 7 O BA Insurance Systems Chapter 7 Reporting Enter the description or name of the drawer Ensure the description is meaningful and is what drawer is intended for Complete the following steps to store the report The Report Description field will now be enabled Report Description AP Creditors Age Analysis Click to enter a report description Ensure that it will make it easy to identify the report at a later date i e Creditors Age Analysis October 2007 The next step is to complete the Access for Me Only field Access for Me Only If the field remains at the default which is as ticked only you may access the report and drawer To assign access to other users Click to remove the tick and the following will appear Select Groups that you wish to access this report Ibais Released Development Group Ibais Broking Administration Click on the selected group you want to give access to Please Note This will vary in each office according to the access groups that you have set up You will then be required to set up the Report Purge Details Report Purge Details Auto Purge After Date Auto Purge Days The report will purge from the cabinet after the date or number of days set Clic
64. bais com au Administration Phone 612 99341888 Fax 61299341889 Select Broking Administration Select Re Print Credit Control Letters Home Account Selection Change Password All Options Favourites Report Cabinets Bro kin z z Reprint Credit Control Letters 25 FSRA Details E ae ae eae Input the date of re printed Statutory Charges BH Client Code Client Name Marine Details Codes File L System Codes L Executive L Glabal User Actual Insurers General Letter Template System Leave blank to print entire run or sings input one or more client codes to print only selected clients letters Trust Bank Account Premium Funder Re Print Credit antral Letters End of Period Ibais User Manual 7 23 O BA Insurance Systems Chapter 7 Reporting Transaction Listing by Transaction Date This report lists all transactions by date range and can be selected by Company Branch and Executive leave blank to include all Home Account Selection Favourites Report Cabinets All Options Run Report Change Password Logout Transaction Listing by Transaction Date Transaction Date from ot 03 2010 Transaction Date to 31 03 2010 Company Branch Executive Include Statutory Charges Exclude Placing Slips Quote Covernote You can also choos
65. e amount available to draw Brokerage Earned Summary Report This Financial Year or Last Year Period Company All Companies Currency All Currencies Company or Company Branch Company Branch Input the selection criteria you can leave Company and Currency blank to include all Companies and Currencies Click Run Report A sample Brokerage Earned Summary Report is reproduced below Run Date 11 JUN 2007 Run Time 15 49 Brokerage Ea med Summary Re port For Financial Year 2004 and Financial Month 1 sorted by Compan yBranch by Currency bois ent RSR Currency AUD AUSTRALIAN DOLLARS Client Fees Commission Forei Ps Brokers Fee Brokers Comm Brokers GST Subagent Variance Exd Subagent Exd Subagent Commission 0 00 000 1266 22 Total Broker s Profit Broker s Commission nett of Subagent Commission Fee less Rebate Currency Gain Aveil to Withdraw Total of GST Commission GST incl Subagent GST Fee GST Overseas UW retained GST Claims GST Avail to Withdraw Total amount in Trust for Brokerage GST and Currency Gain mmmnvc ANG to Withdraw Ibais User Manual 7 41 O BA Insurance Systems Chapter 7 Reporting Debtors Ageing Report This function allows you to run a Debtors Ageing Report The report shows in detail or summary all invoiced items owed to you by a debtor broken down into current 30 60 and 90 days it also included all monies in unallocated cash
66. e to include the Statutory Charges and any Placing Slips Quotes and Covernotes if required Click Run Report when selection criteria has been input Example of the report of 4 Search Search Next Actions REP 15446 99384 actions Completed Page Kd DDI BA INSURANCE SYSTEMS bois Insured 15 APR 2010 11 04 Transaction Listing by Date For Transactions from 01 03 2010 to 31 03 2010 Invoice Premium Number Effect Entere Start By Insured Name Tran Date Brokerage Brokers Fee 01 03 2010 01 03 10 staj 100 00 0 00 0 00 ANTZ ANTZ SCHEMENEL SCHEMENEL SCHEMENEL SCHEMENEL TEST U TEST U TEST U DAVE TEST U Antz Pantz Antz Pantz Scheme Nel Scheme Nel Scheme Nel Scheme Nel TEST USER INCorporated TEST USER INCorporated TEST USER INCorporated Dave s Test Debtor TEST USER INCorporated pulse pulse pulse pulse OWN DAMAGE amp LIABILIT OWN DAMAGE amp LIABILIT pulse pulse pulse pulse Motor Vehicle Motor Vehicle Motor Vehicle QBE Test Home BURGLARY INSURANCE BKTRANS R12 Transaction Listing by Transaction Date Ibais User Manual 01 03 2010 01 03 2010 01 03 2010 01 03 2010 05 03 2010 05 03 2010 05 03 2010 08 03 2010 08 03 2010 08 03 2010 08 03 2010 09 03 2010 10 03 2010 11 03 2010 11 03 2010 11 03 2010 11 03 2010 15 03 2010 16 03 2010 07 08 09 07 08 10 01 04 10 01 04 10 01 01 10 03 01 10 04 12 10
67. ebtor only Please Note Ageing Date this defaults to today s date it is usually better to leave the date as the default date unless you wish to see the future position In this case it will report on the SAME transactions but age them based on the date input Click Run Report when selection criteria has been input Ibais User Manual 7 42 O BA Insurance Systems Chapter 7 Reporting A Sample Debtors Ageing Report is reproduced below Completed Page of 1 DDI search Search Next Actions REP 12294 actions gt BA TRAINING Run Date 08 05 2007 Run Time 17 24 Debtors Detailed Ageing with Broking A amp mounts Sort by Company by Currency by Debtor Name For Debtor WOOD Ageing Date 08 NOV 2007 o Company D BA Insurance Systems B A I S Currency AUD AUSTRALIAN DOLLARS Invoice Invoice Policy Number Effective Underwriter 90 Days 60 Days 30 Days Current Balance Commission Commission Brokers Fee Brokers Date Number Date Flag GST Fee GST wooo Geppetto and Pinoccio Wood Ph 9996669 Bus 9809090 Fax 9990098 Email wood hotmail com au Contact Geppetto Wood 13 10 05 153 05100022 23232377HOP 13 10 05 ROYAL 12790 25 d 0 00 12790 25 1500 00 150 00 1000 00 100 00 13 1005 154 05100022 78900099C 0M 15 10 05 Cou 5721 32 0 00 5721 32 j 100 00 10 00 13 10 05 155 05100030 To Be Advised 15 10 05 ROYAL 1993 60 1 1 1993 60 Totals for Debtor WOOD Suspense 0 00 Totals for Company and Currency 0 4
68. egory Sub Category Select Sub Category Favorites category CE Favorites On line Quoting No aj Recovery Transactions Creditor Detail Report No Creditor Outstanding with Broking Details Debtor Outstanding with Broking Details Earned Amounts Life Non Life Income Reports Insurer Annual Income Report Insurer Detailed Ageing by Insurer Type Invoice Summary report Key Reports Monthly Sales by Client Monthly Summary Premium Oustanding Claims by Insurer Outstanding Claims Selection Outstanding Premium Warranty Report Outstanding Renewal Report Invoice Report Trust Accounting Reports Refine by Description Click on Sunrise Policies Requiring Closure and the following screen will appear Web Page Dialog Sunrise Policies Requiring Closure Printing Options Preview Mode DEFAULT 2 Run Report Click Run Report and the following report will appear Ibais User Manual 7 58 O BA Insurance Systems E Web Page Dialog Completed Page of 12 A Insurance Systems Pty Ltd bois Executive Trx Date hemo Policy No ANDS 220207 POL 07020049 H 901419 ANDS 22 0207 POL 07020050 H 901420 ANDS 140307 POL 07030026 H 901461 ANDS 03 06 07 POL 07060006 SUNO27394N SUV ANDS 08 10 07 POL 07100018 H 901663 Chapter 7 Reporting 0 H 4 DDI Search Search Next Actions REP 14568 13851 actions Sunr
69. enewal Summary _ Production Summary REP 15123 28461 27 05 09 09 29 100 Team Reports REP 15122 28304 26 05 09 17 25 100 Select the report s you would like to print or You may email by clicking in the select box alongside Click on the report name any header onthe toolbar and the reports will re sort File View Contains the files that are available to be Refresh File Listing Print Selected Email Selected Select All Clear Select Click Print Selected or Email Selected once your selection is made and the selected reports will be emailed to you Please Note Cabinets and Drawers may be set up with restricted access This provides security for reporting Ibais User Manual 7 2 O BA Insurance Systems Chapter 7 Reporting Reports in report cabinets can be printed or emailed From the main Cabinet screen you can select to print or email one or more reports as shown above From within the Report Preview screen you can also email a report to yourself as shown below Completed Page of 2 bb Search Search Next Actions REP 15220 80072 actions XLS REP 15220 80072 actions BA INSURANCE SYSTEMS Trust Trial Balance Report Pri nt Preview Email Report to Self For all companies and all currencies Delete this Report bois Currency AUD AUSTRALIAN DOLLARS Account Number Account Name Debit Amt Credit Amt BANK 050 Trust Bank Account number 050
70. ent of Account Printing Options Preview Mode Printer DEFAULT E Run Report Ibais User Manual 7 56 O BA Insurance Systems Chapter 7 Reporting The completed statement will look like the following S STATEMENT OF ACCOUNT e For he Mon 07 OCTO 2007 EISE eA B A I S Cien t Geppett and Vbod 1 of Fage 1 01 1 BA marae 317 Padt Hwy Mont OCTOBER 2007 WORTH SYDNEY NOW 2060 Cibnt Wooo Teephore For In malon comerring Nis account contact Tammy Taree Cur Feferenoe OCTOBER 1010005 Geppe lio Phob OCTOBER 1005 Geppe lio Pinoacio OCTOBER 1005 Geppe b and Phob Wood OCTOBER 31 10 07 All am ounte are In Please all landing urgenty AUST RALIAM DOLLARS Geppetto and Pinoccio Wood 12 Jones Road HG AEASERE U PM Sydney THIS ADWCEWTH YOUR CHEQUE Ibais User Manual 7 57 BA Insurance Systems Chapter 7 Reporting Sunrise Policies Requiring Closure This report shows new business and renewal policies not yet closed It should be run as part of your regular Sunrise housekeeping The Sunrise Policies Requiring Closure report is accessed via the All Options tab at the top of the screen or via your Favourites Home Account Selection Change Password Options Favourites Logout Available Forms and Reports Type Select Type z Category Select Cat
71. es you can leave it blank Click Run Report A sample Return Premium Report is reproduced below Print amp Pagel 92 gt 7592 BA TRAINING Pun Dak 01 2007 Return Prem ium c Report d For Credi lor Type UVY Underwater De Canpay 0 B marance zlemz Currency AUD AUSTRALIAN DO LLARS B A I S Takentom Creditor bul Nol Pad Io Dole No Cleri Name Creditor Code Creditor Name Soler Execulive Name Policy Number No Hel amani CATZ Arcomilionng Ply LM cou CGU haraxe Toby To Be Advised B2 3 33 SONOS CUB MET Nel Paying Ab Agen ALLIANZ Alar Mar ace Sen CAPES 5569 35 Toti brRP 2t c Amounts Taken tom Creditor but Not Pald Cilent 6262 68 BEREPO PTZ RSD Reken Premium Report Ibais User Manual 7 45 O BA Insurance Systems Chapter 7 Reporting BA TRAINING Pin Dak O01 NOV 2007 Time 1258 Return Premium Report d For Credi kor Type UVY Underwater Creditors Canpayw hnrance 4 Currency AUD AUSTRALIAN DOLLARS B A I S RPZlhur Amount Pal Io Clleni buf Nol Taken tom Credllor Cleri Name Credika Code Creditor Name Evecudve Name Policy Number twoke No Amount WIO Fen ch Echo ALLIANZ Alorc ace Tom Trairee a 155 20284 osos KELLTRII Mda telly ALLIANZ Alarc ace Tom
72. etplan Claims Reported Claims not Reviewed by Date Comparison Between Government and Private Hospital Developments In Last Quarter Claim Numbers Diary Report for Claims Review Process comm Motor Claims Oustanding and Paid Outstanding Claims by Client Outstanding Claims by Executive ssp Re Refine by Description Refine Once in the report screen you can select a specific Customer Account No or leave as default for All and set a Transaction Date or Transaction Date range as per screen below Account Selection Change Password All Options Favourites Report Cabinets Logout Claims Listing Run Re B Financial Month Nane Selected Financial Year None Selected Use the From and To Transaction Date fields to select a starting date or end date or a range of transaction To Transaction Date dates for your report Once you have selected your report criteria click on Run Report The following is a sample snapshot of this report note these is no summary report option available Ibais User Manual 7 69 O BA Insurance Systems Ibais Pulse Test Page Control Completed BA INSURANCE SYSTEMS bois Claim No PBI 04 0002 PBI 04 0002 PBI 04 0003 PBI 04 0003 PBI 04 0003 PBI 04 0003 PBI 04 0004 PBI 04 0004 PBI 04 0004 PBI 04 0005 PBI 04 0005 PBI 04 0005 PBI 04 0006 PBI 04 000
73. hapter 7 Reporting Completed Page of 22 Id4 bb search Search Next Actions REP 15105 20592 actions XLS 7 B Insurance Systems Pty Ltd Run Time 09 MAY 2009 Broking Transactions for Insurer Transaction Date From 01 01 00 Transaction Date To 09 05 09 Insurer AIG AIG Insurance Insured Name Debtor Name Inception Expiry Invoice Policy No Esse Premium Gross Premium Claims Excess Applicable Date Date Number Hist Disc Trailer l c Home Base Radius Of Ops No Of Broker Contact Yesr Last Prev Year Yeer Haz Goods Extension Resuit Units No Claims 5 Claims 5 Claims 5 State Charges Executive Name Class Type Tran Date Fire Service IPL GST Stamp Duty Admin Fee Commission Ares Levy Gem Jewellers Pty Ltd and Gem Jewellers Pty Ltd 01 02 06 01 02 07 120132 06050082 PPMV0500070 1 000 00 NSW M Mike Jones PMY 25 05 2006 0 00 0 00 100 00 5 0 70 00 100 00 Gem Jewellers Pty Ltd and as Gem Jewellers Pty Ltd 01 02 07 01 02 08 120237 06050082 PPMV0600070 1 000 00 1 122 00 NSW M Mike Jones PMY REN 31 05 2006 0 00 0 00 100 00 55 50 00 Gem Jewellers Pty Ltd and as Gem Jewellers Pty Ltd 01 04 06 01 04 07 120213 06050100 0600072 2 300 00 NSW M Mike Jones PMY 20 05 2006 0 00 0 00 138 00 148 40 80 0 i 50 00 Gem Jewellers Pty Ltd and ss Gem Jewellers Pty Ltd 01 04 07 01 04 04 120214 06050100 PPMV0700072 3 100 00 NSW M Mike Jones PMV t 30 05 2006 0 0 0 00 186 00 2 80 00 310 00 50 00
74. ia on which you wish the report to be based Click Run Report A sample of the Earned Amounts by Invoice Type Report in summary is reproduced below E Ibais Insurance Software Page Control re sen 222 0 esau 1 Completed Page of 1 Id4 b b Search Search Next Actions REP 14569 14077 actions BA TRAINING Run Date 20 NOW 2007 Run Time 14 18 Earned Amounts by Invoice Type Summary Report Summary For Financial Year 2004 and Financial Month 1 Company Branch ALL Al Company Branches Summary Invoice Type Gross Amt Broker Fee Fee Gst Bk Comm Comm GST Base Premium FBC WWHT Fire Lewy Stamp Duty Nett Subagent SfAg GST Broker Profit New Business 710449 90 932 88 193 09 118574 72 10635 62 611701 51 2651 70 4947 00 4810 96 575358 63 767 60 76 76 120274 20 Rebroked Rnls 1982 99 50 00 5 00 240 00 24 00 1200 00 0 00 0 00 0 00 1663 99 28 80 2 88 261 20 Renewals 87299 34 2718 40 271 84 10799 48 953 96 4492 99 305 00 1843 00 801 90 71753 76 929 68 92 97 12588 20 Endorsements 12413 32 170 00 17 00 1694 16 117 41 8829 71 130 57 857 84 345 06 10069 69 152 75 15 28 1711 41 Reversed NB 5033 95 342 66 34 26 539 71 31 84 3587 72 55 56 364 94 146 80 4692 52 13 31 1 33 183 74 Reversed Rnl 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Endorsements 1448 70 100 00 10 00 80 00 20 00 1000 00 0 00 0 00 0 00 1458 70 0 00 0 00 20 00 Joumals Os 5 89 6 89 0 00 1 00 0 00 0 00 0 00 0 0
75. ise Policies Requiring Closure Company Start 22 02 07 22 02 07 20 03 07 01 06 07 08 10 07 Insurance Systems Pty Ltd R End 22 02 08 22 02 08 20 03 08 30 06 07 08 10 08 Insured Name Fot z amp Pantz Clothing Co Ltd Fet 2 amp Pantz Clothing Co Ltd amp Pantz Clothing Co Ltd Ant z amp Pantz Clothing Co Ltd Fet 2 amp Pantz Clothing Co Ltd Class Description Pustralian Unity Householder Pustralian Unity Householder Pustralian Unity Householder Ins household Fustralian Unity Householder 19 NOV 2007 15 09 Premium Net Brokerage 639 00 187 38 639 00 187 38 328 50 70 63 3 566 00 71 32 652 50 140 29 TUE Unclosed Sunrise Policies sorted by Transaction Date Bo el This report will list the policies that are unclosed Should you want to close the policies please follow the Manual Close steps as detailed Ibais User Manual 7 59 O BA Insurance Systems Chapter 7 Reporting General Ledger Details reports There are 3 basic formats of General Ledger Details reports with each providing the option to report on a previous year s transactions If Foreign Currency applies then each of the reports will also be available in Foreign Currency General Ledger Details reports are accessed from the Accounting menu or All Options gt Accounting gt Reports GL Details Reports Selection General Ledger Details Report Selection Report Format C
76. ithout Policy Numbers Account Executive Executive Name Client Name Transaction Date Transaction Type Classifit Memo No Policy Number Brokers Name ANDS Mary Montgomery change to jenell 24 06 10 QUC PULSE 10060025 To Be Advised nelly change to jenell 02 07 10 TKO PULSE 10070011 Be Advised nelly Antz Pantz Pty Ltd t as Antz 13 06 08 INS LIA 06080012 To Be Advised Antz Pantz Antz Pantz Pty Ltd tas Antz 04 08 10 POL TCI 10060002 To Be Advised Antz Pantz Antz Pantz Pty Ltd Vas Antz 28 06 10 END 10060003 Be Advised Antz Pantz Fred Nert 22 06 10 POL 10060021 To Be Advised Fred Nert Jnr Mr Paul Newman 22 06 10 END 10060019 To Be Advised Mr Paul Newman Harry and Mary Smith t as Pig Out Cafe 04 05 04 04050001 Be Advised Harry and Mary Smith t as Pig Out Cafi Harry and Mary Smith t as Pig Out Cafe 06 01 09 08120011 To Be Advised Harry and Mary Smith t as Pig Out Cafi Harry and Mary Smith t as Pig Out Cafe 23 08 10 10060024 To Be Advised Harry and Mary Smith t as Pig Out Harry and Mary Smith t as Pig Out Cafe 02 07 10 10070005 Be Advised Harry and Mary Smith t as Pig Out Customer Name and Address Listing This report produces a Client Name and Address listing The report allows you to filter by Executive Division Subagent and Client status Active Inactive Please Note This report is too large to print and is intended to be run to spreadsheet Customer and Address Listing Run Report M Clear
77. k on the field and input the data Once you have completed the fields you may Submit C Cancel If you Click on Submit the report will be saved into the nominated drawer and cabinet Ibais User Manual 7 8 O BA Insurance Systems Chapter 7 Reporting Broking Reports Invoice Summary Report This report lists all invoices processed for a financial period or a selected date range Invoice Summary Use current financial month 1 04 Nominate either current financial month displays for you or From and To date OR Trans From Date 01 11 07 Trans In 15 11 07 Enter or look up Executive or Subagent or leave blank to get all Executive or Subagent ANDS Sheri Andrews Sort Sequence Invoice number Sort by i Invoice number Invoice number Executive Print Version with Subagent vw Sub Agent Transaction Date Clear Click if you require the report to display the subagent s When you have selected your sort criteria Click Run Report to print the report sample of the Invoice Summary Report is reproduced below BA TRAINING Invoice Summary Report 29 15 29 Period Start 01 11 2007 Period End 15 11 2007 BAIS Exec Date Invoice No Client Policy No Memorandum Basic Premium Brokerage GST Comm GST Fee Exec Type Underwriter Stamp Duty FSL Brokers Fee Other GST Amount Gross Amount Subagent 12 1107 1185 NEwCoo1 To Be Advised 07100002 165 98 33 20
78. lick Run Report when selection criteria has been input A sample Creditor Report is reproduced below Web Page Dialog Completed Page of 1 Search Search Next Actions REP 12291 actions BA TRAINING Run Date 08 NO 2007 Run Time 17 05 Creditor Summary Report For Creditor Type UW and Fully Paid Y and Part Paid Y and Unpaid Y and Retum Premiums Y 0 BA Insurance Systems B A I S Currency AUD AUSTRALIAN DOLLARS Credit No Total excl Jnls Creditor Creditor Name Terms of 90 Days 60 Days 30 Days Current Suspense Joumals Total amp Suspense LL Se ALLIANZ Alianz Insurance 90 days 6815 60 0 00 4643 34 15879 04 0 00 0 00 27337 98 27337 98 CGU CGU Insurance 90 days 8611 31 9320 00 2464 66 3262 83 0 00 0 00 23658 80 23658 80 GLOBAL Global Underwriting Services 60 days 157031 77 179 24 179 24 440 98 0 00 0 00 157831 23 157831 23 LLOYDS Lloyds of London 90 days 4968 00 29580 00 770 00 22747 10 0 00 0 00 58065 10 58065 10 Insurance Ltd coo 8630 71 0 00 0 00 0 00 0 00 0 00 8630 71 8630 71 912277 Mercantile Mutual 90 days 2356 81 0 00 129040 00 0 00 0 00 0 00 130396 81 130396 81 ROYAL Royal Sun Aliance 90 days 17 104 42 0 00 0 00 15253 26 1500 00 0 00 33857 68 32357 68 5010 5610 Insurance 90 days 1377 53 0 00 440 00 525 41 0 00 0 00 2342 94 2342 94 SUNCORP Suncorp 90 days 803 22 0 00 0 00
79. lows you to analyse business lost Click to run Key Reports and the following screen will open Ibais User Manual 7 14 BA Insurance Systems Chapter 7 Reporting Account Selection Change Password All Options Favourites Report Cabinets Logout Key Reports Key R eports Sales b voice M Jis Type Re Earned Amounts by Invoice Type Report Key Reports are common use Broking Reports available to all IBAIS clients Renewal Report with T ext Schedule L Portfolio Analysis nh Monthly Sales by Client Cancellation Report Each of the reports can be selected from the left hand side Click to select the report you want Sales by Invoice Type This report gives a list of transactions invoiced whether paid or not It shows each transaction type in detail or summary Clear If you nominate a From and To date Company Branch All Company Branches leave the Financial Year and Month Sales by Invoice Type Report Financial Year ET blank Please Note Transaction Date July is the date the transaction is entered Transaction Date From on bais Select and Sort Category Summary If no select and sort category entered then report will display all Enter Range or leave blank to include all From Summary To Executive Executive Detail or Summary Report Summary Report z Policy Class Division Underwriter Subagent Executive by Class Report can be in Unde
80. mmercial Motor Vehic le Commercial Motor Vehicle Commercial Motor Vehicle Commercial Motor Vehicle Public Products Liability pulse pulse BUSINESS BUSINESS BUSINESS Industris Special Risks BUSINESS BUSINESS BUSINESS pulse BUSINESS BUSINESS PACK pulse MONEY pulse pulse pulse pulse pulse jenells class MONEY Insurer Name Zurich Australian Insurance Ogu insurance ALLIANZ AUSTRALIA INSURANCE LTD Zurich Australian Insurance Zurich Australian Insurance Zurich Australian Insurance Zurich Australian Insurance Zurich Australian Insurance Zurich Australian Insurance cgu insurance ogu insurance Zurich Australian Insurance ogu insurance NRMA Insurance cgu insurance Overseas Underwriter Zurich Australian Insurance cgu insurance cgu insurance Overseas Underwriter Test Underwriter Chubb Insurance Company Australia Pty Ltd Vero Insurance cgu insurance Overseas Underwriter Overseas Underwriter Overseas Underwriter cgu insurance insurance Actions REP 14763 10401 actions Premium Policy No 1 880 00 To Be Advise 20065454DC COMO00016 To Be Advise 999 457343 0 CMV 000019 CMV 000020 CMV000016 0 To Be Advise AD TESTO10017 M XLS 01 JUN 2008 This is an example of the report The selected schedule documents will also be printed for each policy listed on the report SADSDASDASDSDA To Be Advised amp To Be Advised To Be Advised 0 To Be Advised 060
81. mp gt Harry and Mary Smith t as BCCLAIMS R25 Claims Listing J Entertainment trading as GOOD TIMES 5 100 00 J Entertainment trading as GOOD TIMES 5 000 00 J Entertainment trading as GOOD TIMES 5 000 00 J Entertainment trading as GOOD TIMES 5 000 00 Chapter 7 Reporting o Webpage Dialog 5 O A m oo 31 4 D p Search Search Next Actions REP 15905 57555 actions XLS Listing of Claims Run Date 18 JUL 2011 16 09 Financial Period not selected All transactions selected Comment 5 RR REE ERR RR REE ERR RRR RRR aE EE LP PIG OUT CAFE 500 00 PIG OUT CAFE 500 00 PIG OUT CAFE 0 00 PIG OUT CAFE 0 00 PIG OUT CAFE 2 000 00 PIG OUT CAFE 2 000 00 PIG OUT CAFE 0 00 PIG OUT CAFE 100 000 00 PIG OUT CAFE 100 000 00 PIG OUT CAFE 0 00 PIG OUT CAFE 500 00 PIG OUT CAFE 500 00 PIG OUT CAFE 0 00 PIG OUT CAFE 5 000 00 PIG OUT CAFE 5 000 00 PIG OUT CAFE 0 00 PIG OUT CAFE 2 000 00 PIG OUT CAFE 2 000 00 PIG OUT CAFE 0 00 PIG OUT CAFE 2 750 00 8 Cheque sent to insured Finalised 500 00 UPDATE FROM INSURER UPDATE FROM INSURER SENT CHEQ FOR 52000 TO CLIENT SENT CHEQ FOR 52000 TO CLIENT CLIENT CALLED ADVISED OF CLAIM CLAIM FINALISED CLAIM FINALISED 510000 TOTAL F N Injury Payment Finalised FN 06 04 2004 CLAIM FORM SENT TO CLIENT F U 20APRO04 06 04 2004 CLAIM TO BE FINALISED 06 04 2004 CLAIM FINALISED FOR 5000 CHQ SENT TO CLIENT requested as
82. n nasa of prescribed securities oer speci TOTAL MONIES REEETVIEDI m om amp m MONEYS WTHORAAN DURING YEAR RESPECT OF GENERAL INSURANCE For nayment it mnirmuredor pnsendrig irar ed AMOUNTS GUE TO NEUR ES For payment se T 30 days or less from of e or fom ih begining of For payment 320r behal of in winich es Iris zimmer ree For prescribed For repayment of momies naa inso sccpunt Gresia sm SU days from ne date of ihe o fhe ris or from he begining at period 50 WE he Fezsimert resis ini emor We coment in wring of eai commissmyer Ams dus 2o insureds or intending ects i 0 TOTAL MONIES WITHDEFRJAGNM Amour s hel where dye risk noz teen BALAI EOF ACCOUNT END CF YEAR eure broking Eek 1 Amours Seeing fo ded of e broker IPrez bed secures ofemch secur Ey Suspense Levies 8 SRR TOTAL CARRIED FORWARD EMD OF 45 TOTAL Mus agree bem coke 95 Ibais User Manual 7 38 O BA Insurance Systems Chapter 7 Reporting Trust Trial Balance Report This function allows you to run a Trust Trial Balance Report The report gives a more detailed analysis of the section 27 report Trust Trial Balance Report Lisa All Companies Currency All Currencies Input the Compan
83. nding Renewals Report with Schedules mm Sort Sequence Renewal Report E _ with Text B Insurer Name Select a sort category Schedule L Auto Rated EI Renewals BE Division Description EE You add report number of sort sequences sort can be run in the following E Policy Number versions your report order of e g Renewal Date Executive using the dropdown Detailed Summary Brief No Premium B Subagent Subagent Name Inputting more than one will cause the report to be sorted in order of your first selection first and then your second etc Inputting one or more of the above will select only those options input i e Inputting one or more Insurer codes will select only those policies held by those insurers This allows you to sort by Exec and then have each Exec s policies sorted by Renewal Date for example Leaving any of these options BLANK means all will be included Note A new option to include specific Subagents has now been included Click on Run Report when you have enter the expiry Date From and Date To fields and any other selections you have made for the report Ibais User Manual 7 31 BA Insurance Systems Chapter 7 Reporting Completed Search Next Actions REP 14763 10403 actions XLS Page of 2 Search K 4 DDI BA INSUR
84. ns REP 15905 57191 actions XLS BA TRAINING Cash Receipts Run Date 18 JUL 2011 10 54 Tender Type Date Range Selected Client Clients Bank Code 050 Name of Bank Banking Location BAI 5 Currency AUD AUSTRALIAN DOLLARS Receipt Date Transaction Payment Details Tender Type Company 1 Acc Policy Effective No Captured Date Branch Exec Number Dates 51 10 08 2007 10 08 2007 CASH 0 i Allianz Insurance ANDS 06070001 30 09 2006 52 10 08 2007 10 08 2007 CASH 0 i Allianz Insurance ANDS 06070001 30 09 2006 70 18 10 2007 18 10 2007 CASH 0 ABC Pty Ltd ANDS 07040004 27 04 2007 ANDS 07080003 02 08 2007 ANDS 07080003 02 08 2007 12 11 2007 12 11 2007 Fred Happy T as Happy F ANDS 07110001 12 11 2007 ANDS 07110002 12 11 2007 12 11 2007 12 11 2007 ABC Pty Ltd ANDS 07070002 01 07 2007 ANDS 07080003 02 12 2007 18 03 2008 i Antother installment Client 01 01 2007 08030002 18 03 2008 15 04 2008 Antother installment Client 01 01 2007 01 06 2007 01 01 2007 01 01 2007 01 01 2007 01 01 2007 01 01 2007 01 06 2007 01 01 2007 01 06 2007 01 01 2007 01 06 2007 01 01 2007 01 06 2007 01 01 2007 01 06 2007 01 01 2007 190 16 11 2009 16 11 2009 1 045 00 0 54 001 BA Test Pty Ltd 16 11 2009 192 28 04 2010 28 04 2010 4 063 70 0 00 BA Test Pty Ltd 21 11 2009 Tender Type Total 19 198 91 No Of Transactions Includes details only for Executive Sheri Andrews If you select a specific E
85. nting Trust Bank Movements Section 26 Reports Trust Account Summary Report Trust Trial Company All Companies Balance Report Control Total Currency All Currencies Balancing Report Brokersge Eamed ADP Code All ADP Codes Summary Report Debtor Ageing i Reports Trust Bank All Trust Banks A Creditor Reports Creditor 90 Days Report Return Premiums Financial Month From Reports n Unallocated Cash Financial Month To Financial Year Trust Bank 5 Brokerage Earned Reports Once you have input your selection criteria click on Run Report to produce report You can select to run the report in a detailed version or you can click on the Summary Only box to produce a summary version as shown below Summary Only Preview Mode Printer DEFAULT Run Report A sample of the report in detail option is reproduced below Ibais User Manual 7 48 O BA Insurance Systems Chapter 7 Reporting Ibais Insurance Software Page Conte Completed Page of 5 Id4 bb Search Search Next Actions REP 15907 58563 actions v XLS TRAINING Run Time 20 JUL 2011 09 34 Trust Bank Movements Section 26 Report Sort by Currency by Company by ADP Code by Trust Bank by Transaction Date by Creditor Debtor Currency AUD AUSTRALIAN DOLLARS Company 0 TRAINING DATABASE B A I S ADP code 80 From or on behalf of an insured or intending insured or on account of an insurer Trust Bank Creditor Debtor Trans
86. ogout MTD Income by Company Branch by Executive by Client report Executive All Executives Year Month November Click on Run Report when selection criteria has been input Example of the report BAIS Training Page Control Completed Page B of 11 4 D p Search Search Next Actions REP 15905 57035 actions XLS BA TRAINING Run Time 18 JUL 2011 08 02 MTD Income by Company Branch by Executive by Client for Year 2004 and Month 4 Company Branch 0 BA Insurance Systems Executive TRAIN2 Terry Trainee Client Name Aeropelican Pty Ltd Aardvark Enterprises Vas Antz Pantz Arena Security Beez Kneez Babywear Pty Ltd Jack Smith Jr Total for Executive TRAIN2 BKCLEXSALES R40 MTD Income by Company Branch by Executive by Clk Page 4 of 11 Ibais User Manual 7 66 O BA Insurance Systems Chapter 7 Reporting Debtor History Report This report can be accessed from the Home page then Accounting option then by selecting Category Reports then clicking on Debtor History Report as shown below Home Account Selection Change Password All Options Favourites Report Cabinets Logout Available Forms and Reports TYPE Accounting v Category Sub Category Select Sub Category Favorites Type Category Sub Category Form Report Click to Run Cash Receipts Listing Cash Settlement Bordereau Savannah Cheque Details for UW Client Statements Credit Cards Due To Expire Report Creditor
87. on Exception report This report gives a list of all policy transaction exceptions BAIS Training Policy Transaction Exception ER LLL Policy Transaction Exception Report EEE Executive Y Report includes all Executives by default unless FE Sal you specify one via the dropdown Latest Generation Date Printing Options Summary Only Report prints a detailed listing by default click on Summary Only for a listing with totals by Executive Report includes all Executives by Peta DEFAULT default unless you specify one via the WTTTTN dropdown Preview Mode Ibais User Manual 7 49 O BA Insurance Systems Chapter 7 Reporting You can select all Executives by keeping the Executive field set to Executive or use the dropdown to select a specific Executive and you can select Policy Transaction dates using the Earliest and Latest Generation Date fields dates The report produces a detailed listing unless you click on the Summary Only box Click on Run Report when you have made your selections A sample of the Policy Transaction Exception Listing report run as a Summary is reproduced below BATS Training _ _ 2 Webpage Dialog SS Completed Page 4 of 10 Id4 D Pl Search Search Next Actions REP 15905 57070 actions XLS BA TRAINING Run Time 18 JUL 2011 09 00 Policy Transaction Exception Report Executive TRAIN2 Ter
88. rwriter by Class Detail or Summary Executive by Stat Code Division by Stat Code Once you have input your selection criteria on which you wish the report to be based Click Run Report Ibais User Manual 7 15 O BA Insurance Systems Chapter 7 Reporting A sample of the Sales by Invoice Type Report in summary is reproduced below Web Dialog Completed Page of 1 4 bb Search Search Next Actions REP 14569 14070 actions BATRAINING Run Date 20 NOW 2007 Run Time 13 59 Sales by Invoice Type Summary Report Summary For Financial Year 2004 and Financial Month 1 Company Branch Al All Company Branches N Commission Nett Due to Subagent Invoice Type Gross Amount Brokers Fee Fee GST Commission GST Premium Premium GST Fire Lewy Stamp Duty Policy Fee Insurer Subagent GST New Business 1275753 99 1750 55 274 86 178 618 38 14419 96 986734 13 110661 55 6553 70 119881 68 57941 38 10360 00 1006319 24 11030 58 1103 06 Rebroked Rnls 1982 99 50 00 5 00 240 00 24 00 1200 00 160 90 0 00 403 00 159 19 0 00 1663 99 28 80 2 88 Renewals 130609 16 1680 00 168 00 13 864 88 1348 00 56702 50 10973 01 73 00 23027 53 10836 97 0 00 115507 22 3261 08 326 11 Endorsements 1674409 19 170 00 17 00 96 598 70 9605 39 939422 75 129929 54 107 79 45887263 153336 96 10 00 1583560 21 15835 19 1583 53 Reversed NB 1711880 99 292 66 29 26 100 465 98 10024 47 964691 65 143112 18 44 27 466430 09 156803 32 20 00 1619686 86
89. ry Trainee I Positive premium with negative commission component Underwriter premiums greater than payable by client Positive premium with negative commission component Underwriter premiums greater than payable by client Subagent amount greater than commission 27 01 2009 j i 271 50 i Subagent amount greater than commission 30 05 2008 1 985 54 Underwriter premiums grester than payable by client Subagent amount greater than commission 04 06 2008 i 19 307 75 Subagent amount greater than commission 18 06 2008 23 478 22 Subagent amount greater than commission 09 10 2008 676 72 Cancellation Endorsement amount gt yearly premium 22 07 2009 j 8 1 0 00 Cancellation Endorsement amount gt yearly premium 27 01 2009 j _ 277 50 1 Subagent amount greater than commission 04 04 2009 Subagent amount greater than commission 23 04 2009 Subagent amount greater than commission 23 04 2009 B Subagent amount greater than commission 02 11 2009 i 1 Underwriter premiums greater than payable by client Rebate greater than commission fee Subagent amount greater than commission 10070001 08 03 2011 200 00 i Insurer commission varies from standard commission 11060002 28 06 2011 000 1 250 00 i 550 Insurer commission varies from standard commission Totals for Executive 51 941 70 3 974 17 BKEXCEPTION R10 Policy Transaction Exceptions Report by Executive by Memo Page 4 of 10
90. s all monies in unallocated cash Creditor Reports This report shows broken down into days all items outstanding against a creditor Selection criteria can be used to narrow this down to Fully Part Paid Unpaid and Return Premium items if required Return Premiums Reports This report identifies any transactions where a credit has been taken from the creditor but not yet paid to the client or paid to the client but not yet taken from the creditor Unallocated Cash Listing This report shows all receipts which remain fully or partially unallocated Brokerage Earned Reports Brokerage Earned Report This is detailed report showing all fees commission sub agents commission and GST earned in a selected period or transaction date range Brokerage Taken Report This is a detailed report showing all fees commission sub agents commission and GST taken in a selected period or transaction date range Below is a more comprehensive description of each report and details on how to run the report Ibais User Manual 7 36 BA Insurance Systems Chapter 7 Reporting Trust Account Summary Report This function allows you to run a Trust Account Summary Report The report is required by ASIC for licensing of Brokers in Australia under current legislation The report consists of two parts Section 26 on the left hand side of the report is the running total of the trust bank accounts based on the opening balances and movement
91. s in and out during the year Section 27 on the right hand side of the report gives a snap shot of the trust accounts at a point in time and provides a break down of whom the amounts are held in trust for This report includes only amounts held in trust i e Amounts receipted into the Trust Account Trust Account Summary Report Financial Year Input the selection criteria on which you want the report to be based To include all linked databases and companies you can leave the fields blank Financial Month Ytd Or Monthly Movements Ye ar to Date E Database All Linked Databases Company All Companies All reports generated in bais will display a screen similar to the one shown below where you select to preview the report or send to your printer Click Run Report when selection criteria has been input Ibais User Manual 7 37 BA Insurance Systems Chapter 7 Reporting Printing Options Preview Mode An example of the Trust Account Summary Report is reproduced here EA TRAINS Fun Deis 11 UN 2007 Fun Time 1542 Trost Account Summary Report 7 m nn tom Dastese SA TRANS RNG ACCOUNT OPENING BALANCE MONET RECEIVED YEAR From or es d bered or intending lirezur ed or on of an insurer Fram or Gest of of eer or on sonari of sn insured or inending From ie reset of presis secu bes AS mre of deficiency o
92. sessors report epee eeeee 8 requested assessors report o 8 requested assessors report e 8 advised payment was going to be made advised payment was going to be made New Claim Request Assessor Update reserve outstanding Part payment sent Assessor payment Outstanding reserve adjusted fINALISE OUTSTANDING CLAIM Recovery received to be entered Recovery entered Recovery entered Recovery authorised PIG OUT 0 00 Underwriter notified of claim waiting on claim form from client Page 23 of 31 Active Policy Count by Policy Class Report This report will capture the number of policies active at a particular date by policy class This is required by the Financial Ombudsman Service for their Annual Assessment for Base Levy amp Comparative Tables The new report can be located in the All Options menu and is called Ibais User Manual 7 70 BA Insurance Systems Chapter 7 Reporting Active Policy Count by Policy Class Report Home Account Selection Change Password All Options Available Forms and Reports Type Category Select Category Sub Category Select Sub Category Favorites Type Category Form Report Click to Run t L UWwIIUdU List List Documents On line Quoting Recovery Transactions Insurance Accounting Reports
93. t No Cancel Receipt No Cash Receipts Yes o Creditors Open Item and History Ledgers No Debtors Open Item and History Ledgers No GL Transactions No General Ledger Enquiry No Payments Yes Reports Creditor Trial Balance No Creditors Age Analysis No AR Customer Trial Balance No Bank Deposit Print Reprint No Bordereau Report for Reinsurance No Cash Receipts Listing No Cheque Details for UW No No reditor statements No Customer Executive Age Analysis Summary No Customer Executive Age Analysis No Refine by Description Refine The following screen appears Please Note The system will default some fields unless you require different sort criteria you may leave these as they are If you select Executive or Division the statements will only run for clients in the selected Executive or Division Ibais User Manual 7 54 BA Insurance Systems Chapter 7 Reporting 4 7 QUE Toast A si TP gy TERR pene VEINE 3 MS ELA X Rp e A ft Les ie more Vinal cree metuit LA uera22wurud AU Options L4 Client Statements Statement Date Message To Appear On Statement Run Report Clear You can message that will appear on this run D include a Run Type Individual Company Branch all 2 Sort by Client Name Selected Executive Executive Selected
94. through the Home Page The bbais Security System only enables access to Reports and Report Cabinets that you have permission to access You may access the functions via the Options tab at the top of the screen or via your Favourites Report Cabinets Report Cabinets is a storage area for reports It allows you to store reports into a filing system for later retrieval Located on the top toolbar is Report Cabinets Account Selection k Change Password All Options Favourites Report Cabinets Logout Click to open the following screen Cabinet Report Interface Available Cabinets Available Drawers D _ hg General Reporting 52 End of Day E End of Month Ibais User Manual 7 1 O BA Insurance Systems Chapter 7 Reporting There are three main sections to the Reports Cabinet 1 Available Cabinets 2 Available Drawers 3 Description actual reports These are indicated below Home Account Selection Change Password All Ontions Favourites Report Cabinets Cabinet Report Interface The open cabinet will be highlighted e Available Cabinets Available Drawers hy it General Reporting pi e Armstrong Jim Available Drawers Click to open Eg End of Day End of Month TIED Delete the Drawer REB 15123 28463 27 05 09 09 29 100 Descrintion Select Job Name Time 9 5 Comnletal _ R
95. urance Systems Chapter 7 Reporting Trust Accounting Reports Trust Accounting Reports are designed to provide information on the state of the business from a trust banking perspective All of these reports provide information on funds either in the trust bank or owed to or from the trust bank s for the Broker Clients Insurers Subagents Statutory Authorities etc To ensure that these reports will balance to each other there must be no processing done on the system between running one report and another that it is to balance to To run the Trust Accounting Reports click on All Options to display the available menu items BA TRAINING Welcome Sheri Andrews BA Insurance Systems X Favourites Task Management Insurance Manage all of your business contacts and activities fram within ay 4 Access all of your insurance processing functions and i Task Management The system can generate business related ul Le client and insurer enquiry routines Premium Funding is tasks eg upcoming renewals and you can enter tasks if available here Please note that your list of available items may differ from the one shown here as there are different security settings in place within many databases Available Forms and Reports Category Select Category v Sub Category Select Sub Category Category Category Form Report Click to Run Reports Brokerage Taken
96. urrency COBR Above or Equal To COBR Below or Equal To COA No Above or Equal To COA No Below or Equal To Fin Month Above or Equal To Fin Month Below or Equal To Financial Year Select Report Format iv Local Currency B A Insurance Systems Pty Ltd v B A Insurance Systems Pty Ltd i 11 May v 11 May v 2004 Development Account BA DEV Glchart by Description Glchart by Description Page 25 of 46 Select Page Refine Search COA Description Description Fat Levy _ Fielding amp Partners Run Report Financial Services Debtors Select Report Format Details by COA Details by COA by Policy Class Details by COA Insurance Details Selection of Foreign Currency will only be available if this option is applicable If selected either all currencies or a specific currency may be nominated Fines amp Penalties Flowers Foreign Currency A Transfer Account Foreign Currency Translation Reserve COA is selectable by clicking the link Freight Fringe Benefits Tax Fringe Benefits Tax Recovery Fringe Benefits Tax Provision Furniture amp Fittings Information is presented in alphabetical order of COA Description GAB Creditor s Claims Control You may refine your search GAB Debtors Claims Control GST Collected Go to Page
97. want to include Click on Run Report to run your Exec Debtors Net Subagents listing Ibais User Manual 7 10 O BA Insurance Systems Chapter 7 Reporting When you Run the Report you can print as a Preview or to your printer Example of the report without Exec Debtors Ibais Insurance Software Page Webpage Dial a Completed Page of 1 Id4 bb search Search Next Actions REP 15907 58803 actions XLS TRAINING Run Time 20 JUL 2011 11 57 bois Subagent Code Name Brokers Fee Auto Calculate Commission for Broker Commission Rate Endorsements Group BK BBG Brilian Broking Group i 0 00 Y BK HBG Happy Broking Group I i 0 00 Y Subagent Commission Rate Listing BKEXEC_R170 Subagent Commission Rate Listing Example of report with Exec Debtor Net Subagent selected BAIS Training Page Control Completed Kid b bl Search Next Actions REP 15951 85500 actions 15 BA TRAINING Run Time 02 SEP 2011 08 36 bois Subagent Code Name Subagent Debtor New Business Renewal Commission Brokers Fee Auto Calculate Commission for Broker Commission Rate Rate Commission Rate Endorsements Group Subagent Commission Rate Listing BK ABC ABC Brokers 15 00 15 00 0 00 Y STEAD BK ABCD ABCD Brokers 15 00 15 00 0 00 0 00 0 00 0 00 BROKOO1 Broker 12 50 12 50 0 00 SUB NET Net Paying Sub Agent 15 00 15 00 0 00 20 XYZ INSURANCE
98. xecutive or Division they will display on the Report Footer Ibais User Manual 7 63 O BA Insurance Systems Chapter 7 Reporting Creditor Full Ledger Report This report can be accessed from the Home page then Accounting option then by selecting Category Reports then clicking on Creditor Full Ledger Report as shown below Home Account Selection Change Password All Options Favourites Report Cabinets Logout Available Forms and Reports TYPE Accounting Category v Sub Category Select Sub Category Favorites Type Category Sub Category For m Report Click to Run Accounting Reports Al Creditor Master editor Trial Balance _ APiCreditors Age Analysis stomer Age Analysis tomer Trial Balance ARJDebtor Master Ba k Deposit Print Reprint Ba king Summary Report Bogllereau Report for Reinsurance Receipts Listing o Ca h Settlement Bordereau Savannah Chque Details for UW Cards Due To Expire Report Creditor Statements Customer Executive Age Analysis Summary Customer Executive Analysis Customer Name and Address Listing Customer Transaction Executive Age Analysis Refine by Description Refine Once in the report screen you can select a specific Creditor or leave as default for All and set a Transaction Date or Transaction Date range as per screen below Account Selection hange Passwe All Options Favourites Report Cabinets
99. y and Currency you wish to run the report for or leave blank to include all Companies and Currencies If you do not have multiple companies and currencies you can leave it blank Click Run Report A sample Trust Trial Balance Report is reproduced here BA TRAINING Trust Tria Balance Report Far all companies and all currencies bois DIL AUD ALSTRALIAN DOLLARS Account Name 050 BRCOMM BROOMM GST BRFEE BRFEE GST BRUVWGST CAS HUMALL OC RETPREMLW ST FBC ST FSLNSW 5T SDNSW ST NTCR LN ALLIANZ Uw GLOBAL UW LLOYDS LUW OBEMM Uw ROYAL uw SGIOo LN ZURICH Ibais User Manual Trust Bank Account number Q50 Brokers Commission GST on Brokers Commission Brokers Fes GST on Brokers Fee GST retsined overseas underwriters Unallocated Cash Return Premums Underwriters Only Stat Chg FEC Charges Stat Chg FIRE SERVICE LEVY CREDITOR NSW Set Chg STAMP DUTY CREDITOR NSW Stat Chg WITHHOLDING TAX CREDITOR Subagent ABC Sub Agent V Allianz Insurance CGU Insurance Global Underwriting Services V Lioyds of London Mercantile Mutual Royal Sun Alliance 55 0 Insurance Suncorp Zurich Australian Insurance Total br Company 0 and Currency AUD 7 99 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 107712 14 0 00 203 18 5183 05 1918 23 1010 68 0 00 10388 00 15441 58 3513 83

Chapter 7 - Reporting

Contents

Download Pdf Manuals

Related Search

Related Contents