Home

Chapter 5 - Accounting

1. Please click on the link to view your statement Email Message Preferences __S lect an Email Preference Once the default settings are altered to your preferences you can save this information Delete Email Preference and create templates for your future use Input the Sender Email Address Subject and Message Text then click on the Add to v Submit lo Cancel Email Preferences hyperlink Once the Email Preferences are saved you will be able to select them from the list when running the same type of report in the future e pat Pulse Test Email Report Details EE EES EEEE EEEE Email Report Details From Page To Page TON Email Subject Header Remittance Advice Message Text Hi there Please click on the link below to view your remittance advice report Email Message Preferences a Say mmer CSS e Advics tands Email preferences are linked to UserID so Select an Email Preference e Emad of Statement ands you will only see your own in the Remittance Advice ands selection list w Submit O Cancel VBScript When you submit a confirmation message will advise that the emails have been sent Ibais User Manual 5 42 BA Insurance Systems Chapter 5 Accounting Finalise Payment Run When you have completed all the E steps and run any required reports you must finalise the payment run Click on SEMELLE
2. Options are available to put everything back on Hold Hold Release Details Hold A mm mm Creditor ROYAL ROYAL INSURANCE COMPANY Total Original Amount 6 015 762 12 Total Payment Amount 270 989 01 Total Outstanding Amount 5 977 052 31 Total Discount Amount 0 00 Total Held Amount 5 706 063 30 Total to Pay 270 989 01 Voucher Reference Type Tran Date Due Date Outstanding Hold Part Payment Amt Discount Amt Debtor 0 5 DPS Policy Number 119372 04040004 INVE 18 02 05 20 03 05 1 267 00 ERR o 0 1344 00 U 040331b 119854 05120005 INVE 08 12 05 08 12 05 1 005 22 MR o 0 1492 60 U 171A001621CMP 119855 05120006 INVE 08 12 05 08 12 05 14531 45 0 0 1 644 68 U 23000011XTST 119485 05050016 INVE 16 05 05 15 06 05 1 264 37 EM 0 0 1 557 82 U 53800333 119602 05060040 INVB 27 06 05 27 07 05 1 290 122 52 0 0 1425 924 89 U CMVO01008 119992 03100035 INVE 24 02 06 26 03 06 1 011 04 DS O11 j 0 00 CMVO01020 119672 05070041 INVE p 12 07 05 11 08 05 1 045 00 1155 00 U CMVO01035 120459 05120003 INVE Kaze 25 08 06 990 00 M o 0 1 100 00 U CMVO01037 119850 05120003 INVE 06 12 05 05 01 06 1 045 00 ER 0 o 1155 00 U CMVO01037 120046 06030043 INVE 28 03 06 27 04 06 1050 00 1 11 550 00 U CMVO01038 119818 04100001 INVE 11 11 05 11 12 05 4402 74 4402 74 0 00 CMVO01046 119817 04100001 11 11 05 11 12 05 25 146 10 25 146 10 0 00 CMVO01
3. Allocation 1 of 1 ANTZ SE Total Tendered 0 00 Amount to Allocate 0 00 Document Reference Source Insured Due Date Coco GE res ee 554 LAOH Keceipt ESTEER E PANINI Luu uUu LU LU 2837 CASH Receipt 13 07 2006 100 00 100 00 2838 CASH Receipt 13 07 2006 100 00 100 00 2339 CASH Receipt 13 07 2006 100 00 100 00 2840 CASH Receipt 14 07 2006 100 00 100 00 2341 CASH Receipt 14 07 2006 100 00 100 00 2844 CASH Receipt 17 07 2006 100 00 1 00 2845 CASH Receipt 17 07 2006 100 00 14 00 2846 CASH Receipt 17 07 2006 100 00 1 00 2847 CASH Receipt 17 07 2006 100 00 1 00 2848 CASH Receipt 17 07 2006 100 00 1 00 2849 CASH Receipt 17 07 2006 100 00 1 00 2850 CASH Receipt 17 07 2006 100 00 1 00 2851 CASH Receipt 17 07 2006 100 00 1 00 2861 CASH Receipt Not enough detail to allocate 22 07 2006 1 500 25 1 500 25 Full Payment A Ibais User Manual 5 24 BA Insurance Systems Chapter 5 Accounting Cancelling Receipts Overview This function is provided to enable you to write back any receipt that has been processed through the system whether paid by a client or by a creditor underwriter or sub agent which must be reversed for some reason e g dishonoured or spoilt in some manner Creating the Transaction The transaction is entered from your Favourites menu Ibais Insurance Software Available Forms and Reports Microsoft Internet Explorer provided by BAIS Baia File Edi
4. GST VAT Reporting To produce the GST VAT reports you will need to be in your XXXX GL LIVE account where XXXX is the name of your database Change to this account by clicking on Account Selection on the menu Account Selection Change Password All Options Favourites Report Cabinets Logout BA Insurance Systems bois Welcome Sheri Andrews BA Insurance Systems X Favourites Task Management Insurance Manage all of your business contacts and activities from within Task e Access all of your insurance processing functions and insurance client and Management The system can generate business related tasks eg upcoming gt insurer enquiry routines Premium Funding is also available here renewals and you can enter tasks Select the XXXX GL LIVE account from the available options on the drop down menu and then click Go Home Account Selection Change Password All Options Favourites Report Cabinets Logout Select Account d Account Selection PULSE GL TEST ees GST VAT reports can only be produced for a period after End of Month has been run for that period le If you are running the March quarter GST VAT reports you will need to complete the March End of Month process prior to beginning the steps described here Producing the GST VAT reports is a two stage process Firstly the files need to be updated to capture the correct transactions for the next reporting period and then secondly the reports can be
5. Click Submit on the screen above to generate the GST VAT reports Progress is tracked on the screen below IS PULSE GLTEST Update GST VAT Fes me Update GST VAT Files EE Databases SSES PULSE GL TEST End Financial Period 201003 March Reporting Date 31 03 2010 Updating GST VAT files as specified above Creating records for PULSE TEST database 1 of 2 i i A GST VAT Updating is complete Once the files have been generated a message will be displayed i Reports Gresch dote period Ibais User Manual 5 66 BA Insurance Systems Chapter 5 Accounting Step Two of the GST VAT process is to produce the required reports The reports are located in the All Options menu egory Select Category Sub Category Select Sub Category Category Sub Category Form Report Click to Run Processing Brokerage and GST Transfers eS ________HHH Reports Hint Locate GST VAT Reports more easily by inputting GST in the Refine box at the bottom left of the All Options screen The GST VAT Reports screen allows selection by date and offers several reports to choose from Home Account Selection Change Password All Options Favourites Report Cabinets Logout GST VAT Reports Reporting Date 31 MAR 2010 Company All Companies Report to be Run GST VAT Summary Report R10 ze Nae GST VAT Summary Report R10 GST VAT Detail Report R20 GST VAT Detail Report by Tax Code R30 GST
6. Complete the process by entering the Transaction Date Reference and Narrative The Submit button becomes available when you Tab from the Narrative field 2 Ibais Insurance Software Cancel Receipt Microsoft Internet Explorer provided by BAIS ME File Edit View Favorites Tools Help Q Back EN a Lei A Search Se Favorites La 2 D S L 33 Address a https designbais bais com au baweb 7 i sl SS Google Ce v Go ES YW Bookmarks rr Check 2 Translate Autolink AutoFill Sendtow Settings Home Account Selection Change Password All Options Favourites Logout Cancel Receipt Cancel Receipt for Creditor Receipt EI Creditor ALLIANZ Allianz Insurance Company Branch BA Insurance Systems Currency 050 Receipt Number Receipt Date 10 08 2007 Bank Account Bank Account Name Creditor Receipt Amount 5 569 35 Discount Other 0 00 Total Cancelled 5 569 35 Transaction Date 10 08 2007 Reference CASH Narrative Affect Bank Deposit Slip Voucher Reference Tran Date Paid Amount 175 06070001 30 09 2006 5 569 35 User armj Account B4 TRAINING Form 4RTRANS_B10 Trusted sites The transaction reverses the receipt entry and re establishes all of the Open Items Ibais User Manual 5 30 BA Insurance Systems Chapter 5 Accounting Payments Creditor Payments This function enables the payment of Creditors Und
7. Ibais Insurance Software Cancel Payment Microsoft Internet Explorer provided by BAIS L lef File Edit View Favorites Tools Help Sp Q sack z x x a Le ES Search 5 Favorites Se z 33 Address El https designbais bas Com au baweb sl Go Google G v Goo EP YW Bockmarksr P Check Fi Translate A Le Send tow Q Settings Cancel Payment Submit Debtor PIGOUT Harry Smith t as Pig Out Cafe Company Branch 0 BA Insurance Systems Currency AUD AUSTRALIAN DOLLARS Cheque Payment No 298705 Payment Date 05 05 2006 Bank Account 050 Bank Account Name Debtor Payment Amount 159 09 Total Cancelled 159 09 Transaction Date 10 08 2007 Reference Test Narrative Cheque Lost Voucher Reference Tran Date Paid Amount 161 03050001 05 05 2006 159 09 User armj Account D TRAINING Form SCPAYCONT_B10 8 Trusted sites The transaction reverses the payment entry and re establishes all of the Open Items Brokerage and GST Transfers This function allows you to update the system to reflect transfers of available earnings i e Brokerage Fees and GST from your Trust Account to your General Account Click on Brokerage and GST Transfers and the following screen will appear bais User Manual 5 62 BA Insurance Systems Chapter 5 Accounting Brokerage and GST Transfers You may insert the Company OR Company Branch Code This will
8. Please Note You cannot cancel the payment run once the step has been completed Creditor Payments Enquiry BA Insurance Systems AUSTRALIAN DOLLARS Bank Account Name Action Step Status Date Time Payments Initiated 07 08 2008 10 25 26 Automatic Hold Release Completed 07 08 2008 10 31 52 Manual Hold Release Completed 10 40 35 List of Payments to Make Completed 07 08 2008 10 45 39 Cancel Payment Run Not Applicable Post Payments as Listed Completed 07 08 2008 10 46 26 Print Cheques Still to be Run Allocate Cheque Numbers Still to be Run inalise Payment Run till to be Run New options become available when the payment run is posted Ibais User Manual 5 37 BA Insurance Systems Chapter 5 Accounting Print Cheques This feature will create a print job for those using pre printed laser cheques If you hand write your cheques there is no need to run this step If you do not currently use laser cheques but would like to please contact Support for more information about our cheque stationery layout before proceeding Allocate Cheque Numbers Click on the highlighted field Sees This option allows you allocate the cheque numbers to the payments made Payment Number Allocation Bank Account 050 Bank Account Name No Cheques Total Number of Cheques VES starting From Ending at Number in Range Input the range of Ea E 2607 2807 1 Cheque Numbers KA x When all cheque numbers are alloc
9. Cash Receipts Bank Account 098 UAT Trust Currency AUD Banking Location Select Type of Cash Receipt Direct Payment To UW Underwriter ACEV ACE Insurance Limited Debtor SUNHO1 Hilary Sun Company Branch 990 OAMPS UAT Currency UD AUSTRALIAN DOLLARS Direct Paid Total Tender Type Date Amount Narration Hilary Sun Allocation 1 of i SUNHO1 Previous Next Auto Allocate Total Tendered Amount to Allocate 08040017 Broking Hilary Sun 09 12 2007 i 715 00 715 00 Allocated 08040017 Broking Hilary Sun TRA 08 12 2007 F 110 00 110 00 Allocated bais User Manual 5 20 BA Insurance Systems Chapter 5 Accounting bais has cleared the client amount owed and left a balance equivalent to the amount to be recovered from the insurer 110 00 Client Processing SUNHO1 A Hilary Sun 369 High Street KEW VIC 3101 Client Code Select Action Transaction Entry M Address Contact Person Telephone Retail Wholesale RETAIL Association Email NA Business Phone Mobile Phone Fax No Post Code i Executive 0 00 0 00 Ms Hilary Sun TY Net Profit LY Net Profit TY Gross LY Gross 1 815 00 0 00 0 00 Current 60 Days Unallocated 30 Days Balance 90 Days Active and Expired Policies A Click gt gt cell to view policy history Click any highlighted cell to view details Creditor 110 00 220 00 Client Orig Client O S Creditor Amt Amt Ori
10. Fe Company D B A I S Currency AUD 7 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 Subagent Subagent Nett Profit Nett GST Premium Gst Comm GST Incl Comm GST Funding incl SAg OH fgmnt 05100001 fardvark Ente 100 00 10 00 0 00 0 00 100 00 06100021 Geppetto and d i 2400 00 240 00 288 00 28 80 3112 00 05100022 Geppetto and 5 600 00 60 00 72 00 7 20 628 00 05100029 Geppetto and d d 1400 00 140 00 168 00 16 80 2232 00 05100030 Geppetto and d g 300 00 30 00 36 00 3 60 364 00 05100021 Geppetto and 4 i i il 2500 00 250 00 300 00 30 00 3200 00 05100027 Harry Houdini d d d 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 tf 3 f d 120 00 0 00 170 00 05100025 Harry Smith t 4 d 3 d 1000 00 d 0 00 d 1500 00 05100020 fardvark Ente d d d 87 50 0 00 87 50 03050001 Harry Smith t d H d d 137 60 0 00 d 187 60 03050001 Harry Smith t d 3 i d 140 00 0 00 d 190 00 05100006 Horsin Around d 4 i 240 00 0 00 390 00 Hungry Dog P i d i k 0 00 0 00 d 0 02 05100005 Hungry Dog P 1 R d d 70 00 d 0 00 1 70 00 05100011 ht amp Mrs M Gr 3 d 3 330 00 0 00 A 480 00 05100012 ht amp hrs M Gr d d d d 350 00 d 0 00 d 500 00 Lt amp hrs M Gr i i 0 00 0 00 0 03 05100011 ht amp
11. 1 500 00 Amount 1 500 00 1 500 00 1 500 00 1 500 00 CHEQUE 08 08 2007 1 500 00 Tender Type Date Amount Bank Currency AUD AUD AUD AUD Description National Bank Sydney A M Office 8547854 Sundry Tendered Local Branch Name Drawer Cheque Number User armj Account BA DEV Form ARTRANS_A10 To complete the transaction enter the Receipt details 2 DesignBais Tools Sundry Cash Receipt Submission Details Sundry Cash Receipt Details Ibais User Manual Description Payee Name Address Document Header Rate Local 1 0000 1 0000 1 0000 Trusted sites Office Rental 4 M Office 123 Harbour Street Sydney Print Preview Email O B Insurance Systems e Re Allocate BA Insurance Systems Chapter 5 Accounting Open Item Allocation Open Item allocations can be completed by entering a Cash Receipt for a Zero amount The client allocation form is presented and the items can be allocated Cash Receipts Bank Account JSC Blank Account Currency AUD Banking Location Type of Cash Receipt Client SS Client Code Client Name Amount to EE athe Allocate Telephone ANTZ Antz Pantz Clothing Co 0 00 Business Terms Executive Outstanding Amt Tender Type CASH ki Amount Actually Banked 0 00 weg in Bank Currency 5 Date 22 07 2006 Amount 0 00 Description Currency Armount Rate Local
12. Code or Name Summary by Sort Category Subagent None sort by Debtor 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 5 77 BA Insurance Systems Chapter 5 Accounting A Sample Debtors Ageing Report is reproduced below Completed Page of 1 HA DDI Search Search Next Actions REP 12294 actions BA TRAINING Run Date 08 NO 2007 Run Time 17 24 Debtors Detailed Ageing with Broking amp mounts Sort by Company by Currency by Debtor Name For Debtor WOOD Ageing Date 08 NOV 2007 Ke Company 0 BA Insurance Systems B A I S Currency AUD AUSTRALIAN DOLLARS Invoice Invoice hemo Policy Number Effective PF 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 1371005 153 05100029 23232377 HOP 13 10 05 ROYAL 12790 25 d d 0 00 12790 25 1500 00 150 00 1000 00 100 00 13 1005 154 05100022 7s900099COM 15 10 05 CGU 5721 32 d 0 00 5721 32 d d 100 00 10 00 13 1005 155 05100030 To Be Advised 15 1005 ROYAL 1993 60 1 1993 60 Totals for Debtor
13. Part 1 Extraction of EWAY Settlements Details of EWAY Settlements i e credit card payments processed through EWAY which have been successfully deposited into the Bank Account are obtained via the EWAY Business Centre s secure web site The following steps briefly outline what is needed to extract this information in a CSV file Comma Separated Variable format which can be interpreted by the bais system and applied against outstanding bank deposit details This web site can only be accessed with a valid username and password These details are only selectable for a single day so it is recommended that this process is done on a daily basis Ibais User Manual 5 91 BA Insurance Systems Chapter 5 Accounting Choose Settlement Details under the tab Reporting Nominate or select using the calendar function the Settlement Date you want to consolidate leave Card Type set to All Card Types and click the Search Button The lower section of the screen will display all the transactions which were settled on that day Business Centre eWAY Microsoft Internet Explorer provided by BAIS Pty Ltd G i E Wip Ray CON T Eie Et View Farontes Took Help qa Favortes SS i peveloment Account 84 0 MS Business Centre eway amp Ep E 1 e gt Pa Safety Tods f e Business Centre Home Reporting Payments MyAccount Transaction Report settlement Details Settlement Totals Schedule Reports
14. bais INSURANCE AIS be Chapter 5 Accounting Ibais User Manual BA Insurance Systems Ibais User Manual BA Insurance Systems Chapter 5 Table of Contents CHAPTER 5 ACCO UNTINCS canne essence A 5 1 OVERVIEW et ou detai ass 5 1 HOW TO ACCESS ACCOUNTING FUNCTIONS nier annees eee ie 5 2 Srl CE PT ING eegenen 5 3 Local OUN le EE 5 6 Allocating RI aer EE 5 7 SUERG Veedel PR EEE 5 7 Parial PMO CAO PR dukeunasinetmsinsusiaseadiusedsa sieuanneaitn 5 8 Leaving an Amount Unallocated siennes 5 8 PLUTO FOG NOM PP E EE A E TA 5 9 Cr dit Card Charges nanas di REEE NAREN EEEREN den eee sine 5 10 PANUNG RO CONS ae den ae ce T ee en an ea tien ol 5 11 POCERO EE 5 12 BF Oy CCCI IOUS EE 5 13 Forcom UICC EE 5 15 DANE DEPO SIT IPS ne a a area ae tn can 5 16 WI MEN EE 5 17 BAIS DIRECT PAYMENT JOURNALS ccsssesececeeeeeeeeeeeeeeeeeeeseaeeeeseceeeeeesseeasasceeeeesssaeaseeeeeeeesssaaaeeeeeeees 5 19 REENEN aa entente 5 22 OPEN IT MALLOCATIONS RS die eege ones 5 24 CANCELLING RECEIPTS EE 5 25 EE 5 25 Creating the Transaction sise 5 25 Client Receipt Cancellations cccccccccccesssseececceeeceeeeeeeeceeeeeseeeeeeeeeeeesseseaeeeceeeeessaaeaseeeeeeeeeeaas 5 27 Creditor Receipt Cancellatons sise 5 29 PRAMENI EE 5 31 Ee ege EE 5 31 FACES SSIAG I AY ICING EE 5 31 Automatic Hold Release iii 5 33 Manual Tele E 5 34 List of MEET 5 36 Post Payments as Listed E 5 37 Bi A RU 5 38 Allocate Cheque Number 5 3
15. 120011 06030010 Broking Ascott Sales TPP 15 04 2006 14 718 00 14 718 00 Ibais User Manual 5 15 BA Insurance Systems Chapter 5 Accounting Allocate the transaction as normal Cash Receipts Bank Account 051 The Four Pillars Currency USD Banking Location Type of Cash Receipt Client DE Client Code Slant Name Amount to Contact Person Danny Boyd Allocate Telephone 02 9999 0000 ANTZ Antz Pantz thir 500 00 Business 02 3299 0032 Terms 90 Executive BLAH Outstanding Amt 26232 00 Tender Type CASHGBP British Pounds Cash Amount Actually Banked 390 00 Date GBP Pounds Sterling in Bank Currency Amount 500 00 Description Currency Amount Rate Local Bank USD 890 00 0 6557 Client AUD 1 190 48 1 0000 Tendered GBP 500 00 0 4200 Local AUD 1 190 48 Antz Pantz Clothing Co NORTH SYDNEY Allocation 1 of 1 ANTZ Auto Allocat unes ane Gad Amount to Allocate 0 00 Document Reference Source Insured Class Due Date Original Outstanding Allocated Partial Amount Amount Amount Payment 120010 06030009 Broking Ascott Sales TPP 15 04 2006 14 718 00 11 514 00 120011 06030010 Broking Ascott Sales TPP 15 04 2006 14 718 00 14 718 00 1 190 48 Partial Full Payment Please refer to Chapter 10 Administration for further information regarding setting up and maintaining Foreign Currency Exchange Rates Bank Deposit Slips The system allows for the printing of Bank Deposit Slips This is run from Accounting
16. Ibais Insurance Software BPAY DEFT Posting Progress Automatic Receipt Posting Progress Posting BPAY Receipts A message box advises when the upload has completed The Posting Receipt 7 of 20 in MNERER LIVE screen will disappear when completed N DesignBais Editor DesignBais Help Change Password Account Selection Run a Form Logout Favorites Receipt BPAY File WEEN WEEN cn Issuing Bank NAB Download File 10102001 BRF Select Report BPAY Import Error Listing BPAY Posted Listing BPAY Allocation Exception List BPAY Import File Summaries 20 records processed 0 errors Input file archived to F BANKTRFIN USMRE LIVE ARCHIVE NAB 10102001 BRF Biller Code 200 800 KREE INSURANCE File Serial No XXXXKXH2 O01 BPAY PAYMENTS Created Date 12 04 2010 20 26 Captured Date 13 04 2010 15 02 Credited To 069066 EXKXXKE 5 At this point you can run any of the reports that you require by selecting from the Number Amount Report menu Payments 20 27262 79 Error Corrections 0 0 00 Reversals 0 0 00 Totals 20 27262 79 The screen details now reflect the receipts processed and the download is complete Ibais User Manual 5 14 BA Insurance Systems Chapter 5 Accounting Foreign Currency bais allows you to process foreign currency transactions simply The critical aspects are The Bank Account can be local or foreign The Client can be in local currency or foreign The Tender Type can be any va
17. Kaes Refund Payments Manual Creditor Payment Payments Enquiry Sundry Creditor Payments AP Creditor Master AP Creditor Trial Balance Refine by Description and the following will appear Debtor Refunds ave S Enquiry For Company Branch o BA Insurance Systems Payment Run Number And Currency AUD AUSTRALIAN DOLLARS From Bank Account loso Bank Account Name Payment Run Date Ensure Company Branch Currency and Bank Account from which the refund is to be made is displayed correctly Ibais User Manual 5 44 BA Insurance Systems Chapter 5 Accounting When the Payment Run Date is entered the following details are displayed Debtor Refunds Enquiry BA Insurance Systems AUSTRALIAN DOLLARS Bank Account Name Action Step Status Date Time Payments Initiated 07 08 2008 08 43 08 Still to be Run Still te be Run ancel Pay Still to be Run Post Payments as Listed Still to be Run Each step IS Date and Time stamped and re See you can see the progress of the run at a Allocate Cheque Numbers Still to be Run glance at any time Finalise Payment Run Still to be Run SE Select Report Ee From this screen you can proceed with each step to complete the Debtor Refunds as required or Save Status by clicking on the button at the top of the screen to return and complete the Debtor Refunds at a later time To complete any of the steps showing as Still to be Run you click on the
18. Listing B Brokerage Earned Reports 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 or banks 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 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 5 70 BA Insurance Systems Chapter 5 Accounting 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
19. WOOD Suspense 0 00 Totals for Company and Currency 0 4UD Suspense 0 00 Subagent Totals where the subagent is the debtor only Subagent Commission 0 00 Subagent GST 0 00 Grand Totals 91 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 el Creditor All Creditors Detail Report P 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 P Will print in summary Return Premiums BB 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 5 78 BA Insurance Systems Chapter 5 Accounting Input 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 com
20. dialogue box will ask you to confirm that you want to Proceed 2 Are vou sure vou wish to Finalise this Payment Run Click Yes and this closes the payment run es Mo Please Note You can enquire on previous transactions by accessing Payments Enquiry on the All Options Screen under the accounting list or on the button on the Creditor Payments Screen If a Creditor Payment is in progress this button will be greyed out Ibais User Manual 5 43 BA Insurance Systems Chapter 5 Accounting Debtor Refund Payments This function enables the payment of Debtors Accessing Payments Click on Accounting on the Home page or All Options on the top menu as shown below to display all available options Select Debtor Refund Payments from the Accounting list Home Account Selection Change Password All Options Favourites Report Cabinets Logout Available Forms and Reports Select Type Category Select Category a Sub Category Select Sub Category Favorites Ape Category i Sub Category Form Report Click to Run Image Favorites Maintenance Foreign Currency Exchange Rates a Insurer Creditor Maintenance No Inter Currency Exchange Rates Processing Bank Statement Reconciliation Brokerage and GST Transfers Cancel Receipt Cash Receipts Creditors Open Item and History Ledgers Debtors Open Item and History Ledgers GL Transactions General Ledger Enquiry Receipt Enquiry Cancel Payment Creditor Payments
21. 04 08 09 11 07 12 12 07 45 72 07 111207 1212107 Effective Date 30 11 07 20 11 07 30 11 07 01 12 07 01 12 07 01 12 07 01 12 07 01 12 07 01 12 07 01 12 07 01 12 07 02 12 07 03 12 07 03 12 07 03 12 07 05 12 07 06 12 07 06 12 07 08 12 07 08 12 07 08 12 07 08 12 07 08 12 07 09 12 07 12 12 07 12 12 07 12 12 07 12 12 07 Our Reference 07120911 07110078 07120006 07110909 98020026 08020037 07110021 07110011 07110015 07120017 07110043 07110019 97120005 07120014 07990042 07120023 98010065 97120029 07190081 08049016 08040016 08040017 08040017 07110019 07120112 07120112 07120052 07190051 Ibais User Manual Type Name of Insured Particulars STATEMENT OF ACCOUNT Underwriter Creditor Motor Vehicle Motor Vehicle Motor Vehicle Householders Househokiers Househokers Commercial Package Househokiers Kidnap amp Ransom Motor Vehicle Strikes Expenses Commercial Package Motor Vehicle Motor Vehicle Commercial Motor Vehicle Motor Vehicle General Property Motor Vehicle Travel Travel Travel Travel Travel Public Products Liability General Property General Property General Property Public Products Liability 5 21 To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Ad
22. 6 750 54 6 750 54 Allocated 121555 07050012 Broking Antz Pantz Clothing Co 02 08 2007 649 57 649 57 121556 07050011 Broking Antz Pantz Clothing Co INSACC 02 08 2007 3 208 92 3 208 92 121559 07050031 Broking Antz Pantz Clothing Co PULSE 04 08 2007 649 57 649 57 121578 07050048 Broking Antz Pantz Clothing Co PULSE 07 08 2007 649 57 649 57 User armj Account B4 DE Form 4RTRANS_ 410 Trusted sites Ibais User Manual 5 18 BA Insurance Systems Chapter 5 Accounting bais Direct Payment Journals If your client pays the Insurer direct to avoid paying your Brokers Fee this is how you will process the entry into the system The brokers fee is to be adjusted to zero The form below shows the original state of the policy In this example there is a 100 00 brokers fee on the policy Client Processing Client Code Address SUNHO1 A Hilary Sun 369 High Street KEW VIC 3101 Post Code TY Gross LY Gross Active and Expired Policies Memo No 08040017 Pol Policies 3 Transaction Summary 07 04 08 Travel 0990 ACEV HILARYS Tran Date Class Co Branch Insurer Executive Alternate Exec Subagent Currency AUD Business Insured Name Hilary Sun 1 925 00 lt Type EndNo Reason TY Net Profit LY Net Profit Contact Person Telephone Business Phone Mobile Phone Fax No Unallocated 30 Days 0 00 Ak Click gt cell to view policy history 07000 New Business Existing
23. Account Selection Change Password All Options Favourites Report Cabinets Logout Bank Statement Reconciliation Close Statement Suspend Account 050 BANK OF MELBOURNE v BA INSURANCE SYSTEMS Currency AUD Last Reconciled Statement 7 Current Statement GL Period Last Reconciliation Date 22 05 07 1 03 2016 201008 Last Statement Balance 35 280 470 11 Calculated Statement Balance 35 280 470 11 Reconciliation Discrepancy 1 176 735 19 Clear Selection Include All Date Reference Description Deposit Withdrawal Include 17 10 2007 1 cgu insurance 72 27 x 17 10 2007 777 222 Zurich Australian Insurance 292 00 x nin nn an h A aan Lt Ibais User Manual 5 87 BA Insurance Systems Chapter 5 Accounting Choose the transactions which make up the current statement you are processing by clicking on the symbol 01 04 2008 32 Allianz Australia Limited 280 50 This will select the transaction as outlined below 01 04 2008 32 Allianz Australia Limited Once all the relevant transactions have been selected and the Reconciliation Discrepancy is 0 00 Close Statement button then you can close the statement by selecting the Home Account Selection Change Password All Options Favourites Report Cabinets Logout Bank Statement Reconciliation Close Statement wl Account 050 BANK OF MELBOURNE v BA INSURANCE SYSTEMS Currency AUD Last Reconciled Statement 7 Current Statement SCH GL Per
24. C To Be Advised Memo No 08040017 COM ACE Insurance Limited Division Ms Hilary Sun Coinsurance N Policy Number To Be Advised Policy Number U W ACEV Premium FSL Underwriter GST Stamp Duty Policy Fee Other Charges Premium Charges Brokers Fee Rebate Amount Brokers Fee GST Client Payable 0 00 St Start End A 08 12 07 08 01 08 Actions Select Action Transaction Entry Current 60 Days Invoice Retail Wholesale RETAIL Association Email NA Executive Ms Hilary Sun 0 00 0 00 715 00 715 00 Balance 90 Days Click any highlighted cell to view details Client Orig Client O S Amt Amt 715 00 715 00 Creditor Orig Amt 495 00 Creditor 0 S Amt 495 00 Actions Select Enquiry Transaction Entry sc 550 00 0 00 0 00 55 00 0 00 0 00 605 00 100 00 0 00 10 00 715 00 Premium Charges Commission 20 0000 Commission GST Witholding Tax FBC Due to Insurers Broker Gross Profit Subagent Comm Broker Net Profit Subagent GST Client GST The client pays the underwriter directly 605 00 thus excluding the brokers fee An endorsement is processed to reverse the brokers fee Ibais User Manual 5 19 BA Insurance Systems Chapter 5 Accounting Client Processing Clear Client Code a Hilary Sun ctioms Select Action k Transaction Entry M Address 369 High Street Contact Person BEEN
25. Calculation Worksheet R40 GL GST VAT Detail Report by GL Account R50 Outstanding GST VAT Detail Report R70 GL Database GST VAT Detail Report R80 Ibais User Manual 5 67 BA Insurance Systems Chapter 5 Accounting Reports GST VAT Summary Report R10 A very brief report that displays the total GST VAT amounts for the various business functions such as Insurance Premium Insurance Commission General Ledger etc GST VAT Detail Report R20 This report provides detailed reporting on every transaction included in the summary report GST VAT Detail Report by Tax Code R30 This is a detailed report similar to the R20 but also including the Tax Codes Important Note Depending on your country and report options selected some items may be repeated in the report if they have several Tax Codes GST VAT Calculation Worksheet R40 This is a system generated representation of the worksheet used to calculate the amounts to be entered on the government GST VAT Return Form GL GST VAT Detail Report by GL Account This report displays only the items entered via the General Ledger database and sorts them by GL account Outstanding GST VAT Detail Report R70 This report displays all items not paid to the tax authority from previous periods This will usually be because your GST VAT method is cash and the debtor has not yet paid you If your GST VAT method is set to accrual and your parameters are set to exclude unpaid r
26. Completed 07 08 2008 11 38 33 Print Cheques Still to be Run Allocate Cheque Numbers Still to be Run Finalise Payment Run Still to be Run New options become available when the payment run is posted Print Cheques This feature will create a print job for those using pre printed laser cheques If you hand write your cheques there is no need to run this step If you do not currently use laser cheques but would like to please contact Support for more information about our cheque stationery layout before proceeding Ibais User Manual 5 54 BA Insurance Systems Chapter 5 Accounting Allocate Cheque Numbers Click on the highlighted field Glocete Cheaue Kumber This option allows you allocate the cheque numbers to the payments made Payment Number Allocation Bank Account O50 Bank Account Name No Cheques Total Number of Cheques GC starting From Ending at Number in Range Input the range of Cheque Numbers x 007 007 Lif ha When all cheque numbers are allocated click to continue Reports You can run several reports during the payment run process These are accessed via the Reports drop down menu as shown below Ibais User Manual 5 55 BA Insurance Systems Chapter 5 Accounting Manual Creditor Payment Enquiry BA Insurance Systems AUSTRALIAN DOLLARS Bank Account Name Status Date Time Payments Initiated 07 08 2008 11 22 25 Manual Hold Release Completed 07 08 2008 1
27. DOLLARS From Bank Account 050 Bank Account Mame This option allows you to Include Debit Payments if allowed in your database Bordereau Sort Sequence Include Debit Payments Ci Due Date Payment Run Date Client flere Policy Number Select from the drop down menu to sort Client Code by any of the available options Ibais User Manual 5 50 BA Insurance Systems Chapter 5 Accounting When the Payment Run Date is entered the following details are displayed Manual Creditor Payment Enquiry BA Insurance Systems AUSTRALIAN DOLLARS Bank Account Name Payments Initiated Still to be Run Still to be Run Still to be Run Post Payments as Listed Still to be Run Each step is Date and Time stamped and EE pentes you can see the progress of the run at a Allocate Cheque Numbers Still to be Run Finalise Payment Run Still to be Run glance at any time Status From this screen you can proceed with each step to complete the Payments as required or Save Status by clicking on the button at the top of the screen to return and complete the Payments at a later time To complete any of the steps showing as Still to be Run you click on the highlighted field for example Manual Hold Release As each step is completed the Status column will reflect this Manual Hold Release Click on the highlighted field TEPER This option allows you to select the payments to be made and to include or exclude in
28. Default to print or preview the report Summary Only Preview Mode Printer DEFAULT Once you have run the report Close the screens to return to above Outstanding Insurer Creditor Policy Payments Screen To continue on and save the information you must press Submit This will then return to the Creditor Payment Run Screen as shown below Creditor Payments Save Status For Compan Branch E BA Insurance Systems Fayment Run Number jas And Currency AUD AUSTRALIAN DOLLARS From Bank Account oso Bank Account Name Bordereau Sort Sequence Due Date a Include Debit Payments E Payment Run Date 22 07 2008 Status Run may do again Still to be Run Still to be Run Still to be Run e ie Status is updated to reflect the steps Print Cheques Still to be Fun SE g that have been run and shows which Allocate Cheque Numbers Still to be Run Finalise Payment Run Still to be Fun can be run again if necessary Manual Hold Release Click on the highlighted field ETS This option allows you to modify the list of payments to be made and also to include or exclude individual invoices in the payments First a list of all the payment recipients is displayed You can remove any from the list by clicking on the Remove column next to the one to be removed This will change from aN toa Y If you remove Creditor they will be excluded from the payment run completely You can add additional Creditors by clicking on Include another Cre
29. Insured 120104 06050025 Broking Antz Pantz Clothi Receipt Details 120105 06050026 Broking Antz Pantz Clothi 2833 CASH Receipt 2834 CASH Receipt Payee Name P SE 2837 CASH Receipt LOS RENE DANCE 2838 CASH Receipt Address po Box 1234 2839 CASH Receipt North Sydney NSW 2059 2840 CASH Receipt 2841 CASH Receipt 2844 CASH Receipt Print Preview Email Description 2845 CASH Receipt 2846 CASH Receipt 2847 CASH Receipt E EEEE 2848 CASH Receipt n a Rent m Document Header Ibais User Manual 5 11 BA Insurance Systems Chapter 5 Accounting Receipt Reprint This function will allow you to reprint a receipt and can be accessed as below or placed in your Favourites Home Account Selection Change Password All Options Favourites Available Forms and Reports N pe Select Type Category Select Category Sub Category Select Sub Category Favorites eee Category Sub Category Form Report Click to Run Receipt Enquiry Reports AP Creditor Master AP Creditor Trial Balance AP Creditors Age Analysis AR Customer Age Analysis AR Customer Trial Balance Bank Deposit Print Reprint Bordereau Report for Reinsurance Cash Receipts Listing Cheque Details for UW Client Statements Creditor Statements Customer Executive Age Analysis Summary Customer Executive Age Analysis GL Trial Balance Reports Insurers to be Paid elected Cheque Bordereau Administration Accounting Accoun
30. NM Choose to Save this file and when presented with the Save As screen change the filename to conform to the following eway_ccccc_ddmmyy txt where ccccc is the company name expressed as a single word with no spaces e g petplan and ddmmyy is the selected settlement date e g 310810 the file suffix must be txt the upload process will not accept csv Your filename should resemble eway_petplan_310810 txt The format of this file name is important as the EWAY extract does not include the settlement date We must rely on the date in the file name to tell us the day on which these transactions were settled Save this to your PC either on the desktop or in a folder which can easily be accessed in Part 2 following Save in EI Desktop B My Documen ts 2 My Computer S i Network Places File name eway_petplan_310810 txt v Save as type Microsoft Office Excel Comma Separated Value w Close after saving and logout of the EWAY Business Centre The settlement details for the nominated date are now in a txt file in CSV format ready for uploading and processing Ibais User Manual 5 93 BA Insurance Systems Part 2 Uploa The EWAY Conso Chapter 5 Accounting ding Checking and Consolidating for Reconciliation lidation amp Reconciliation process can be found under Accounting Processing in the Favourites menu There are 3 phases in the process of applying settled payments against the unre
31. Name Mo Cheques Total Number of Cheques Input the range of Cheque Numbers i When all cheque numbers are allocated click to continue Reports You can run several reports during the payment run process These are accessed via the Reports drop down menu as shown below Ibais User Manual 5 48 BA Insurance Systems Chapter 5 Accounting Debtor Refunds Save Status BA Insurance Systems AUSTRALIAN DOLLARS Bank Account Name Action Step Status Date Time Payments Initiated 07 08 2008 12 49 56 Refund Preparation Completed 07 08 2008 12 58 59 List of Payments to Make Completed 07 08 2008 12 59 11 Cancel Payment Run Not Applicable Post Payments as Listed Completed 07 08 2008 12 59 15 Print Cheques Ignored Run may do again 07 08 2008 12 59 28 Still to be Run ect Repo List Posting Errors List Unprocessed Payments List Payments by Number List Payments by Type Bordereau Selected Cheque Finalise Payment Run When you have completed all the required steps and run any required reports you must finalise the payment run Click on a dialogue box will ask you to confirm that you want to Proceed VBScript he 2 Are you sure you Wish to Finalise this Payment Run Mo Click Yes and this closes the payment run Please Note You can enquire on previous transactions by accessing Payments Enquiry on the All Options Screen under the accounting list or on the button on the Debtor Refun
32. Payments Screen click t return to the Hold Release Details Screen O If you have completed all transactions in the Hold Release Details Screen press and you are returned to the Hold Release Summary screen if this screen is correct press again to be returned to the Step List The screen is now updated with the date and time stamp of the steps you have completed List of Payments to Make This step produces a report showing the Payments being made in this Payment run Click on R which will produce the list You may use the preview mode or print a copy Printing Options Preview Mode Printer Run Report Ticking the Preview Mode tick box allows you to view the report on screen Leave the printer set to Default to print or preview the report Ibais User Manual 5 36 BA Insurance Systems Chapter 5 Accounting Once you have run the report Close the screen to return to Creditor Payments Steps If you are satisfied with the items reported you can skip the step and proceed directly to DESEN Please Note If the Payment Run is incorrect you may go back and correct the Payment or cancel the Payment Run By cancelling the Payment Run all preparation work will be deleted Post Payments as Listed This step posts the payments to accounts A dialogue box will confirm that you want to Proceed Click Yes VBScript DesignBAIS j Are you sure you wish to Proceed with Posting of these Creditor Payments
33. Settlement Date 21 08 2010 Enterprise Report Custom Reports Dashboard 177 Report Help Export Print Report Purchases Refunds Total AUD 7 982 89 AUD 7 982 89 126 Avg AUD 63 36 none 126 a VI eg a d nnt Simply drag a column title here to gn e reguits Records per paga H 4 Page 1 sl of13 b M Displaying items 1 to 10 of 126 r r e RN r 31 08 2010 17 19 37 26025369 AUD 533 00 Purchase Fred K Clarninger Cons 31 08 2010 17 10 30 26025063 AUD 237 45 Purchase Mary Contrary Actions 31 08 2010 14 47 05 26020228 AUD 147 64 Purchase Lilly Gabilly Actions 3108 2010 10 39 44 26010720 AUD 36 90 Purchase lan Mi Meldrum Quick Links degt o ACTIONS 3006 2010 10 33 40 26010715 AUD 36 69 Purchase Sylvester Fortescue CARTER Customer 16604424 Web Actve Corporation Ply Lid ACN 096 A09 404 4010 ABN d2 086 208 403 M19 Frvacy be Help Overview asie Internet fa 125 7 Be aware that the settlement date can be after the actual transaction date when the time of that transaction is after the bank s cutoff time for processing payments You may need to make allowance for this at end of month Ibais User Manual 5 92 BA Insurance Systems Chapter 5 Accounting Click on the Drop down Export Print Report box and choose Detailed Reports CSV All Card Types Le Reset Email Report Search 2 Export Print Report Total AUD 7 982 89 TT 126 Word RTF e of13 D
34. 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 includes 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 5 71 BA Insurance Systems Chapter 5 Accounting Trust Account Summary
35. Telephone Retail Wholesale RETAIL Business Phone Association Mobile Phone Email NA Fax No Executive Ms Hilary Sun TY Gross 1 815 00 TY Net Profit S Unallocated 110 00 Current 0 00 Balance 605 00 LY Gross LY Net Profit 30 Days 0 00 60 Days 0 00 90 Days 715 00 Post Code Active and Expired Policies j Click gt gt cell to view policy history Click any highlighted cell to view details Bend 07001 New Business Existing C To Be Advised ACEV A 08 12 07 08 01 08 DEE 11000 110 00 0 00 0 00 Pol 07000 New Business Existing C To Be Advised A 08 12 07 08 01 08 FERRE 715 00 715 00 495 00 495 00 Transaction Summary A Memo No 08040017 Actions Select Enquiry v Transaction Entry wl Tran Date 07 04 08 Premium 0 00 Class Travel FSL 0 00 Premium Charges Co Branch 0990 Division COM Underwriter GST 0 00 Commission 0 0000 Insurer ACEV ACE Insurance Limited Stamp Duty 0 00 Commission GST Executive HILARYS Ms Hilary Sun Policy Fee 0 00 Witholding Tax FBC Alternate Exec Other Charges 0 00 Due to Insurers Subagent Coinsurance N Premium Charges 0 00 Broker Gross Profit Currency AUD Policy Number To Be Advised Brokers Fee 100 00 Subagent Comm Business Rebate Amount 0 00 Broker Net Profit Insured Name Brokers Fee GST 10 00 Subagent GST Hilary Sun Client Payable 110 00 Client GST The Direct Payment Cash Receipt is used to clear the account Note The credit must be allocated first or the system will produce an error message
36. and Reports and can be run from your Favourites Bank deposit als MUST be run if you are using the ibais Bank Reconciliation system Ibais User Manual 5 16 BA Insurance Systems Chapter 5 Accounting Direct Payment This function is available via Cash Receipting lt is used to account for situations where the client has paid a policy directly to the underwriter The Direct Payment transaction will fully offset the debt owed by the client and fully offset the amount owed to the underwriter The direct payment will be fully allocated to the underwriter s account Any commission owed to the broker will therefore be shown as owed by the underwriter dome Account Selection Change Password All Options Favourites Logout Cash Receipts Te nn Bank Account Currency AUD Banking Location Type of Cash Receipt Debtor Receipt Debtor GIS GE Contact Person eege Telephone Business Terms Executive Outstanding Amt Amount Total Tendered Amount to Allocate Ibais User Manual 5 17 BA Insurance Systems Chapter 5 Accounting E DesignBais Tools Cash Receipts Microsoft Internet Explorer provided by BAIS Fie Edit View Favorites Tools Help Q Back gt EN E A p2 Search se Favorites 2 R X ds z LJ 2 Address ei https designbais bais com au baweb d Google Gr Goo O EP PY Bookmarks E Popups okay Check 2 Translate v AutoFill a gt Sendtow 4 Settings Dess Li oe Cash Recei
37. available items may differ from the one shown here as there are different security settings in place within many databases Available Forms and Reports Type ESE cv Category Select Category v Sub Category Select Sub Category M Type Category sub Category Form Report Click to Run x Reports Brokerage Taken 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 CSR 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 5 69 BA Insurance Systems Chapter 5 Accounting Selecting Trust Accounting Reports from the menu above displays the following screen Home Account Selection Change Password All Options Favourites CH Trust Accounting A Trust Account Summary Report Trust Trial Balance Report ma Control Total K Balancing Report 2 Brokerage Earned Summary Report b Debtor Ageing Reports b Creditor Reports a Return Premiums Reports Unallocated Cash
38. complete You should now click the Print button to obtain a hard copy of the results including any unmatched transactions Once printed you should then click the Clear button to remove all temporary records which were created during the entire process before exiting the screen Any EWAY Settlement which could not be found in the Bank Reconciliation table will be detailed as well as any transaction in the Bank Reconciliation table which is not in the Settled transactions but falls within the EWAY Reference number range You will need to manually resolve any of these unmatched transactions Addendum Inbuilt safeguards and points of interest The consolidation process will reduce the size of the Bank Reconciliation table by consolidating the matched Settlement transaction into a single balance for the nominated Settlement Date This means that if you inadvertently upload a Settlement report which has previously been processed then all of those transactions will be Unmatched This will be obvious during the Check File Phase which will not permit the Consolidation process to proceed At any stage during any of the above phases you may click the Print button to obtain a printed copy of the details displayed on the screen It is recommended that you do this at the conclusion of the Consolidation phase so that you have a hard copy of the transactions which may need to undergo some investigation Ibais User Manual 5 96 BA Insurance Sys
39. for Debtors 11192 50 Royal Sun Aliance 100807 CREC 1500 00 123890 Total for Creditors 1500 00 Total for Currency AUD 12692 50 Total for Company 0 12692 50 Grand Total may be mixed currencies 12692 50 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 5 82 BA Insurance Systems Chapter 5 Accounting Brokerage Earned Report 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 No Company Branch Selected Currency No Currency Selected a Printing Options II Summary Only Preview Mode Printer m 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 e Ibais Insurance Software e E E ES PT Completed Page of 4 HA DDI Search Search Next Actions REP 12293 actions gt BATRAINING Run Date 08 NOW2007 Run Time 17 14 Brokerage Earned Report For All records in file
40. highlighted field for example M Refund Preparation As each step is completed the Status column will reflect this Refund Preparation J Click on SALGAS and the following screen will appear Debtor Refund Summary j t Include another Debtor LL Insert Debtor Code or Look UP Debtor Trading Name Remove Original Amt Outstanding Payment Amt Payee Name Insert the Debtor Code and the Refund Details are then listed Ibais User Manual 5 45 BA Insurance Systems Chapter 5 Accounting Refund Details Debtor CATZ Cool Catz Airconditioning Pty Ltd Payee Name Total Original Amount 8 509 36 Payee Address Total Outstanding Amount 8 509 36 Marsfield NSW 2122 Total Credit Amount 9 313 65 Total Payment Amount Voucher Reference Type Tran Date Orig Amount Outstanding Hold Part Payment Amt Creditor O S CPS 1225 06120001 CRNB 23 12 06 4 313 65 4 313 65 mm 0 00 0 00 137 222555 REC3 30 04 08 5 000 00 5 000 00 PS ES 0 00 Choose the Refund to be processed and Click on the Hold column to release the refund the field will change to a blank and the refund payment is then available Each transaction that is to refunded must be released individually Once the selection is finalised Click on Accept to confirm the transaction Continue this step for all Debtor Refunds that are to be processed in this run A list of all the Debtor Refund recipients will be displayed You can remove a Debtor from the list by clicking on the Re
41. produced Step one is accessed via the All Options menu or can be added to your Favourites Ibais User Manual 5 64 BA Insurance Systems Chapter 5 Accounting All Options Favourites Report Cabinets Btegory Select Category Sub Category Select Sub Category Category Sub Category Form Report Click to Run Processing li BPAY Receipts Input Bank Statement Reconciliation Brokerage and GST Transfers Cancel Receipt Cash Receipts Creditors Open Item and History Ledgers Creditors Unallocated Credits DEFT Receipts Input Debtors Open Item and History Ledgers Deferred Direct debit Update Direct Debit File Generation GL Transactions General Creditor Transactions General Ledger Enquiry ral EE Funder Receipts Input pdate GST NAT Files _ Payments ancel Payment Creditor Hold Release Home Account Selection Change Password All Options Update GST VAT Files ct kosten EME PULSE GL TEST Favourites Report Cabinets End Financial Period 201003 March Reporting Date 31 03 2010 Note If your GST parameters are correctly set up the system will know which reporting period to use monthly or quarterly and which method to use cash or accrual Please contact Support to set this up if you have not used the GST VAT reporting system before Ibais User Manual 5 65 BA Insurance Systems Chapter 5 Accounting
42. 0 Tobl brCurrenoy AUD 5111 18 Tohl rCompany 0 imay be mised ourrenole 6111 18 Grand To til ll Co mpanle c and Al Currenole c 111 18 BKREPO RATS RSD 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 Ir Preview Mode S Printer DEFAULT Run Report Ibais User Manual 5 81 BA Insurance Systems Chapter 5 Accounting 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 N BA TRAINING Run Date 01 NOW 2007 Unallocated Cash Listing Company D BA hsurance Systeme Currency AUD AUSTRALIAN DOLLARS Debtor Name Cre ditor Name Date Type Net Amount voucher Reference Unalloc Dese ABC Pty Ltd 061206 REC1 200 00 43 741852963 ABC Pty Ltd 270407 RECI 1000 00 47 123456 fardvark Enterprises tas Antz Pa 314007 RECI 1837 50 76 CASH Advantage Premium Funding 010507 REC3 678 00 48 CASH BOEPOOI Boe Peep 050307 RECH 1200 00 44 1235655 BUB B01 Bubba Joe Constructions 010807 RECS 777 00 48 CASH DRAUOO1 Or August Bellows 090907 RECI 2000 00 54 234323 42423 423 DRAUOO 1 Or August Bellows 090907 RECI 2000 00 55 9243w erfeu rw erw HAR RO Harry Constructions 050307 RECS 1500 00 44 1235655 Total
43. 0 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 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 30 0 00 0 00 0 00 0 00 72 7 20 0 00 0 00 0 00 79 20 28 80 316 80 0371007 APO 10002 Pymt to Sub SUB ABC 03 1007 APO 10002 Pymt to Sub SUB ABC 0371007 APO 10002 Pymt to Sub SUB ABC 0371007 APO 10002 Pymt to Sub SUB ABC 03 10 07 APO 10002 Pymt to Sub SUB ABC 05 1007 APO 10002 Pymt to Sub SUB ABC O3 1007 APO 10002 Pymt to Sub SUB ABC O3 1007 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 D D Total for company 0 and currency 4UD d d d 4 129 12 98 d 142 78 Total for Company 0 all currencies d d f i d 129 12 98 H A J 142 78 Grand Total all companies amp all currencies S k d 129 12 98 d d 142 78 BKEARNED_R40 Brokerage Taken for a selected period Ibais User Manual 5 84 BA Insurance Systems Chapter 5 Accounting Bank Statement Reconciliation bais allows for Bank Statement Reconciliation for bank accounts managed against specific bank accounts which have been setup in bais To access the Bank Statement Reconciliation functions choose All Options or Favorites if you have made Bank Statement Reconciliation a favorite Select Bank Statement Reconciliation 2 Password All Options Favourites Report Cabinets Logout egory Se
44. 0 00 POTT 12 14 0 00 203 18 5183 05 1918 53 1010 68 0 00 115 00 15441 53 2513 69 1414 43 31280 15 1038 62 31793 24 OTT 12 14 BA Insurance Systems Chapter 5 Accounting Control Total Balancing Report Control Total Balancing Report Trust Accounting Trust Account Summary Report a Trust Trial Printing Options 1 Balance Report Summary Only Control Total Balancing Report Preview Mode C Brokerage Earned Printer L Summary Report DEFAULT ge ye 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 IT Printer DEFAULT Run Report Ibais User Manual 5 75 BA Insurance Systems Chapter 5 Accounting Brokerage Earned Summary Report This function allows you to run a Brokerage Earned Summary Report The report gives an overview of the opening
45. 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 28 Total for Company 0 may be mixed currencies 100 212562 88 39079 24 136537 24 58108 62 1500 00 0 00 447787 98 446287 98 Grand Total may be mixed currencies 100 212562 88 39079 24 136537 24 58108 62 1500 00 0 00 447787 98 446287 98 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 e SS a 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 5 By leaving this field blank the report will sort by client name if you tick the field the report will sort by creditor bais User Manual 5 79 BA Insurance Systems Chapter 5 Accounting 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 currencies you can leave it bla
46. 046 0 00 CMVO01048 20 720 55 0 00 CMVO01048 122 76 0 00 CMVO01055 122 82 0 00 0 00 CMV001055 120105 06050026 04 05 06 03 06 06 1 780 00 1 780 00 119959 06020002 INVE 06 02 06 08 03 06 20 720 55 120094 1 06050015 INVE 02 05 06 02 05 06 122 76 120093 1 06050015 INVE 02 05 06 02 05 06 122 82 r OSOE Click on the Part column to make a Part Payment on any individual invoice A screen will be displayed shown below which allows you to nominate the amount to be paid and any Settlement Discount if applicable to be written off Amounts written off must be within your allowable write off limit If nothing is written off then the balance remains outstanding to be paid at a future date Click on the Hold column to toggle between Hold and Release for any individual invoice Items with an H in this column are on hold and will NOT be released in this payment Ibais User Manual 5 35 BA Insurance Systems Chapter 5 Accounting Part Payments Screen ke DesignBais Tools Hold Release Partial Details Part Payment Previous Voucher 119992 Transaction Date 24 02 2006 Original Amount 1 011 04 Outstanding Amount 1 011 04 e eener Amounts entered here will be written off to Settlement Amount 04 Brokerage and must be within your defined SEN allowable write off limit Once you have made any changes required in the Part
47. 1 36 31 List of Payments to Make Completed 07 08 2008 11 38 24 Cancel Payment Run Not Applicable Post Payments as Listed Completed 07 08 2008 11 38 33 Print Cheques Ignored Allocate Cheque Numbers Run may do again 07 08 2008 11 39 56 Finalise Payment Run Still to be Run List Posting Errors List Unprocessed Payments List Payments by Number List Payments by Type Bordereau Selected Cheque Please note Bordereau Selected Cheque will run the Creditor Remittance this may be selected individually or run automatically when Finalising the Run Check with support that the flag is set to run automatically Finalise Payment Run When you have completed all the required steps and run any required reports you must finalise the payment run Click on a dialogue box will ask you to confirm that you want to Proceed IBScri pt x P Are vou sure you wish to Finalise this Payment Run Click Yes and this closes the payment run _w Please Note You can enquire on previous transactions by accessing Payments Enquiry on the All options Screen under the accounting list or on the button on the Creditor Payments Screen If a Creditor Payment is in progress this button will be greyed out Ibais User Manual 5 56 BA Insurance Systems Chapter 5 Accounting Cancelling Creditor Payments and Debtor Refunds Overview This function is provided to enable you to write back any cheque that has been processed through th
48. 11 09 12 40 100 _ Underwriter Overseas The reports will be grouped by whether there are email _ Witholding Tax email addresses defined for them or not as shown here Drang Duty email Underwriters have been divided into two with email to indicate the ones that can be emailed directly _ Underwriter Overseas email REP 15303 31884 23 11 09 12 39 To email the reports to the various creditors open the report to the Preview Screen Completed Page of 2 HA DDI Search Search Next Actions REP 15303 31885 actions XLS REP 15303 31885 actions Pri nt BA INSURANCE SYSTEMS Select Email Pages to Recipients from a He 23 NOV 2008 12 39 ABC TISSUE the Actions Drop Down menu The email addresses are displayed after Delete this Report the EMAILPRINT command and each new email address triggers a new email to be created To Be Advised INS CHA 02 08 01 Antz Pantz Pty Ltd t as Antz ABCO Total for Reference 45665879 18 11 2009 When you select Email Report to Recipients the following screen appears Ibais User Manual 5 41 BA Insurance Systems Chapter 5 Accounting e ibais is est En Rec d LC ST E Email Report Details From Page To Page Details entered here will be used in the emails generated Update the sender address to use your own address Input your preferred Subject and Message Text Senders Email Address Email Subject Header Message Text
49. 14 Cancel Rept ii4 for FREDoOOI 7 640 00 vi to de selected 12 02 2008 ARCHRElIid Cancel Rept 1id for FREDOO1 7 640 00 x bais User Manual 5 88 BA Insurance Systems Chapter 5 Accounting Suspending lf at any time you need to suspend the bank reconciliation statement you are working click the button This saves the current reconciliation without having to complete and close it so that you can continue working on it at a later time To resume your suspended reconciliation of this statement simply select bank statement reconciliation from the all options menu or favorites menu and choose the bank account you were previously reconciling This will load the suspended reconciliation that you were previously working on Print Statement This option allows you to print the current reconciliation statement 23 03 2010 DEP sheri cc180310 65 00 24 03 2010 1 19 CU Insurance 90 53 24 03 2010 Zurich Australian Insurance il 469 10 24 03 2010 Zurich Australian Insurance 1 684 85 25 03 2010 ABC cba 880 00 ar E 25 03 2010 Antz Pantz ref 100 00 25 03 2010 DEP Baggins Jilbo ASD 3 914 36 25 03 2010 DEP Deposit Slip 62 period 200902 e 8 450 56 25 03 2010 D Deposit Slip 62 period 200904 14 335 585 15 Print Statement Record Unprocessed Item 53 779 44 53 429 47 xixixixixix lx x x Bank Statement Reconciliation Account 050 Statement Number 12 Statement
50. 19 05100008 08 10 2004 TT 32 05100012 08 10 2004 2 688 40 130 05100029 13 10 2004 8 485 40 05100030 15 10 2004 1 818 30 160 05100007 09 10 2005 1 395 63 User armj Account B4 TRAINING Form SCPAYCONT_B10 8 Lo Trusted sites The transaction reverses the payment entry and re establishes all of the Open Items Ibais User Manual 5 60 BA Insurance Systems Chapter 5 Accounting Debtor Refund Cancellations Selecting Debtor Refund from the drop down brings up the following bais form Select the Debtor and Search for the Cheque Payment No The search form will show all refund payments made to the Debtor Select the payment to be cancelled Cancel Payment Submit Ibais Insurance Software Select Payment to Cancel Debtor PIGOUT Harry Smith t as Pig Out Cafe Select Payment to Cancel Company Branch 0 BA Insurance Systems Currency AUD AUSTRALIAN DOLLARS ee Date Amount Details 05 05 06 159 09 Harry Smith t as Pig Out Cafe Cheque Payment No Payment Date Bank Account Debtor Payment Amount Total Cancelled Transaction Date Reference Narrative e Select Page Go to Page bais User Manual 5 61 BA Insurance Systems Chapter 5 Accounting Complete the process by entering the Transaction Date Reference and Narrative The Submit button becomes available when you Tab from the Narrative field
51. 2 47 18 03 2008 28030809 Royal Sun Alliance 1 972 83 15 04 2008 DEP Deposit Slip 25 12 400 18 15 04 2008 999765 ABC Sub Agent 950 40 15 04 2008 999877 Advantage Premium Funding 678 00 Print Statement Record Unprocessed Item 2 200 00 e BAIS Training Record Unprocessed Item 0eceeeceeeeeeneneeeeereeeees KM Record Unprocessed Item submit JAN Previous Bank Code Name of Bank 050 Input the required amount use negative for an unprocessed withdrawal Date 06 01 2009 Statement 12 Balance 12 Currency AUD Amount 500 00 Details Deposit from T Jones Reference The above example will create an entry as shown below which is automatically selected for the current statement reconciliation 10 12 2008 1012200801 GC CREDIT CARD FEES 3 066 25 06 01 2009 Balance 12 Deposit from T Jones 23 02 2009 ARCWRB160 Cancel Rept 160 for ANTZ 4 469 02 nena en fe ae eS ee Arr A second entry will also be created to balance this entry in a future reconciliation when the item is processed on the system 10 12 2008 DEP GC CREDIT CARD FEES AC PAID TWICE 10 12 2008 1012200801 GC CREDIT CARD FEES 3 066 25 07 01 2009 Balance 12 reversa Deposit from T Jones 23 02 2009 ARCWRB160 Cancel Rept 160 for ANTZ 4 469 02 06 04 2009 APCCRC165 0 00 16 04 2009 99879 Royal Sun Alliance 3 053 43 This item will be selected with the actual receipt in a later reconciliation Ibais User Man
52. 2008 ARCWRB114 Cancel Rept 114 for FREDOO1 2 640 00 04 03 2008 DEP Deposit Slip 21 385 884 55 07 03 2008 Balance 9 reversal ANTZ 100 00 07 03 2008 Balance 9 reversal Deposit 275 01 07 03 2008 Balance 9 reversal bank charge 9 00 18 03 2008 18030803 Brokerage Transfer 72 637 20 18 03 2008 28030805 CGU Insurance 22 653 95 18 03 2008 18030803 1 GST Transfer 7 541 43 18 03 2008 28030808 QBE Mercantile Mutual 13 332 47 18 03 2008 28030809 Royal Sun Alliance 1 972 83 15 04 2008 DEP Deposit Slip 25 12 400 18 15 04 2008 999765 ABC Sub Agent 950 40 15 04 2008 999877 Advantage Premium Funding 678 00 x x x x x x x x x x x x x x x x Print Statement Record Unprocessed Item 0 User baweb Account B4 TRAINING Form SCBANKS_D10 with all the transactions B Trusted sites Ibais User Manual 5 86 BA Insurance Systems Chapter 5 Accounting Enter in the date of the statement you are about to complete the process for Account Selection Change Password All Options Favourites Report Cabinets Logout Bank Statement Reconciliation Close Statement Account 050 BANK OF MELBOURNE BA INSURANCE SYSTEMS Currency AUD Last Reconciled Statement 7 Current Statement gt GL Period Last Reconciliation Date 22 05 07 Current Statement Date 31 03 2010 201008 Last Statement Balance 35 280 470 11 Current Statement Balance 36 457 205 30 Calculated Statement Balance 35 280 470 11
53. 290 122 52 Be 1 425 924 89 CMVO01008 E E SS 119992 03100035 INVE 24 02 06 26 03 06 1 011 04 0 00 CMVO01020 119672 05070041 INVE 12 07 05 11 08 05 1 045 00 1 155 00 CMVO01033 120459 05120003 INVE os 25 08 06 990 00 0 1 100 00 CMV001037 0 1 155 00 11 550 00 0 00 0 00 0 00 CMVO01037 CMVO01038 CMVO01046 CMV001046 CMV001048 20 720 55 0 00 CMV001048 122 76 0 00 CMVO01055 122 82 0 00 0 00 CMVO01055 kk A ee A 119850 05120003 INVE 06 12 05 05 01 06 1 045 00 20046 06030043 INVE 28 03 06 27 04 06 10 450 00 119818 04100001 INVE 11 11 05 11 12 05 4 402 74 119817 04100001 INVE 11 11 05 11 12 05 25 146 10 120105 06050026 INVE 04 05 06 03 06 06 1 780 00 119959 06020002 INVE 06 02 06 08 03 06 20 720 55 120094 1 06050015 INVE 02 05 06 02 05 06 122 76 120093 1 06050015 INVE 02 05 06 02 05 06 122 82 4402 74 25 146 10 1 7 80 00 H H H emm gi f 7 a Click on the Part column to make a Part Payment on any individual invoice A screen will be displayed shown below which allows you to nominate the amount to be paid and any Settlement Discount if applicable to be written off Amounts written off must be within your allowable write off limit If nothing is written off then the balance remains outstanding to be paid at a future date Click on the Hold column to toggle between Hold and Release for a
54. 5 97 BA Insurance Systems Chapter 5 Accounting dt SI Dee el DI Ge ZE Pe Cer oa TREE opp E Ee x ald LOT SOs att Les ie Brenint Calartinr Bal E e EE EK Vinal cree JILL SCIELO LA Ge FAasSs Ur AU Options 7 Client Statements Statement Date Message To Appear On Statement Run Report Clear You can message that will appear on this run i include a Run Type Individual Company Branch all SS Sort by Client Name Selected Executive No Executive Selected Client Code Selected Division No code al Company Branch Sort Sequence Client Name Next Sort Sequence Client Name Selected Clients Selected Client Name BP Include Allocated Items E This allows you to 1 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 5 98 BA Insurance Systems Chapter 5 Accounting Home Account Selection Change Password All Options Favourites Client Statements Run Report Statement Da
55. 8 FO Ol E 5 39 Payment Remittance Report Production ss 5 39 Finalise NET A PP ER R 5 43 Debtor Refund Payments iii 5 44 ee Te E CT 5 44 Rend Propala UO ae en D 2e do en nn ne 5 45 List of Payments to Make ss iiiieisssrreeeeseeeeeeesnnne 5 46 Post Payments as Listed iii 5 47 Print RE 5 48 Allocate Cheque Number 5 48 Klein 5 48 Finalise Payment RUM E 5 49 Manual Creditor Payment ccccccseeseeeeeeeeeeeeeeeeeeeeeeeeesaaeeseeeceeeeesaaaeaceeeeeeeessaeaeeeeeeeeessaaaganeeeeess 5 50 ACCESSING Payments cccccceeeeeeeeeeeeeeeeeeeeaeeeeeeeeeaaaeeeeeseaaeeeeeaaaaeeeeessaaeeeeessaaaeesessaaneeesessaaees 5 50 Manual Hold Release ccccccccceseeeceeeceeeeceeeeeeeseeeeeeeeeueeeeeeeaeuceeeseasaseeeesseaeeeeesseaeeeeeessaaeeeees 5 51 List of Payments to Make siennes 5 53 Ibais User Manual BA Insurance Systems Post Payments as Listed NEE 5 54 EU O ai A E A E A E EEA E AE 5 54 Allocate LE TE e E 5 55 Elei 5 55 FANS ae VAN SUN RUN aars ascectuianeaetiica tena st ENE EAE E ciated EEE E 5 56 CANCELLING CREDITOR PAYMENTS AND DEBTOR REFUNDS esssnsssssennnnnrrrrrrrrrrrosssennnnnnnrrrrrrreeene 5 57 CO A EO E EE E E E 5 57 Creating the Transaction iii 5 57 Creditor Cancellations ccccccccssessceccceceeeeeeseeeceeeeeceeeeeeeceeeeeseaeeeseeceeeeesseeaseeeeeeeessaeaseeeeeeeeeesaas 5 59 Debtor Refund Cancellations iii 5 61 BROKERAGE AND GST TRANSFERS ENEE 5 62 GOPAN ATRAE 16 EE 5 64 TRUST ee Th T
56. 834 CASH i 13 07 2006 100 00 100 00 2837 CASH i 13 07 2006 100 00 100 00 2838 CASH i 13 07 2006 100 00 100 00 2839 CASH i 13 07 2006 100 00 100 00 2840 CASH i 14 07 2006 100 00 100 00 2841 CASH i 14 07 2006 100 00 100 00 2844 CASH i 17 07 2006 100 00 1 00 2845 CASH i 17 07 2006 100 00 1 00 2846 CASH i 17 07 2006 100 00 1 00 2047 CAC i 17 n7 9nN wl DD OD d OO The last Tender Type for this client Details of the Outstanding balance bais User Manual 5 5 BA Insurance Systems Chapter 5 Accounting Local Currency Entering a local currency Tender Type and amount will automatically populate the Amount to Allocate the Amount Actually Banked and the Transaction Table Cash Receipts Bank Account Blank Account Currency AUD Banking Location Type of Cash Receipt Client SS Client Code ANTZ Client Name Amount to Allocate 1 500 25 Contact Person Telephone Business Terms Executive Outstanding Amt Danny Boyd 02 9999 0000 02 3299 0032 90 BLAH 28242 25 Cash Amount Actually Banked CASH Tender Type Date Amount Antz Pantz Clothing Co Document 120010 120011 120104 120105 2833 2834 2837 2838 2839 2840 2841 2844 2845 2846 23042 Reference 06030003 06030010 06050025 06050026 CASH CASH CASH CASH CASH CASH CASH CASH CASH CASH CAC 22 07 2006 1 500 25 Source Broking Broking Broking Broking
57. Chapter 5 Accounting Automatic Hold Release Click on the highlighted field CR This option allows you to produce reports and automatically release items for payment based on these reports Outstanding Insurer Creditor Policy Payments Use the drop down menu to select to run by Creditor or Creditor Type H Creditor Type is selected the Insurer Creditor and Creditor Name option is replaced by DT Toor der Creditor Type Use the drop down Include Claims Y N menu to select the type of BA Insurance Systems creditor This selection will run all Creditors in this Creditor type Include Part Paid editor E g All Underwriters _Insurers Creditors Creditor Hame Witholding Tax Leave Blank for all Select Report Selection by Creditor General Creditor FSL stamp Duty If running by Creditor input Creditor Code or leave blank to include all Creditors Release Fully Paid Invoices for Payment d d The system will automatically select the fully paid invoices due for payment based on credit terms of the underwriter Click on Release Fully Paid Invoices for Payment and then Click Run Report Clicking on Run Report provides the following options Ibais User Manual 5 33 BA Insurance Systems Chapter 5 Accounting ke DesignBais Tools Selection for R40 Insurer Payments Report Printing Options Click the Preview Mode tick box this allows you to view the report on screen Leave the printer set to
58. Date Reconciled Date Run Date 23 NOV 2009 09 42 15 04 2008 200401 30 05 2008 200401 Balance 11 reversal 01 06 2008 200412 DEP 03 06 2008 200403 419 344 73 Withdrawals 18 03 2008 200401 18 03 2008 200401 18 03 2008 200401 Unreconciled Deposits 22 05 2008 200401 Deposit Slip 26 3 120 66 04 06 2008 200401 Deposit Slip 27 15 274 22 11 11 2008 200401 Deposit Slip 28 period 200401 402 320 00 11 11 2008 200404 Deposit Slip 28 period 200404 5 051 698 60 12 11 2008 200404 Deposit Slip 29 5 001 139 77 10 12 2008 200404 Deposit Slip 30 3 066 25 10 12 2008 200404 GC CREDIT CARD FEES AC PAID TWICE 3 066 25 23 07 2009 200404 gnigc bg 1 204 01 02 11 2009 200404 Deposit Slip 32 71 801 026 93 16 11 2009 200404 batest assdd 4 000 00 LKE 82 285 916 69 Unreconciled Withdrawals 18 03 2008 200401 GST Transfer APBNKRECDEL_RO01 Bank Reconciliation Report Page 1 of 4 Ibais User Manual 5 89 BA Insurance Systems Chapter 5 Accounting Record Unprocessed Item Occasionally it is necessary to reconcile an item which appears on the statement but has not been processed in the system yet eg if a payment is made directly into the bank account on the last day of the month it may not be processed in the system until a few days into the following month To record an item such as this click on Record Unprocessed Item as below 18 03 2008 18030803 1 GST Transfer 7 541 43 18 03 2008 28030808 QBE Mercantile Mutual 13 33
59. Google CC ena O E i Bookmarksy check 3 Translate Autolink YE AutoFill a Sendtow Q Settings Home Account Selection Change Password All Options Favourites Logout Cancel Receipt Cancel Receipt for No Selection v No Selection Debtor Receipt Creditor Receipt User am Account B4 TRAINING Form ARTRANS_B10 Trusted sites Ibais User Manual 5 26 BA Insurance Systems Chapter 5 Accounting Client Receipt Cancellations Selecting Debtor Receipt from the drop down brings up the following bais form Select the Debtor and Search for the Receipt Number The search form will show all payments made by the Debtor Select the receipt to be cancelled Cancel Receipt Submit Debtor Receipt v Ibais Insurance Software Select ReceipiioGancel CCC Debtor ABCOOL ABC Pty Ltd Select Receipt to Cancel Company Branch 0 BA Insurance Systems ae Cust Ref Tran Orig Amt Bankcode Date Currency 4UD AUSTRALIAN DOLLARS 123456 27 04 07 1000 00 050 Roconi Number Eo Receipt Date 06 12 06 200 00 050 Bank Account Debtor Receipt Amount Discount Other Total Cancelled Transaction Date Reference Narrative Affect Bank Deposit Slip Page 1 of 1 Select Page Go to Page Note the flag Affect Bank Deposit Slip will allow you to reverse an entry from the Bank Deposit Slip provided the Slip has not been printed e
60. Receipt Receipt Receipt Receipt Receipt Receipt Receipt Receipt Receipt Receipt Dacainte Ibais User Manual AUD Australian Dollars NORTH SYDNEY Insured Ascott Sales Ascott Sales Antz Pantz Clothing Co Antz Pantz Clothing Co 5 6 in Bank Currency Description Bank Client Tendered Local Due Date 15 04 2006 15 04 2006 03 06 2006 03 06 2006 13 07 2006 13 07 2006 13 07 2006 13 07 2006 13 07 2006 14 07 2006 14 07 2006 17 07 2006 17 07 2006 17 07 2006 17 07 9nn Original Amount 14 718 00 14 718 00 1 686 25 2 000 00 100 00 100 00 100 00 100 00 100 00 100 00 100 00 100 00 100 00 100 00 1 D OD Currency AUD AUD AUD AUD mount 1 500 25 1 500 25 1 500 25 1 500 25 Rate Local 1 0000 1 0000 1 0000 Allocation 1 of 1 ANTZ Total Tendered Amount to Allocate Outstanding Amount 11 514 00 14 718 00 1 686 25 1 032 00 100 00 100 00 100 00 100 00 100 00 100 00 100 00 1 00 1 00 1 00 sion Allocated Partial Amount Payment 1 500 25 1 500 25 Full Payment A BA Insurance Systems Chapter 5 Accounting Allocating Deposits Deposits may be fully or partially allocated or may be left on the account unallocated To allocate the deposit it is only necessary to AKA duku alfelalivelacremer 1 in the allocation panel Cash Receipts Bank Account Banking Location Type of Cash Receipt Client Te
61. Reconciltion Discrepancy 1 176 735 19 Clear Selection Include All Date Reference Description Deposit Withdrawal Include 17 10 2007 2 cgu insurance 72 27 f T ji 17 10 2007 777 222 Zurich Australian Insurance 452 00 E T I 18 10 2007 90 123 Sub Agency 349 67 pm L f 31 10 2007 311007 Austnet Undewriting Agency Pty Ltd e D 99 86 09 11 2007 DEP Deposit Slip 40 52 477 95 12 11 2007 2001 GST Transfer 12 11 2007 302 2 QBE Mercantile Mutual Ensure that the GL Period is set to the period Robert Fleming Insurance Brokers uk ITD you are reconciling le if you are reconciling Fe D PIT ER dre 12 11 2007 12110705 12 11 2007 12110701 ALLIANZ AUSTRALIA INSURANCE LTD the end of March statement using 31 3 10 as 12 11 2007 12110702 PE a Limited the statement date then the GL period should t 12 11 2007 123 EES be 201008 for July to June financial year 12 11 2007 12110703 BAIS 12 11 2007 124 Harry Smith t as Pig Out Cafe 1 031 45 12 11 2007 302 1 Lumley General insurance 524 24 T 12 11 2007 12110704 Overseas Underwriter 860 00 12 11 2007 12110706 Sheri Andrews 11 00 4 kb 12 11 2007 7 Zurich Australian Insurance 1 691 48 E T RENE Ca P E Print Statement Record Unprocessed Item 0 00 Enter in the closing balance of the current statement you are reconciling SE
62. 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 movements 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 Database All Linked Databases Company All Companies All reports generated in bais will display a screen similar to the one shown below where you can select to preview the report or send to your printer Click Run Report when selection criteria has been input Ibais User Manual 5 72 BA Insurance Systems Chapter 5 Accounting Printing Options Preview Mode An example of the Trust Account Summary Report is reproduced here EA TRAINS Eten Deis 11 UN SooF7 Fun Time 1542 Trost Account Summary Re
63. Uploaded EWAY Settlement transaction must match previously unreconciled bais Bank Reconciliation transactions before the Consolidation Phase may proceed bais User Manual 5 95 BA Insurance Systems Chapter 5 Accounting Phase 3 Consolidation Click the Consolidate link to complete the consolidation of settled transactions into a summary balance in the Bank Reconciliation table EWAY Bank Consolidation amp Reconciliation Upload File EWAY Settlement Report eway_petplan_310810 TXT Bank Account 050 Blank Account Check Criteria Result Uploaded file eway_petplan_310810 TXT Checked Nominated Settlement Oste 31 08 2010 Total number of records 124 Number matched by EWAY Id with bank reconciliation 115 Number matched with same amount 115 Total settled amount of fully matched records 5633 64 Number settled on same day as transaction 114 Acceptabdity of uploaded file OK Consolidation amp Reconciliation was successful Summary and exceptions are below Date Reference Details Amount lt lt EWAY Reference No ranges gt gt reconciled Reconoled Amt From 25993953 To 26025369 lt lt Unmatched Bank reconciliation re 26010306 26010508 lt lt Unmatched EWAY transaction records gt gt 26009430 26009525 26009683 26009751 26009801 26009856 26010326 26010358 26020228 The results of the consolidation will display on the screen Once the Consolidation summary has displayed the process is
64. ailable as for any other report using the Print Selected or Email Selected hyperlinks Refresh File Listing i lecte i lecte Select All Clear Select bais User Manual 5 39 BA Insurance Systems Chapter 5 Accounting These reports also have the ability to be emailed directly to the various creditors if their email addresses are captured in the Creditor Email Address for Accounts field as shown below Home Account Selection Change Password All Options Favourites Report Cabinets Loga Insurer Creditor Masterfile Creditor Account No Company Branch BA INSURANCE SYSTEMS Trading Name Insurance Co Limited Search Key Abbreviated Name Postal Address A C N A B N Registered For GST Input Tax Credit Account No 55664654 AFSL Postcode Creditors Telephone No Fax Number Head Office Phone No Contact Person Email Address for Accounts te Classification Code Unclassified Currency Code Terms Code Ibais User Manual 5 40 BA Insurance Systems Chapter 5 Accounting Once switched on you will be able to email the reports directly to their Accounts email address by accessing the Payment Report Cabinet and locating the relevant Payment Run ome Account Selection Change Password All Options Favourites Report Cabinets Logout Cabinet Report Interface Available Cabinets am a End of Day J Ge Payment Run 253 End of Month Payment Run 256 Delete the Drawer a Stamp Duty REP 15303 31891 23
65. an cater for additional bank charges associated with credit card payments and overseas currencies if required When the Tender Type selected is a credit card type e g CC or AMEX then a field appears for the Credit Card Surcharge fee see screen shot below This amount is automatically calculated The required rate is set up by BAIS Support so please contact support bais com au if you would like this set up in your database lf an amount is shown in this field it will be deducted from the total tendered leaving the amount available to allocate Amounts at Credit Card Surcharge will be posted as CC Surcharge in the General Ledger and the GST component posted as GST These amounts then form part of your available earnings and GST in your next Brokerage and GST Transfer Cash Receipts WEE WC Auto Allocate F BANK OF MELBOURNE Currency AUD Banking Location Type of Cash Receipt Ej Amount to Contact Person ies Gier Allocate Telephone 02 9999 1111 HA antz 688 98 Business x Terms 0 Executive Sheri Andrews Outstanding Amt 19556 45 Tender Type cc CREDIT CARDS Amount Actually Banked 688 98 Date 11 06 2009 AUD AUSTRALIAN DOLLARS NE SRE Amount 688 98 Credit Card Surcharge Description Currency Amount Rate Local Card Number Bank AUD 688 98 1 0000 Expiry Date f Client AUD 688 98 1 0000 SR Tendered AUD 688 98 1 0000 Local AUD 688 98 Name on Card Authority Reference R
66. ated click to continue Ibais User Manual 5 38 BA Insurance Systems Chapter 5 Accounting Reports You can run several reports during the payment run process These are accessed via the Reports drop down menu as shown below Creditor Payments Save Status For Company Branch fo BA Insurance Systems Payment Run Number And Currency aun AUSTRALIAN DOLLARS From Bank ccount foso Bank Account Name Bordereau Sort Sequence fDue Date Include Debit Payments E Payment Run Date Action Step Status Date Time Payments Initiated 28 07 2008 15 46 39 Automatic Hold Release Completed 28 07 2008 15 47 21 Manual Hold Release Ignored List of Payments to Make Completed 28 07 2008 15 47 39 Cancel Payment Run Not Applicable Post Payments as Listed Completed 28 07 2008 15 47 46 Print Cheques Ignored Allocate Cheque Numbers Run may do again 28 07 2008 15 48 53 Finalise Payment Run Still to be Run elect Report Select Report List Posting Errors List Unprocessed Payments List Payments by Number List Payments by Type Bordereau Selected Cheque Please note Bordereau Selected Cheque will run the Creditor Remittance This may be selected individually or run automatically when Finalising the Run Payment Remittance Report Production Payment Bordereau Selected Cheques are automatically sent to the Payment Cabinet in Report Cabinets Capability to email these reports to yourself or print these reports is av
67. ated value oldest invoice s This function is available when the Auto Allocate button is not 3Y Kothi Cash Receipts Bank Account asc Banking Location Type of Cash Receipt Blank Agcount Currency AUD Client BE client code ANTZ Client Name Contact Person Telephone Business Terms Executive mount to Allocate 26 232 00 Tender Type Date CHEQUE Amount 26 232 00 Bank COMMONWEALTH MOOREBANK ANDREW 002589 Branch Name Drawer Cheque Number Antz Pantz Clothing Co Document Reference Source Insured 120010 120011 06030003 06030010 Broking Ascott Sales Broking Ascott Sales Ibais User Manual Bheque AUD Australian Dollars NORTH SYDNEY Class TPP TPP 5 9 Due Date 15 04 2006 15 04 2006 Outstanding 4mt Amount Actually Banked in Bank Currency Description Currency Bank AUD Client AUD Tendered AUD Local AUD Danny Boyd 02 9999 0000 02 3299 0032 90 BLAH 26232 00 26 232 00 Amount 26 232 00 26 232 00 26 232 00 26 232 00 Rate Local 1 0000 1 0000 1 0000 Allocation 1 of 1 ANTZ Total Tendered Amount to Allocate Original Outstanding Amount Amount 14 718 00 11 514 00 14 718 00 14 718 00 26 232 00 0 00 Allocated Partial Amount Payment 11 514 00 14 718 00 Full Payment Allocated Allocated BA Insurance Systems Chapter 5 Accounting Credit Card Charges The system c
68. balance amount brokerage earned and taken during the period the closing balance and the 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 Eamed Summary Report For Financial Year 2004 and Financial Month 1 sorted by Compan yBranch by Currency bois ent teen SE Currency AUD AUSTRALIAN DOLLARS Client Fees Commission Forei Ps Brokers Fee Brokers Comm Brokers GST Subagent Variance Exd Subagent Exd Subagent Commission 0 00 l 0 00 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 ENEE nen ANG tO Withdraw Ibais User Manual 5 76 BA Insurance Systems Chapter 5 Accounting 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 cur
69. ccount B4 TRAINING Form DBIUSERS_DSO Ibais User Manual 5 57 BA Insurance Systems Chapter 5 Accounting The dropdown provides access to the cancellation of Creditor payments or Debtor refund cheques Ibais Insurance Software Cancel Payment Microsoft Internet Explorer provided by BAIS ME File Edit View Favorites Tools Help a OH Back EN a Lei ES Search Se Favorites E 2B X gt L 33 Address E https designbais bais com au baweb a Go Google Co Go Ee FB Bookmarksy DS Check 21 Translate A Autolink SS AutoFill a Sendtow 4 Q Settings Home Account Selection Change Password All Options Favourites Logout Cancel Payment Cancel Payment for No Selection No Selection Creditor Payment Debtor Refund User armj Account B4 TRAINING Form SCPAYCONT_B10 L Trusted sites bais User Manual 5 58 BA Insurance Systems Chapter 5 Accounting Creditor Cancellations Selecting Creditors from the drop down brings up the following bbais form Select the Creditor and Search for the Cheque Payment No The search form will show all payments made to the Creditor Select the payment to be cancelled Cancel Payment 11 if Creditor Royal Sun Alliance Ibais Insurance Software Select Payment to Cancel Company Branch 0 BA Insurance Systems Select Payment to Cancel Currency 4UD AUSTRALIAN DOLLARS Reference Date Ariane Details Che
70. clwnr boo Inbox Microso Development 4 http 192 168 5 94 by TTWIN default Dh Documents Mi untitled Paint Jv Trusted sites SR 5 24PM BA Insurance Systems Chapter 5 Accounting Click Close when the file has been successfully uploaded Now select the Bank Account from the drop down list Uplosd File ew AY Settlement Report ewsy_petplan XS 1 0_bet C3 User mip Account BA DEV Fanne BRPARANS P997 Note that in these Phases all Links or buttons are deactivated as soon as they are clicked This will avoid duplicated processing Phase 2 Check the Uploaded File Click the Check File link and the uploaded file will be checked against the Bank Reconciliation table which is automatically maintained by the bais system EWAY Bank Consolidation amp Reconciliation Upload File EWAY Settlement Report eway_petplan_310810 TXT Bank Account 050 Blank Account Check Criteria Result Uploaded file eway_petplan_310810 TXT Checked Nominated Settlement Date 31 08 2010 Total number of records Number matched by EWAY Id with bank reconciliation Number matched with same amount Total settled amount of fully matched records Number settled on same day as transaction Acceptability of uploaded file Consolidate The results are displayed and the process will determine whether Phase 3 Consolidation can proceed A high percentage of the
71. conciled bank transactions Each phase must be completed successfully before the next one can be started Additionally the process will not allow any phase to be repeated Phase 3 Consolidation will continue until all relevant items have been updated The Clear button acts as a Cancel function during Phases 1 and 2 At the end of Phase 3 the clear button simply refreshes the screen so that another settlement date may be processed Pressing clear will remove a Phase 1 ll temporary files and records which are created during the preceding process Upload the EWAY Settlement File Click the highlighted Load text in the Upload File section of the screen Choose Browse and then browse to the folder or desktop where you saved the txt file Select the file and click Open Development Account BA DEV EWAY Bank Consolidation Reconciliation Microsoft Internet Explorer provided by BAIS Pty Ltd MCE GO gt Eise oe b Je Favorites B DesignBais B8 Development Account B X Development Account BA DEV v Page Safety Tools DesignBais Editor DesignBais Help Change Password Account Selection Favorites EWAY Bank Consolidation amp Reconciliation a System Parameters a Style Definition a Style Groups a File Properties P Field Properties a Menu Definitions a User Groups a Users a Selection Process P Forms Designer Upload File Settlement Re
72. d Screen If a Debtor Refund is in progress this button will be greyed out Ibais User Manual 5 49 BA Insurance Systems Chapter 5 Accounting Manual Creditor Payment This function enables the manual payment of Creditors Underwriters and or sub agents Accessing Payments Click on Accounting on the Home page or All Options on the top menu as shown below to display all available options Select Manual Creditor Payments from the Accounting list Available Forms and Reports Select Type Category Select Category Sub Category Select Sub Category Favorites dre EE Maintenance Foreign Currency Exchange Rates Yes Insurer Creditor Maintenance No Inter Currency Exchange Rates No Processing Bank Statement Reconciliation Brokerage and GST Transfers Cancel Receipt Cash Receipts Creditors Open Item and History Ledgers Debtors Open Item and History Ledgers GL Transactions General Ledger Enquiry Receipt Enquiry Cancel Payment Creditor Payments Debtor Refund Payments Manual Creditor Payment Payments Enquiry Sundry Creditor Payments AP Creditor Master AP Creditor Trial Balance Refine by Description Ir O and the following will appear Ensure Company Branch Currency and Bank Account from which payment is to be made is displayed correctly The screen now provides additional options as below Creditor Payments Far Company Branch E BA Insurance Systems Payment Run Number New And Currency AUD AUSTRALIAN
73. ditor to look up the creditor or simply type in the creditor code Please Note If the Remove column shows an R it is an auto remove this is usually a negative remittance and cannot be included in the payment run Ibais User Manual 5 34 BA Insurance Systems Chapter 5 Accounting Hold Release Summary Include another Creditor Creditor Trading Name Remove Original Amt Outstanding Held Amt Payment Amt Discount Amt Amount Due Ga ROYAL INSURANCE COMPANY 8 955 046 17 5 977 052 31 5 706 063 30 270 989 01 0 00 270 989 01 CECR LLOYDS OF LONDON O2 885 267 23 886 061 36 117 073 55 768 987 81 0 00 768 987 81 If 9QBEO2 QBE INSURANCE AUST LIMITED 184 368 74 184 368 74 36 097 96 148 270 78 0 00 148 270 78 O iSUBA Overseas Subagent 469 00 469 00 211 07 257 93 0 00 257 93 M MBA Mamba Insurance Pty Ltd 1 144 242 30 1 120 800 50 823 653 35 297 147 15 0 00 297 147 15 S BAYA SUBAYA AGENCIES 4 379 81 4 279 81 0 00 4 279 81 0 00 4 279 81 S BCRED Subagent Creditor 1 019 00 827 56 363 45 464 11 0 00 464 11 Al PC Australian Reinsurance Pool Corporation 5 939 01 3 851 21 1 515 31 2 335 90 0 00 2 335 90 CRETE TR A Gallagher 464 341 71 467 341 71 337 040 40 130 301 31 0 00 130 301 31 Si BS Subagent Five 17 82 17 82 0 00 17 82 0 00 17 82 If you want to include an additional invoice or remove an invoice from the payment list for a particular creditor click on the Creditor Code to display the list of invoices for that creditor as shown below
74. dividual invoices in the payments Click on Include another Creditor to look up the creditor or simply type in the creditor code This will display a list of all transactions for that Creditor Hold Release Summary Include another Creditor Input or look up Creditor Remove Original Amt Outstanding Held Amt Amt Payable Discount Amt Payment Amt bais User Manual 5 51 BA Insurance Systems Chapter 5 Accounting Input or Look up Creditor and the screen below will appear This will display a list of all transaction for that Creditor Select the invoice you wish to pay by Clicking on the Hold column to release the payment Should you make an error you may put everything on Hold by Hold All and start again Hold Release Details ROYAL INSURANCE COMPANY ROYAL Creditor Total Original Amount 6 015 762 12 Total Payment Amount 270 989 01 Total Outstanding Amount 5 977 052 31 Total Discount Amount 0 00 Total Held Amount 5 706 063 30 Total to Pay 270 989 01 Voucher Reference Type Tran Date Due Date Outstanding Hold Part Payment Amt Discount Debtor 0 5 DPS Policy Number 119372 04040004 INVE 18 02 05 20 03 05 1 267 00 1 344 00 U 040331b 119854 05120005 INVE 08 12 05 08 12 05 1 005 22 RW 1492 60 171A001621CMP 119855 05120006 INVE 08 12 05 08 12 05 1 451 45 RW 1 644 68 2300001 1XTST 119485 05050016 INVE 16 05 05 15 06 05 1 264 37 WI 1 557 82 53800333 119602 05060040 INVB 27 06 05 27 07 05 1
75. e system to pay creditors or refund cheques for debtors which must be reversed for some reason e g lost in mail Creating the Transaction The transaction is entered from your Favourites menu bais Insurance Software Available Forms and Reports Microsoft Internet Explorer provided by BAIS CHIC File Edit View Favorites Tools Help CO Back X EN a Le P Search 5 Favorites Gi X l d Address El https idesignbais bais com au baweb v Go Google CC v Go oO B Bookmarksy check 3 Translate Autolini AutoFill a Sendtow settings account Selection E Fa Available Forms and Reports Type Select Type _ E Category Select Category v Sub Category Select Sub Category v Display All pe Il Category Sub Category Form Report Click to Run Broking Processing Client Enquiry and Policy Processing Task Management General Letters Broking Reports Earned Amounts Life Non Life Processing Client Claims Enquiry and Claims Processing Accounting Reports Bank Deposit Print Reprint Administration Accounting Accounting Administration Accounting Processing GL Transactions General Ledger Enquiry Administration Users and Security User and Security Administration Accounting Processing Cancel Receipt lt lt lt lt lt lt lt lt l lt t lt La bi ba D Li bi bi id m La nm Iw minin Du inin iu lu Cancel Payment Refine by Description amp User armj A
76. e establishes all of the Open Items Ibais User Manual Reference 741852963 07040004 123456 07060002 07070002 07070002 07080003 07080003 07080003 Tran Date 06 12 2006 27 04 2007 27 04 2007 19 06 2007 01 07 2007 01 07 2007 02 08 2007 02 12 2007 02 08 2007 Paid Amount 200 00 1 210 99 1 000 00 16 066 60 1 100 00 0 00 417 51 110 00 417 51 5 28 Trusted sites BA Insurance Systems Chapter 5 Accounting Creditor Receipt Cancellations Selecting Creditors from the drop down brings up the following bbais form Select the Creditor and Search for the Receipt Number The search form will show all payments made by the Creditor Select the receipt to be cancelled Cancel Receipt Submit Creditor Receipt E Ibais Insurance Software Select Receipliofancel ce erri tree Creditor ROYAL Royal Sun Alliance Select Receipt to Cancel Tran Date Orig Amt Bankcode Currency 4UD AUSTRALIAN DOLLARS ESS 123890 10 08 07 1500 00 050 Receipt Number Receipt Date Company Branch BA Insurance Systems Voucher No Ref No Bank Account Creditor Receipt 4mount Discount Other Total Cancelled Transaction Date Reference Narrative Affect Bank Deposit Slip Page 1 of 1 Select Page es Go to Page Note the availability of the Affect Bank Deposit Slip tick box Ibais User Manual 5 29 BA Insurance Systems Chapter 5 Accounting
77. eceipt Type No Selection Antz Pantz NORTH SYDNEY Allocation 1 of 1 ANTZ Total Tendered 688 98 C Card Surcharge 6 82 Amount to Allocate 682 16 Original Outstanding Allocated Partial Amount Amount Amount Payment 08030006 Broking Antz Pantz Pty Ltd t as Antz 16 09 2008 682 16 682 16 06110014 Broking Antz Pantz 01 11 2008 133 87 133 87 08120012 Broking Antz Pantz Pty Ltd t as Antz 03 08 2008 174 48 174 48 Reference Source Insured Due Date Full Payment Ibais User Manual 5 10 BA Insurance Systems Chapter 5 Accounting Printing Receipts Printing of Receipts is controlled by a system flag lf the flag is set to Always Print or Ask then the following form will be displayed Simply click either the Print Preview Email checkbox and then the Submit button to complete the processing and print preview or email the Receipt Cash Receipts Bank Account en Blank Account Currency AUD Banking Location Type of Cash Receipt Client BE Client Code Client Name Amount to BEE Allocate Telephone ANTZ Antz Pantz Clothing Co 0 00 Business Terms Z DesignBais Tools Cash Receipt Submission Details Tender Type CASH Cash Receipt Submission Details Date 22 07 2006 amount 0 00 The transaction has been fully allocated Submit will update the account with the allocation details or Re Allocate will take you back and allow the allocation details to be changed Document Reference Source
78. ee KEE 5 69 ef tion le REPO a ee ee ect 5 72 LUS Mat BAIANCS REDON EE 5 74 Contre Total Balancing Tel SE 5 75 Brokerage Earned Summary Hepnort 5 76 Debtors Ageing RG e TE 5 77 Credilor REDON EE 5 78 Return Premium Reports ccccccsssceecssseeeccesscecceuseeeceeseeeeeeeecseaseeessgeeecsageeeesaeeeesegseesssaeeeseas 5 79 Unallocated Cash Listing EE 5 81 Brokerage Earned Reports ie 5 82 Brok r ge Taken Ee el dE 5 84 BANK STATEMENT RECONCILIATION eessen 5 85 Completing bank statement reconciliation ccccssseeeseeseeeeeeeeeeeeeeeeeeeeeaaaeeasseeeeeeeeeeeeeeeeeesenaaaaas 5 86 Re e ET ee EE 5 88 SS GING PR RER RTE RSR 5 89 EE eege D eee ane ee ns 5 89 Record Unprocessed ltem cccccccccessssseeeeeeeeeeeeeseeeeeeeeeeeeaaeeeeeeeeseeeaaseeeeeeeessaaaeeeeeeeeessaaaaees 5 90 EW AY BANK CONSOLIDATION AND RECONCILIATION nn ssssiiiiiiiiiiereenennnerissssseeeeeeeerns 5 91 Explanation and Methodology iii 5 91 PFU AY Yi 3 en 5 91 Part 1 Extraction of EWAY Settlements Ut 5 91 Part 2 Uploading Checking and Consolidating for Reconciliation 0 c eeeeeeeeeeees 5 94 CLIENT oA EME NG eege 5 97 Accessing Client Statements cccccccccceeeccececeeeeeeseeceeeeeeeaeeeeeeeeeeeessaeesaeceeesessuaaaeseeeeesessaaaaeees 5 97 POS 10y A smc E qeensesennessentepereeneenes 5 98 Ibais User Manual BA Insurance Systems Chapter 5 Accounting Chapter 5 Accounting Overview This document de
79. elect the items that appear on the Favourites report Available Forms and Reports Type ESS Category Select Category M Sub Category Select Sub Category Display All Type Category SubCategory Form Report Click to Run image Favorites Accoun ting P Cash Receipts Yes Claims Administration User an d Security Administration Client Claims Enquiry and Claims Processing Refine by Description On this form ET CA euL as a Favourite Ibais User Manual 5 2 BA Insurance Systems Chapter 5 Accounting Cash Receipting Cash Receipting is accessed from your Favourites Using this function you can Receive payments made from debtors Receive payments made from insurers and agents Receive sundry payments Receive payments in different tender types eg Cash Cheque Direct Deposit Receive payments in a foreign currency Receive payments from a group that offset many debtors Offset these payments to client or insurer agents or a general ledger account Offset cross currency amounts Allocate amounts against other amounts in a debtors account Print Receipts Vv Vv Y Y Y Y Y VW V V V Print Bank Deposit Slips Ibais User Manual 5 3 BA Insurance Systems Chapter 5 Accounting The first form presented in the Cash Receipt process follows Cash Receipts Bank Account oso Banking Location Type of Cash Receipt Debtor Receipt Blank Account Currency AUD Banking Location v Cli
80. enewals then it could also be because it is an unpaid renewal Important Note This report does NOT provide any indication of future GST VAT liability GL Database GST VAT Detail Report R80 This report like the R20 report provides detailed reporting but only includes items entered in the GL database Ibais User Manual 5 68 BA Insurance Systems Chapter 5 Accounting 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 L Favourites Task Management Insurance all 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 i al 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
81. ent E Client Code Amount to Contact Person Allocate Telephone Business Terms Executive Client Name Tender Type Date Amount Outstanding Amt Amount Actually Banked in Bank Currency Total Tendered Amount to Allocate The important aspects of this form are Bank Account Banking Location Type of Receipt Tender Type This is the bank to which the funds will be applied for any tenders processed For multi location offices this provides the ability to undertake receipting processes and produce bank deposit slips for a single location This identifies that the receipt is for debtors or creditors or is a sundry receipt This establishes the information and processing requirement for the deposit e g a cheque deposit requires additional information to cash foreign currency deposits require currency translation processing of the deposit Note The default Bank Account is automatically entered into the Bank Account field Ibais User Manual 5 4 BA Insurance Systems Chapter 5 Accounting To select an alternate Bank Account simply click on the hyperlink and a list of Banks is presented a DesignBais Tools Bank Selection Bank Selection GE Bank Name Account Name Ge 40 Blank Account Bank Office Account 0 AUD 050 Blank Account B A Insurance AUD Broking Acct 0 AUD 0504 Bank Account RMB Bank Account RMB 01 RMB 051 The Four Pillars BA Insurance USD Broking Account 0 USD Gener
82. erwriters and or sub agents brokers etc Accessing Payments Click on Accounting on the Home page or All Options on the top menu as shown below to display all available options Select Creditor Payments from the Accounting list Home Account Selection Change Password All Options Favourites Report Cabinets Logout Available Forms and Reports Category Select Category Sub Category Select Sub Category CT Maintenance Foreign Currency Exchange Rates be Insurer Creditor Maintenance No Inter Currency Exchange Rates Processing Bank Statement Reconciliation Brokerage and GST Transfers Cancel Receipt Cash Receipts Creditors Open Item and History Ledgers Debtors Open Item and History Ledgers GL Transactions General Ledger Enquiry Receipt Enquiry Cancel Payment Debtor Retund Payments Manual Creditor Payment Payments Enquiry Sundry Creditor Payments AP Creditor Master AP Creditor Trial Balance Refine by Description and the following will appear Ibais User Manual 5 31 BA Insurance Systems Chapter 5 Accounting Ensure Company Branch Currency and Bank Account from which payment is to be made is displayed correctly The screen now provides additional options as below Creditor Payments Save Status Far Company Branch E BA Insurance Systems Payment Run Number nd Currency AUD AUSTRALIAN DOLLARS From Bank Account 050 Bank Account Mame Bordereau Sort Sequence Include Debit Payments DO Fayment Ru
83. g Amt 110 00 0 00 0 00 715 00 0 00 495 00 Policy Number U W St Start ACEV ACEV End A 08 12 07 08 01 08 A 08 12 07 08 01 08 Memo No lt Type EndNo Reason Invoice 08040017 ni 08040017 1 Pol Policies 3 07001 New Business Existing C To Be Advised 07000 New Business Existing C To Be Advised Actions Select Enquiry Transaction Entry 0 00 0 00 0 00 0 00 0 00 0 00 0 00 100 00 0 00 10 00 110 00 Transaction Summary amp Memo No 08040017 Premium FSL Underwriter GST Stamp Duty Policy Fee Other Charges 07 04 08 Travel 0990 ACEV HILARYS Tran Date 0 00 0 00 0 00 0 00 0 00 100 00 0 00 100 00 0 00 10 00 Class Co Branch Insurer Premium Charges COM Commission 0 0000 ACE Insurance Limited Division Commission GST Witholding Tax FBC Due to Insurers Executive Ms Hilary Sun Alternate Exec Subagent Currency Coinsurance N Premium Charges Broker Gross Profit AUD Policy Number To Be Advised Brokers Fee Subagent Comm Broker Net Profit Subagent GST Client GST Rebate Amount Brokers Fee GST Business Insured Name Hilary Sun Client Payable The transaction is fully disclosed in the Creditors Statement Transact Date 03 12 07 20 11 07 03 12 07 09 11 07 06 02 08 06 02 08 15 11 07 09 11 07 1314 07 04 12 07 22 0407 15 11 07 03 12 07 03 12 07 03 12 07 04 12 07 17 0108 0612107 24 10 07 07 04 08 27 04 08 07 04 08 07
84. g a receipt which has already been entered which when checked is found to be post dated This flag when ticked will clear the receipt from the correct Banking Location Ibais User Manual 5 27 BA Insurance Systems Chapter 5 Accounting Complete the process by entering the Transaction Date Reference and Narrative The Submit button becomes available when you Tab from the Narrative field Ibais Insurance Software Cancel Receipt Microsoft Internet Explorer provided by BAIS ek w File Edit View Favorites Tools Help Q pack L EN ei Lei Search 5 Favorites ZE B d n 33 Address Si https designbais bais com au baweb b Gei Google Ces v Go oA OD EE i Bookmarks 7 Check 3 Translate ie Ve Autor a Sendtow Q Settings Home Account Selection Change Password All Options Favourites Logout Clear ETES Cancel Receipt Debtor Receipt v Debtor ABCOOL ABC Pty Ltd Company Branch BA Insurance Systems Currency 050 Receipt Date 10 08 2007 Receipt Number Bank Account Bank Account Name Debtor Receipt Amount 17 287 59 Discount Other 0 00 Total Cancelled 17 287 59 Transaction Date 10 08 2007 Reference 125689 Narrative Cheque Dishonoured Affect Bank Deposit Slip gO Voucher 43 1100 47 1109 1110 1111 1116 1117 1118 User arm Account B4 TRAINING Form ARTRANS_B10 The transaction reverses the receipt entry and r
85. hrs M Gr A i i 2 d 350 00 0 00 d 500 00 05100016 ht E Fudd i 4 4 113 75 0 00 d 163 75 fardvark Ente d 2 0 00 H 0 00 i 0 03 05100018 hr E Fudd d d x 290 00 d 34 80 355 20 05100008 ht H Dumpty J d d 120 00 0 00 d 120 00 05100017 ht H Dumpty d X d A 70 00 a 0 00 d 70 00 05100017 ht H Dumpty d x H 91 88 j 0 00 91 88 05100023 ht H Potter 4 d 1000 00 d 0 00 1 1500 00 05100024 ht H Potter d 1400 00 0 00 1800 00 05100024 Mr H Potter 4 d 1 2 611 78 d 0 00 d 822 74 05100024 ht H Potter d j 4 611 79 0 00 d 822 75 Ms R R Hood d d d d 0 00 d d 0 12 05100007 ht R R Hood i d d R 270 00 d d d 355 00 05100001 fardvark Ente d 4 j A 124 00 5 d d 124 00 ht R R Hood d x x 0 00 0 03 05100007 hts R R Hood i il i 290 00 1 1 375 00 13 10 05 13 1005 13 1005 13 1005 13 1005 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 5 83 BA Insurance Systems Chapter 5 Accounting Brokerage Taken Report This function allows you to run Brokerage Taken Report
86. iod Last Reconciliation Date 22 05 07 Current Statement Date 31 03 2010 201008 Last Statement Balance 35 280 470 11 Current Statement Balance 36 457 205 30 Calculated Statement Balance 35 280 820 08 Reconciliation Discrepancy 1 176 385 22 Clear Selection Include All Date Reference Description Deposit Withdrawal Include 20 03 2008 122 nelly 10 00 20 03 2008 IER nelly 107 91 24 03 2008 DEP asdf 20 00 24 03 2008 asdf 20 00 01 04 2008 lapse TISSUE 3 683 90 o 1 04 2008 i ALLIANZ AUSTRALIA INSURANCE LTD 133 89 01 04 2008 Allianz Australia Limited 280 50 01 04 2008 QBE Mercantile Mutual 800 66 01 04 2008 mea 426 51 01 04 2008 Vero Insurance 174 90 01 04 2008 cgu insurance 3 282 54 14 04 2008 TEST DRAWER 140408 14 04 2008 105 PS insurance 81 20 14 04 2008 01 tr brk 100 00 16 04 2008 919 Laag Pantz 50 000 00 29 04 2008 DEP aon 999999 133 89 o 30 04 2008 DEP AON 1234 57 14 Print Statement Record Unprocessed Item 53 779 44 53 429 47 A bank statement cannot be closed until the discrepancy is zero De selecting a transaction You can select Include All to select all transactions or Clear Selection to de select all transactions If you inadvertently select an incorrect item and want to de select it click on the tick lt lt will then change the transaction from selected 1002 2008 ARCMERE 1
87. lect Category v Sub Category Select Sub Category v Category Sub Category Form Report Click to Run Maintenance Client Maintenance Bank Details Foreign Currency Exchange Rates Maintenance General Creditor Maintenance Leieren Inter Currency Exchange Rates Bank Statement Reconciliation Brokerage and GST Transfers Cancel Receipt Cash Receipts eesti ard Tnetalmant Dnscemmemte Once Bank Statement Reconciliation has been selected you will see the screen below Home Account Selection Change Password All Options Favourites Report Cabinets Bank Statement Reconciliation Close Statement Account Currency Last Reconciled Statement Current Statement No Items GL Period Last Reconciliation Date Current Statement Date Last Statement Balance Current Statement Balance Calculated Statement Balance Reconciliation Discrepancy Deposit Ibais User Manual 5 85 BA Insurance Systems Chapter 5 Accounting Completing bank statement reconciliation Choose the bank account for the statement you need to reconcile Ibais Insurance Software Bank Statement Reconciliation Microsoft Internet Explorer File Edit View Favorites Tools Help Q sx z x ei Le ES Search Se Favorites La CH Ce fw LJ rel ki Address SI https designbais bais com au baweb Home Account Selection Change Password All Op
88. lid Tender Type and The Amount Actually Banked must be known The following example is as complex as a deposit can become The bank is US Dollars The client is in Australian Dollars The tender currency is Great British Pounds Simply enter the correct Bank Enter the Client Enter the Tender Type Enter the Amount to be Actually Banked in the US Bank account bais calculates all of the appropriate currency and cross currency rates and displays them in the transaction table Any currency variances are automatically accounted for Cash Receipts Bank Account The Four Pillars Currency USD Banking Location Type of Cash Receipt Client SE 3 Amount to Contact Person Danny Boyd BE client code Client Name Allocate Telephone 02 9999 0000 Hg anz 500 00 Business 02 3299 0032 Terms 90 Executive BLAH Outstanding Amt 26232 00 Tender Type CASHGBP British Pounds Cash Amount Actually Banked Date 22 07 2006 GBP Pounds Sterling in Bank Currency Amount 500 00 690 00 Description Currency Amount Rate Local Bank USD 890 00 0 6557 Client AUD 1 190 48 1 0000 Tendered GBP 500 00 0 4200 Local AUD 1 190 48 Antz Pantz Clothing Co NORTH SYDNEY Allocation 1 7 z z Total Tendered 1 190 48 Amount to Allocate 1 190 48 Document Reference Source Insured Class Due Date Original Outstanding Allocated Partial Full Payment Amount Amount Amount Payment 120010 06030009 Broking Ascott Sales TPP 15 04 2006 14 718 00 11 514 00
89. move column against the one to be removed This will change from an N to a Y If you remove a Debtor they will be excluded from the refund payment run completely You can continue to add Debtors by clicking on Include another Debtor to look up the debtor or simply type in the debtor code Debtor Refund Summary Accept Include another Debtor Debtor Trading Name Original Amt Outstanding Payment Amt Payee Name Cool Catz Airconditioning Pty Ltd 8 509 36 8 509 36 4 313 65 Cool Catz Airconditioning Pty Ltd Annabelle howe R 550 00 550 00 550 00 Annabelle howe Once all debtor refunds are processed click l List of Payments to Make This step produces a report showing the payments being made in this Debtor Refund Payment run Click on ESEESE which will produce the list You may use the preview mode or print a copy List of Payments Printing Options Preview Mode Printer Run Report Ticking the Preview Mode tick box allows you to view the report on screen Leave the printer set to Default to print or preview the report Ibais User Manual 5 46 BA Insurance Systems Chapter 5 Accounting Once you have run the report Close the screen to return to Debtor Refunds Steps If you are satisfied with the items reported you can skip the step and proceed directly to EEE Sere Ss Please Note If the Payment Run is incorrect you may go back and correct the refund or cancel the payment run By cancelling the payment
90. n Date Client Name F Policy Number Client Code Select from the drop down This option allows you to menu to sort by any of the Include Debit Payments if available options allowed in your database When the Payment Run Date is entered the following details are displayed Creditor Payments Save Status For Company Branch a BA Insurance Systems Payment Run Number News And Currency AUD AUSTRALIAN DOLLARS From Bank Account oso Bank Account Name Bordereau Sort Sequence Due Date aj Include Debit Payments Payment Run Date 8 07 2008 Action Step Status Date Time Payments Initiated 28 o7 2008 13 49 22 Automatic Hald Release Still to be Fun Still ta be Run e zi E to Make Still to be Run Each step is Date and Time stamped and Cancel Payment Run Still to be Run you can see the progress of the run ata Post Payments as Listed Still to be Run glance at any time Print Cheques Still to be Run Allocate Cheque Numbers Still to be Run Finalise Payment Run Still to be Run From this screen you can proceed with each step to complete the Payments as required or Save Status by clicking on the button at the top of the screen to return and complete the Payments at a later time To complete any of the steps showing as Still to be Run you click on the highlighted field for example MAutomatic Hold Release As each step is completed the Status column will reflect this Ibais User Manual 5 32 BA Insurance Systems
91. nder Type Date Amount Antz Pantz Clothing Co Document 120010 120011 120104 120105 2833 2834 2837 2838 2839 2840 2841 2844 2845 2846 kr L Po Br d Reference 06030009 06030010 06050025 06050026 CASH CASH CASH CASH CASH CASH CASH CASH CASH CASH CAC Blank Account Currency AUD SS Client Code ANTZ Client Name mount to Allocate 1 500 25 22 07 2006 ____1 500 25 Source Broking Broking Broking Broking Receipt Receipt Receipt Receipt Receipt Receipt Receipt Receipt Receipt Receipt D Full Allocation AUD Australian Dollars NORTH SYDNEY Insured Ascott Sales Ascott Sales Antz Pantz Clothing Co Antz Pantz Clothing Co Contact Person Telephone Business Terms Executive Outstanding Amt Danny Boyd 02 9999 000 02 3299 003 90 BLAH 28242 25 mount ctually Banked in Bank Currency Description Bank Client Tendered Local Due Date 15 04 2006 15 04 2006 03 06 2006 03 06 2006 13 07 2006 13 07 2006 13 07 2006 13 07 2006 13 07 2006 14 07 2006 14 07 2006 17 07 2006 17 07 2006 17 07 2006 17407 9n N Original Amount 14 718 00 14 718 00 1 686 25 2 000 00 100 00 100 00 100 00 100 00 100 00 100 00 100 00 100 00 100 00 100 00 Annan Currency AUD AUD AUD L n0 29 Amount 1 500 259 1 500 25 1 500 25 1 500 259 Allocation 1 of 1 ANT Total Tendered Amount t
92. nk Click Run Report A sample Return Premium Report is reproduced below Print amp Pagel of2 gt gt AR 75 BA TRAINING Pun Dak OI NOY 2007 Return Prem hum Report Sp For Credi ber Type UVY Underwater Creditors d De Canpay BA marance Syskms Currency AUD AUSTRALIAN DO LLARS B A I S PPSbkhe Amank Takentom Credir bul Nol Pad lo Cleri D Cieni Ho Cleni Name Creditor Code Creditor Mame Soler Execadve Name Policy Number twoke Ho Hel mont DOS CATE Cod Cat Arcomilionng Ply Li cou CGU haraxe Toby Tharee To Be Advised B2 3 33 SONOS CAUB NET Nel Paying Ab Agen ALLIANZ Alar Mar ace Sen Anirews CPOS ES 5569 35 Totl brRP She Amounts Taken tom Creditor but Not Pald Cilent 6262 68 BEREPO ATS RSD Reken Premium Report Ibais User Manual 5 80 BA Insurance Systems Chapter 5 Accounting BA TRAINING Pin Dak O1 NOV 23007 Pin Time 1258 Return Premiums Report Cie For Credi kor Type UVY Underwater Creditors ZS b Canpayw O BA naramce Syskmz t Currency AUD AUSTRALIAN DOLLARS B A ji S RPSloku Amani Pall lo Clenibis Nol Taken tom Credikor D Cher No Cleri Hame Credika Code Creditor Name Salers Evecudve Hame Policy Number twoke Wo Wel Amount DOG CMITH K hen Gah Tar Smh Echo ALLIANZ Alorc rois ace Tom Trairee a kdladtvatel N36 6084 1WOS08 KELLTRII Mda telly ALLIANZ Alarc rois ace Tom Trairee To Be Advised US J055 Tobl brRP Shu c Amoun te Fald b CilentbutMotTaken tom Creditor 1161 5
93. ny individual invoice Items with an H in this column are on hold and will NOT be released in this payment Part Payments Screen ke DesignBais Tools Hold Release Partial Details Part Payment Previous Voucher 119992 Transaction Date 24 02 2006 Original Amount 1 011 04 Outstanding Amount 1 011 04 Payment Amount 1 011 00 Amounts entered here will be written off to income and must be within your defined allowable write off limit Settlement Amount 04 Ibais User Manual 5 52 BA Insurance Systems Chapter 5 Accounting Once you have made any changes required in the Part Payment Screen click to return to the Hold Release Details Screen If you have completed all transactions in the Hold Release Details Screen press and you are returned to the Hold Release Summary screen A list of all the payment recipients is displayed you may continue paying additional Creditors by clicking on Include another Creditor You can remove any Creditors from the list by clicking on the Remove column against the Creditor This will change from a N to a Y If you remove any they will be excluded from the payment run completely Once you have completed selecting the Creditors Payments press to be returned to the Step List The screen is now updated with the date and time stamp of the steps you have completed List of Payments to Make This step produces a report sho
94. o Allocate Outstanding Amount 11 514 00 14 718 00 1 686 25 1 032 00 100 00 100 00 100 00 100 00 100 00 100 00 100 00 1 00 1 00 1 00 sinn A click in a Full Payment cell will allocate the full amount of that transaction Allocate Partial Payment 1 686 2 100 0 100 0 100 0 100 0 100 0 100 0 Rate Local 1 0000 1 0000 1 0000 1 500 25 414 00 Full Payment A Allocated Allocated Allocated Allocated Allocated Allocated Allocated Note Any item of any value can be selected in the allocation provided that the total amount allocated is equal to or less than the amount tendered plus the allowed write off limit Ibais User Manual 5 7 BA Insurance Systems Chapter 5 Accounting Partial Allocation A click in the Partial Allocation cell will pop up a form requesting the amount to be offset Cash Receipts Bank Account VI Blank Account Currency Banking Location Type of Cash Receipt silent Client Code Client Name Amount to Sone kenson Allocate Telephone BA antz f lathing 0 00 Business Terms Executive Outstanding Amt Tender Type CASH il Amount Actually Banked 0 00 n in Bank Currency Date 22 07 2006 Amount 0 00 Description Currency Amount Rate Local Allocation 1 of 1 ANTZ M DesignBais Tools Partial Allocation otal Tendered D mount to Allocate Partial Payment Amount Allocated Partial Amount Pa
95. ools Cash Receipt Submission Details Tender Type CASH d Cash Receipt Submission Details SR 22 07 2006 Unallocated Amount 1 500 25 Amount _____1 500 25 This amount may be left on account If the Unallocated Amount is less than the limit in System Parameters then the over or under payment may be written off Leave Unallocated Antz Pantz Clothing Co BE Unallocated Details Amount gt Not enough detail to allocate 1500 25 CE clear Auto aloes RR Document Reference Source Insured 120010 06030009 Broking Ascott Sales 120011 06030010 Broking Ascott Sales SC 120104 06050025 Broking Antz Pantz Clothi Description 120105 06050026 Broking Antz Pantz Clothi p N ayee Name i 2833 CASH Receipt Y Antz Pantz Clothing Co Receipt Details 2834 CASH Receipt Address i PO Box 1234 2837 CASH Receipt North Sydney NSW 2059 2838 CASH Receipt 2839 CASH Receipt 2840 CASH Receipt 2841 CASH Receipt D ead 2844 CASH Receipt EIERE BA Insurance Systems M 2845 CASH Receipt S e Re Allocate Submit 2846 CASH Receipt 2047 cacu Dacaine Print Preview CT Email Ibais User Manual 5 8 BA Insurance Systems Chapter 5 Accounting Auto Allocation In the following circumstances the system will provide you with the opportunity to automatically Fully Allocate the deposit 1 if the amount tendered equals the clients amount outstanding or if 2 the tendered amount exactly matches the aggreg
96. ous Banking Co Lotsa Cash Account 1 AUD HSBC IBA Trust Hong Kong Dollars 0 HKD B A Insurance Systems AUD Investmer O AUD Currency Select Page IL i Go to Page Bank Name pipe Click the shaded box to select the Bank Client codes may be entered or accessed via the hyperlink search in Client Code When a code is entered relevant data about the client is presented This includes Cash Receipts Bank Account Blank Account Currency AUD Banking Location i F Contact Type of Cash Receipt ebtor Rece information Client D Amount to Contact Person Danny Boyd SE client code pie heme Allocate Telephone 02 9999 0000 ANTZ Business 02 3299 0032 Terms 90 Executive BLAH Outstanding Amt 28242 25 Tender Type CASH j Cash Amount Actually Banked 1 3 in Bank Currency i The Amou nt Date 22 04 2006 AUD Australian Dollars mount N Description Currency Amount Rate Local Outstand i ng for the client Antz Pantz Clothing Co NORTH SYDNEY Total Tendered it Allo a Amount to Allocate Document Reference Insured Due Date Original Outstanding Allocated Partial Full Payment Amount Amount Amount Payment 120010 06030009 i Ascott Sales 15 04 2006 14 718 00 11 514 00 A 120011 06030010 i Ascott Sales 15 04 2006 14 718 00 14 718 00 F 120104 06050025 i Antz Pantz Clothing Co 03 06 2006 1 686 25 1 686 25 120105 06050026 i Antz Pantz Clothing Co 03 06 2006 2 000 00 1 032 00 2833 CASH i 13 07 2006 100 00 100 00 2
97. panies and currencies you can leave it blank Click Run Report when selection criteria has been input A sample Creditor Report is reproduced below Web Page Dialog Completed Page of 1 HW 4 DDI Search Search Next Actions REP 12291 actions BA TRAINING Run Date 08 NOV2007 Run Time 17 05 Creditor Summary Report For Creditor Type Uu and Fully Paid Y and Part Paid Y and Unpaid Y and Retum Premiums Y d Company 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 Sa um Se mg weess seg ere EEN apen Daag aaee Weeer 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 Uoyds of London 90 days 4963 00 29580 00 770 00 22747 10 0 00 0 00 58065 10 58065 10 NRMA NRMA Insurance Ltd coo 8630 71 0 00 0 00 0 00 0 00 0 00 8630 71 8630 71 WEE A OBE Mercantile Mutual 90 days 2356 81 0 00 128040 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 5GI0 SGIO 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 0 00 0 00
98. port bais e eneen A TRANG ERO RNG ACCOUNT OPENING BALANCE MONEY RECENED DE YEAR From or on beef d an bered or intending iara of on scoot os insurer From of on Gest of O am eer Of on BCE of an insured or inending sure From ie reset of presis seco bes AS See of define on resto of D st secures oer pec TOTAL MONIES R EVE fh CD H amp D MONEYS WTHORAAN DURING YEAR RESPECT OF GENERAL INSURANCE Fo Bayer oor it sotrraredcg Fecxitao irar ed AMOUNTS GUE TO NEUR ES Fo payment foe 30 days oles fon he Icon of he Bk or fom ih begining of ihe erte For payment cor on behal of ster fo Won es rresgmerttebes Fo prescribed secur ies For repayment of momies psc inte he scoot Gresia sm So days hom he date of ihe Od fhe risk of from he begining OT ite period to whch he hasier rebbie ini emor We coment in wring of Me eai connissoner Ams dus o insureds or intending inaa acs i ci TOTAL MONIES WW TEE ANN Amour s ben where de r ber Een BALAI EOF ACCOUNT AT END CF YEAR Dm pu sg broking scout EEN 1 APE Seeing Ge ed C One broker Pres bed somis Ach isis oes seo Ey Der Suspense i Levies S SRR SS TOTAL CARRIED FORWARD AT EMD OF PERIOD S TOTAL Mus agree fi bem ei ADP coche 95 Ibais User Manual 5 73 BA Insurance Systems Chapter 5 Accounting Trust Trial Balance Report This function allows you to run a Trust Trial Balance Report The report gives a more detailed analysis of the
99. port Downloaded from EWAY http 192 168 199 105 2upk upload_62628rad4FE94 xml Upload a File Micros Pick a file to upload Check Criteria EWAY Settlement File P Report Designer a Active Users Glossary Maintenance P Migration Tools a Help Definition CA Entities Choose File to Upload Look in E Desktop X GD winzip 3 pE D Google Chrom P Lockdown Mode a Exclusive Locks a Development Checklist CA End of Period a Audit Display a eXpress A my Documents A d My Computer My Recent Documents HH 123scan exe igh Acrobat com my Network Places MES adobe Reader 9 Desktop F Fiezila Client Google Earth D mozilla Firefox A Oper My Documents BR Animation Shop 3 3 SA QuickTime Player ED SAMSUNG Dr Printer sBclient My Computer ES di My Network Places Files of type 140 847 DSiluz par M Adobe Photoshop 7 0 Bd Axialis IconWorkshop at Calculator E Cisco VPN Starter cisco VPN Starter bat ERY Command Prompt Corel PHOTO PAINT X4 txt a CorelDRAW x4 HDA a DesignBais baweb DesignBais Ref v513 pdf 38 Microsoft Offi Microsoft Offin HD Outlook E Radmin Viewe fm Remote Deskt ZS Shortcut to EI SC Shortcut to EI fl Shortcut to PI TI SYMBOL SCAN TimeBals B lrrumzz ZC Universe Onlir ER Windows Expl ia WordPad 3 User wilp Account BA DEY Form BKPARAMS_P997 Ibais User Manual
100. pts Input the client code that has paid direct to the UW and the amount they paid Banking Location Type of Cash Receipt Debtor FT Arment to Contact Person Danny Boyd BE peng code Debtor Name All Mate Telephone 02 9999 0000 EE antz 6 750 54 Business 02 3299 0032 Terms 90 Executive Outstanding Amt 38798 82 cas Cash 6 750 54 Date 02 06 2007 AUD Australian Dollars Amount 6 750 54 Description Currency Amount Rate Local Narration Paid Direct 25 May 2007 Bank AUD 6 750 54 1 0000 Client AUD 6 750 54 1 0000 Tendered AUD 6 750 54 1 0000 Local AUD 6 750 54 Input a reason for this entry in the Narration field Allocation 1 of 1 ANTZ Total Tendered 6 750 54 Amount to Allocate 0 00 Original Outstanding Allocated Full Document Reference Source Insured Due Date pee DOE GE Renee 120533 06080048 Broking Antz Pantz Clothing Co 28 11 2006 121254 07030026 Broking Antz Pantz Clothing Co 12 06 2007 Click on the Full Payment column 121448 07040066 Broking Antz Pantz Clothing Co 12 07 2007 7 S A 121449 07040067 Broking Antz Pantz Clothing Co 12 07 2007 alongside the invoice they have paid 121450 07040068 Broking Antz Pantz Clothing Co 12 07 2007 121451 07040069 Broking Antz Pantz Clothing Co 12 07 2007 121452 07040070 Broking Antz Pantz Clothing Co 12 07 2007 d Q7O040066E Broking Antz Dan othing Co S T mn EES 75 665 TO 121545 07040067 Broking Antz Pantz Clothing Co INSACC 23 07 2007 6 750 54
101. que Payment No Payment Date 99998 10 08 07 16414 43 Royal Sun Alliance Bank Account Payment Amount Settle ment Discount Total Cancelled Transaction Date 10 08 2007 Reference Narrative Page 1 of 1 Select Page Go to Page Ibais User Manual 5 59 BA Insurance Systems Chapter 5 Accounting Complete the process by entering the Transaction Date Reference and Narrative The Submit button becomes available when you Tab from the Narrative field Ibais Insurance Software Cancel Payment Microsoft Internet Explorer provided by BAIS ME File Edit View Favorites Tools Help ay Q ak M Q x x a H pO search Se Favorites fi B d n z 33 Address amp https designbais bais com aujbaweb oi Go Google CC Y Go og EE B Bookmarksy P Check v Z Translate Autolink AutoFill e Sendtow Settings Home Account Selection Change Password All Options Favourites Logout Cancel Payment cancel Payment for Creditors Creditor ROYAL Royal Sun Alliance Company Branch 0 BA Insurance Systems Currency AUD AUSTRALIAN DOLLARS Cheque Payment No 99998 Payment Date 10 08 2007 Bank Account 050 Bank Account Name Payment mount 16 414 43 0 00 Total Cancelled 16 414 43 Transaction Date 10 08 2007 Reference Test Narrative Cheque Lost Voucher Reference Tran Date Paid Amount 18 05100007 09 10 2004 1 299 38
102. rent 30 60 and 90 days it also included all monies in unallocated cash 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 FC al Debtors include or she at LE Executive All Executives exclude outstanding Alternate Executive All Alternate Executives funded amounts leave Division RH 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 or 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
103. rrency Exchange Rates Processing Ei I Bank Statement Reconemaron Brokerage and GST Transfers Cancel Receipt Cash Receipts Credit Card Instalment Payments Geesen eae ne mou med DEFT Receipts Input Debtors Open Item and History Ledgers Deferred Direct debit Update The screen below is displayed DesignBais Editor DesignBais Help Change Password Account Selection Run a Form Logout Favorites Receipt BPAY File pe Submit Issuing Bank NAB e Download File No File Available Select Report There is no file available until it is uploaded Click on the Hpioad Eie button to upload the file you received from your bank Click to browse to the location of your BPay Browse _ file and then click Submit The completed screen should look similar to this one Ibais User Manual 5 13 BA Insurance Systems Chapter 5 Accounting httpsd Mesignbais bais com au baweb uploadExec asp upk upload 5 5 Som e Upload a File Microsoft Internet Explorer provided by BAIS Pty Ltd Pick a file to upload File has been uploaded successfully Upload duration 00 00 00 C Users ands Desktop 10102001 BRF ees A message box advises when the upload N has completed Click to close the Cl message screen Receipt BPAY File Issuing Bank Select Report When the file is selected from the Download File menu click Submit to begin the BPay receipt process Loe
104. run all preparation work will be deleted Post Payments as Listed This step posts the payments to accounts A dialogue box will confirm that you want to Proceed Click Yes VBScript 7 J Are vou sure vou wish to Proceed with Posting of these Debtor Refunds Yes Mo Please Note You cannot cancel the payment run once the step has been completed Debtor Refunds Save Status JM Enquiry BA Insurance Systems AUSTRALIAN DOLLARS Bank Account Name Action Step Status Date Time Payments Initiated 07 08 2008 13 08 17 Refund Preparation Completed 07 08 2008 13 23 39 List of Payments to Make Completed 07 08 2008 13 24 22 Cancel Payment Run Not Applicable Post Payments as Listed D 07 08 2008 13 28 32 Print Cheques Still to be Run Allocate Cheque Numbers S New options become available when the payment run is posted Ibais User Manual 5 47 BA Insurance Systems Chapter 5 Accounting Print Cheques This feature will create a print job for those using pre printed laser cheques If you hand write your cheques there is no need to run this step If you do not currently use laser cheques but would like to please contact Support for more information about our cheque stationery layout before proceeding Allocate Cheque Numbers Click on the highlighted field GESTION This option allows you allocate the cheque numbers to the payments made Payment Number Allocation Bank Account O50 Bank Account
105. s
106. s The report shows in detail all fees commission sub agent e commission and GST taken in a selected period or transaction date range Brokerage Taken Report Financial Y We SES m If you nominate a From and Financial Month To Date range leave the Trans Date from 01 10 07 Financial Year and Month Trans Date to 61 10 07 blank Company No Company Branch Selected Currency No Currency Selected Printing Options Summary Only Preview Mode Printer DEFAULT Run Report WI 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 hs been 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 Curre PFund f Subagent S fg GST UW Gst Claims Gst Variance Tot Amt Taken Agree A 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 1093 90 0 00 0 00 0 00 0 00 20 00 2 0
107. section 27 report Trust Trial Balance Report Lisa All Companies Currency All Currencies Input 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 Click Run Report A sample Trust Trial Balance Report is reproduced here BA TRAINING Trust Tria Balance Report For all companies and all currencies bois AUD ALSTRALIAN DOLLARS Account Name BANK 050 BRCOMM BROOMM GST BRFEE BRFEE GST BRUVWGST CAS HUMALL OC RETPREMLW ST FEC ST FSLNSW 5T SDNSW ST ATCR SLE SUE ABC LV ALLIANZ LW GLOBAL UW LLOYDS LW OBEMM UW ROY AL UW 3G10 UW ZURICH Ibais User Manual Trust Bank Account number 050 Brokers Commission GST on Brokers Commission Brokers Fes GST on Brokers Fee GST retinei Er overseas underwriters Unallocated Cash Feturn Premums Underwriters Ch 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 Lies of London OBE Mercantile Mutual Royal Sun Alliance 9610 Insurance Suncorp Zunch Australian Insurance Total br Company O and Currency AUD 5 74 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
108. t J Company Branch Currency Transaction Currency No Currency Selected zi Sub Account Amount To Be coa Description Co Br Allocate Number Description Narrative Tender Type Date Amount a User armj Account B4 DE Form ARTRANS_A10 Trusted sites Ibais User Manual 5 22 BA Insurance Systems Chapter 5 Accounting bais will present the form shown below Enter the details of the General Ledger account that the monies are to be receipted against Then complete the details of the cheque DesignBais Tools Cash Receipts Microsoft Internet Explorer provided by BAIS File Edit View Favorites Tools Q sxx z EN a Le JO search Se Favorites O 2 d s x 33 Help Address Si https dezonbaz bais com aufbawebj le Gr i v Go G Bookmarks 8 Check 21 Translate AutoLink E AutoFill a Sendtor 4 GS 7a AJ EI P Account Selection Change Password All Options Favourites Cash Receipts int 040 Blank Account Currency AUD Bank ACCOUNT Banking Location Type of Cash Receipt BEES B Insurance Systems Pty Ltd Currency AUD ompany Branch Transaction Currency Sub Account 4UD BE co Number 640 Rent Received 0 Narrative Monthly Rent of Office Description o Br Description lian Dollar Amount to Allocate 1 500 00 Amount Actually Banked in Bank Currency Cheque AUD Australian Dollars
109. t View Favorites Tools Help Q Back Q F EN E Le P Search Se Favorites C2 e z 33 Address amp https designbais bais com au baweb a Go Google G Go oA E BF Bookmarksy check 9 Translate iis Y AutoFill Sendtow Settings n Ch Available Forms and Reports Type Select Type v Category Select Category v Sub Category Select Sub Category v Sr EE E E Broking Processing Client Enquiry and Policy Processing Yes Task Management General Letters Broking Reports Earned Amounts Life Non Life Processing Client Claims Enquiry and Claims Processing Accounting Reports Bank Deposit Print Reprint Administration Accounting Accounting Administration Accounting Processing GL Transactions General Ledger Enquiry Administration Users and Security User and Security Administration Accounting Processing Cancel Receipt Cancel Payment N 1 nm Ia lu lun v Refine by Description amp User armj Account B4 TRAINING Form DBIUSERS_D50 Ibais User Manual 5 25 BA Insurance Systems Chapter 5 Accounting The dropdown provides access to the cancellation of receipts from clients or creditors Ibais Insurance Software Cancel Receipt Microsoft Internet Explorer provided by BAIS CHE File Edit View Favorites Tools Help Q peck gt r EN a Le PO search Se Favorites amp B E z 33 Address a https designbais bais com aujbaweb a E
110. tails the functionality of bais Accounting processing The first section relates to Accounts Receivable and deals with your company s clients monies owed by them and monies owed to them Ibais has been designed to make these processes simple and intuitive PLEASE NOTE some functions outlined in this Manual are specifically related to Brokers and Agents or alternatively Insurance Companies The functions have been left in the Manual for completeness All functions may not be available in your system Ibais User Manual 5 1 BA Insurance Systems Chapter 5 Accounting How to Access Accounting Functions The system is driven through the lbais Home Page The page has a number of topic panels with links to the panel s relevant functions The Accounting Panel provides access to all Accounting functions The bbais Security System only enables access to panels and functions that you are allowed Favourites There is alsoa icon which lets you incorporate your most used functions in one place Favourites allow you to group together your most used functions into an easily accessible icon There are two modes in this form Display Favourites and Display All The Display All Favourites button in Display All mode shows all of the functions that the user is allowed to access Clicking on the Yes No field enables or disables the function as a Favourite Type Category and Sub Category dropdowns allow you to s
111. te 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 De Sort Sequence Client Name Next Sort Sequence Client Name Selected Clients DE Selected Clients Be WOOD Geppetto and Pinoccio Wood Client Name Include Allocated Items B Do Not Print If All Items Dated After This will allow you to preview or print the statements Web Page Dialog Statement of Account Printing Options Preview Mode Printer DEFAULT S Run Report bais User Manual 5 99 BA Insurance Systems Chapter 5 Accounting The completed statement will look like the following 2s STATEMENT OF ACCOUNT ter amp For he Monti ot OCTOBER 207 gel Bo va B A I S Gbnt Geppett and Ano oob Vb od PRES Fage 1 ot 1 Fage i o i BA marae Syskms 317 Padt Hwy Monti OCTOBER wor WORTH SYDNEY NOW 2060 Cbn t Wooo Teephore For In malon comerring Nis accounl pkare contact Tammy Taree Qur Retrenoe OCTOBER 1005 Geppe bo ar Fock Yiood OCTOBER 1005 Geppe bo ar Fock Yiood OCTOBER 1005 Geppe b and Phob Wood OCTOBER 31 1007 Allam ounte are In Pea pay all ouk larg Invoices urgently AUST RALIAN DOLLARS Geppetto and Pinoccio Wood 12 Jones Road HG AEASERE U PM Sydney THIS ADWCEWTH YOUR CHEQUE Ibais User Manual 5 100 BA Insurance System
112. tems Chapter 5 Accounting 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 Home _ Account Selection Change Password Available Forms and Reports Category Select Category Sub Category Select Sub Category Favorites Type Category Sub Category Form Report Click to Run Image Favorites No Accounting Maintenance Insurer Creditor Maintainance Processing Cancel Payment No Cancel Receipt No Cash Receipts Yes Creditors Open Item and History Ledgers No Debtors Open Item and History Ledgers No GL Transactions No General Ledger Enquiry No Payments ves Reports AP Creditor Trial Balance No AP 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 d 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
113. then default in the relevant data as shown Default Company lo All Company Branches AUD Company Comoany Branc D Currency Australian Dollars From Trust Bank 050 B 4 Insurance AUD Broking Acct To General Bank KE Leave as defaults if you have more than one in use insert the number you are transferring from Insert General Bank Voucher Account Code which is usually 040 Enter Cheque No or gt transfer receipt ID Available Amounts Amounts to Transfer Brokers Fee 0 00 0 00 Commission 224 67 224 67 These amounts default in from the Available Rebate 0 00 0 00 Baguette Currency Variance 0 00 0 00 You can submit with these default amounts to Nett Brokerage 224 67 224 67 withdraw all available Earnings or draw less Fee GST 0 00 o 0 00 by altering the amounts S where required Commission GST 22 47 22 47 Uw Retained GST 0 00 0 00 Claims GST 0 00 0 00 Nett GST 22 47 22 47 Once all the data has been input Click Submit and you will be advised to confirm the transfer amounts as shown below Please confirm the Following transfers 224 67 of Brokerage FROM trust bank 050 TO general bank 040 and 22 47 of GST FROM trust bank 050 TO general bank 040 Cheque voucher 12345 ce Click and the transfer is complete or _ Gand if you wish to return to the Brokerage and GST Transfers screen Ibais User Manual 5 63 BA Insurance Systems Chapter 5 Accounting
114. ting Administration Broking Broking Administration mi mt CE Refine by Description Click on Receipt Reprint and the following screen will appear Receipt Reprint Receipt Number fso Date 12 11 07 Description ti Payee Name Geppetto and Pinoccio Wood O oy Address 12 Jones Road Enter Receipt Number Or Look up Fields will populate once Receipt Number Is entered These fields can be altered H Test Drive Header Set Document Header Click the Print Preview Email checkbox and then the Submit button to complete the processing and print preview or email the receipt reprint Ibais User Manual 5 12 BA Insurance Systems Chapter 5 Accounting BPay Receipt Inputs When a BPay receipt file is received from the bank you can upload this file into bais and the system will automatically offset the items paid First you will need to save the file you received to a location on your computer where you can easily locate it again From the All Options menu select BPay Receipt Input Available Forms and Reports TYPE Select Type Category Select Category v Sub Category Select Sub Category Favorites Type Category Sub Category Form Report Click to Run Accounting Maintenance ii _ Client Maintenance Bank Details Foreign Currency Exchange Rates GL Maintenance General Creditor Maintenance _ Insurer Creditor Maintenance es Inter Cu
115. tions Favourites Report Cabinets Logout Bank Statement Reconciliation Stateme Suspend Select E Currency Last Reconciled g40 Blank Account Current Statement No Items se GL Period Last Reconciliat 042 Blank Account Ge L _ Current Statement Date 050 Name of Bank ioe g Last Statement 080 NAB Current Statement Balance Calculated Statement Balance Reconciliation Discrepancy Reference Description Deposit Withdrawal Include SI 0 User baweb Account B4 TRAINING Form SCBANKS_D10 B Trusted sites Once the bank account has been selected it will show the following screen against that bank account since the last statement has been reconciled gt a PROG Se WAS E i Chang O lr Cabinets Logout KS Bank Statement Reconciliation Close Statement Account G50 Name of Bank v BA Insurance Systems Currency AUD Last Reconciled Statement 9 Current Statement 110 sel GL Period Last Reconciliation Date 06 03 08 Current Statement Date 15 04 2008 200412 Last Statement Balance 120 641 02 Current Statement Balance Calculated Statement Balance 120 441 02 Reconciliation Discrepancy 120 441 02 Clear Selection Include All Date Reference Description Deposit Withdrawal Include 01 05 2006 12569 Global Underwriting Services 1 014 29 x 07 09 2007 7090702 Global Underwriting Services 2 788 06 13 12 2007 10 WITHHOLDING TAX CREDITOR 7 578 69 12 02 2008 8287342 CGU Insurance 1 765 72 18 02
116. ual 5 90 BA Insurance Systems Chapter 5 Accounting EWAY Bank Consolidation and Reconciliation Explanation and Methodology Preliminary The following document describes the procedure which enables the simplification of outstanding bank reconciliation details by consolidating transactions processed through the EWAY payment gateway The process applies only where the EWAY payment gateway is used to collect credit card payments As EWAY makes a single deposit to the bank account for each day Settlement Date and lbais retains these credit card payments as individual transactions it can be a lengthy process to reconcile the bank deposit with these transactions This consolidation and reconciliation process has been introduced to assist with this process In general terms the process will match the transactions from bais with their counterpart in the EWAY system utilising the EWAY generated reference number All matched transactions are then consolidated into a single total for the nominated settlement date with any discrepancies being displayed on the screen The consolidated balance can then be matched to the Bank Statement with allowances for any listed discrepancies The following document comprises 2 parts Part 1 relates to the selection and extraction of EWAY settlements using the facilities within the EWAY Business Centre web site and Part 2 describes the uploading and processing of these using the new facility within bais
117. vised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised To Be Advised Date of Issue Account No ACEV Page 16 DDD 0 0 U U oo U U DD DOO Oo oo v BA Insurance Systems 07 APR 2008 440 00cr 825 00cr 440 00cr 1 884 30cr 240 63cr 577 50cr 0 00 1 884 20cr 4 702 50cr 601 Bier 10 459 00cr 2 887 62cr 825 00cr 12t 00db Chapter 5 Accounting Sundry Cash Receipt This function enables the entry of cash receipts for amounts that do not relate to invoices e g rent received tax refunds As they are sundry in nature they must be banked against the general bank account the monies cannot be banked against a Trust Bank account To enter a Sundry Cash Receipt select Cash Receipts from your Favourites and then select Sundry Cash Receipt from the drop down list a DesignBais Tools Cash Receipts Microsoft Internet Explorer provided by BAIS ECH File Edit View Favorites Tools Help Q pack EN E A P Search Se Favorites amp e 33 Address a https designbais bais com aujbaweb Go Google IGi M 60 O LB Bookmarksy Check Translate Autolink E AutoFill a Sendtow Settings e _Account Sel _Chang All Of Fav Cash Receipts Bank Account 040 Blank Account Currency AUD Banking Location Select Type of Cash Receipt Sundry Receip
118. wing the Payments being made in this Payment run Click on R which will produce the list You may use the preview mode or print a copy Printing Options Preview Mode Pore Ca den Run Report Ticking the Preview Mode tick box allows you to view the report on screen Leave the printer set to Default to print or preview the report Once you have run the report Close the screen to return to Creditor Payments Steps If you are satisfied with the items reported you can skip the step and proceed directly to ESSE SESS Ss Please Note If the Payment Run is incorrect you may go back and correct the Payment or cancel the Payment Run By cancelling the Payment Run all preparation work will be deleted Ibais User Manual 5 53 BA Insurance Systems Chapter 5 Accounting Post Payments as Listed This step posts the payments to accounts A dialogue box will confirm that you want to Proceed Click Yes VBScript DesignBAIS j Are you sure you wish to Proceed with Posting of these Creditor Payments Please Note You cannot cancel the payment run once the step has been completed Manual Creditor Payment TE BA Insurance Systems AUSTRALIAN DOLLARS Bank Account Name Action Step Status Date Time Payments Initiated 07 08 2008 11 22 25 Manual Hold Release Completed 07 08 2008 11 36 31 List of Payments to Make Completed 07 08 2008 11 38 24 Cancel Payment Run Not Applicable Post Payments as Listed
119. yment 120104 06050025 i Document 120105 1 686 25 Allocated Document Reference SG 5 120105 06050026 i Due Date 03 06 2006 o Partial o o o o Full Payment 2833 CASH Original Amount 2 000 00 100 00 Allocated Outstanding Amount 1 032 00 100 00 Allocated 2837 CASH 100 00 Allocated 2838 CASH 100 00 Allocated 2839 CASH o 100 00 Allocated 2840 CASH Receipt 14 07 2006 5 100 00 Allocated 2841 CASH Receipt 14 07 2006 100 00 Allocated 2844 CASH Receipt 17 07 2006 1 1 00 Allocated 2845 CASH Receipt 17 07 2006 1 00 Allocated 2846 CASH Receipt 17 07 2006 1 00 Allocated 2847 CASH Receipt 17 07 2006 e 1 00 Allocated 2848 CASH Receipt 17 07 2006 4 1 00 Allocated PTE 2834 CASH Payment Amount 7v Note Any item of any value can be selected in the Partial Allocation provided that the total amount allocated is equal to or less than the amount tendered plus the allowed write off limit Leaving an Amount Unallocated If a deposit cannot be allocated then it is possible to leave it unallocated Simply Submit the transaction and a pop up form will be displayed requesting the reason s for the Unallocated Amount Cash Receipts Bank Account ep Blank Account Currency AUD Banking Location Type of Cash Receipt Debtc Client BE S S mount to Contact Person Danny Boyd Client Code Client Name Allocate Telephone 02 9999 0000 ANTZ ntz j 1 500 25 Business 02 3299 0032 Terms 4 DesignBais T

Chapter 5 - Accounting

Contents

Download Pdf Manuals

Related Search

Related Contents