Jacques Van Den Berg

Experience

• 

  Ellerine Holdings

  Aug 2002 - Aug 2008

  * Responsible for all Treasury functions of the company (Ellerines & ‘Relyant’).* Compiling journal for all interest due on various loans held with several banks e.g. Overnight call accounts, Overnight Call deposits, Back to Back Loans and Deposits, Pref share investments etc.* Reconciling the cash flow on a daily basis and insuring that loan repayments and other electronic payments occur.* Managing bank transfers and printing of bank statements for the following banks: FNB - South Africa, Swaziland & Botswana; STANDARD BANK – South Africa, Namibia, Swaziland & Lesotho; NEDBANK – South Africa & Lesotho; ABSA – South Africa; STANDARD CHARTERED BANK – Botswana.* Maintaining a forecast schedule pertaining to all deposits and payments to be made to various banking entities and other creditors e.g. First Auto, Payroll Payments etc.* Given the fact that my previous position has not been filled, I do various duties from my previous position. Show less Relyant Retail Ltd (a Division of Ellerine Holdings)* Printing cheques and exporting Electronic Funds Transfers* Opening and maintaining Supplier Master list on the in-store system* Capturing non-cash receipts and refunds on the in-store system (UCS)* All Group interface recons (Debtors, Stock etc.)* Assist in all processes of Fixed Assets: Acquisitions, Disposals, Transfers, and Depreciation & Asset Roll Forwards.* Maintenance of Provision for extended warranty spreadsheet (15% of Sales & 25% of Cost of Sales)* Balancing Creditors, Cashbook & General Ledger* Summarising Bad Debts Write off reports by Brand, every quarter. Currently on a monthly basis* Provision for Doubtful Debts (by Statutory company) Recon* Compiling Daily Cash Flow Forecasts from the brands for management* Payments and acquisitions of Interest Bearing Debt (Loans from Ellerines) & posting the interest paid on borrowings to the ledger. (Treasury purposes)* Assist with compiling and posting Forecasted & Actual figures for Service Divisions* Compiling and posting of Flash figures for CLUB into CPM* Assist with all month-end procedures (Closing and rolling of systems e.g. Cashbook & rolling of month end) in regards to our two databases – RSA & Botswana* Assist with compiling our foreign currency spreadsheet and running our foreign currency conversion (Botswana to RSA database)* Compiling Master Trial Balances on a monthly basis for Group Financial Executive* Daily Cash Sales Figures* Trade Creditors Audit Trails & Group Rebates Recon* Stock Ageing Reports By Statutory company* Update (maintaining) Payroll masterfile containing all the payroll codes for the interface into the General Ledger* Update the chart of accounts on the intranet* Open and maintain GL charts in AccountAbility* Outstanding cheques on Cashbook/Statement* Compiling actual expenses for current financial year to complete budgets for following financial year. Show less Early Bird Services (a Division of Ellerine Holdings)* Responsible for bank account reconciliations (allocate & reconcile all entries)* Liaising with all departments on entries relating to bank statements* Assist in downloading of bank statements and compiling daily cash flow forecasts* Month-end journal entries to General Ledger* Assist in compiling the SARS tax returns* Compile detailed journal of all maintenance (contract) payments, to be manually entered by our Maintenance Debtors department* Authorising bank returns for Receipts Cashbook* Assist in branches with Stock count at year end* All queries regarding direct deposits or payments made from any of the bank accounts* Reconcile various General Ledger accounts at month-end (including Debtors)* Back-ups and rolling periods for the following systems: Receipts Cashbook, Debtors, Creditors, Payments Cashbook, Stock etc.* Use Trial Balance & Movement to assist in compiling monthly and Year-end Financial Reports* Report forecasted and actual ledger balances to Relyant Retail (Holding company) using Trial Balances & Movements* Assist with half-year and year-end audits* On-site IT assistance (all queries – hardware and software related) i.e. Install printers on machines, install Microsoft Packages e.g. MS Office etc, Moving and connecting of desktops, setting up TCP/IP settings for internet browsing & Network access, queries on Microsoft Excel formulas etc. Show less

  • Accountant / Treasury Accountant

    Feb 2007 - Aug 2008

  • General Ledger Clerk

    Sept 2004 - Feb 2007

  • Accounts Clerk

    Aug 2002 - Sept 2004
• 

  Cashbuild

  Nov 2008 - Dec 2014

  * Implementation & Training of Qlikview reporting tool, including mapping all data sources to Qlikview databases.* Development & Maintenance of all Qlikview models.* Ad-hoc business information: Supply accurate reports, on a timeous way, according to internal audit regulations.* Management Reports: Design, compile, update, analyze, distribute and maintain all daily, weekly and monthly management reports for Directors.* Sales Budgets: Create new process to compile budgets per store using Excel to upload into Qlikview. Accurately compile reports containing all budgets for all stores. New store budgets compiled with a comparative store.* Daily Reporting Figures: Complete accurately on a daily basis, including dashboards.* Bonus Provision & Actuals: Compile spreadsheet for provisions and actual bonus payouts on a monthly and quarterly basis, supplied to salaries department.* StatsSA Figures: Supply StatsSA with all relevant sales information as required on a monthly basis.* Board Pack Graphs and Information: Supply all required information to compile Board Pack for Management and Shareholders.* Any other ADHOC reporting regarding Inventory, Sales or Financial reporting.* Special Project: SAP BW Readiness* Calculate quarterly purchase and sales inflation based on weighted average per store per division.* Calculate and supply data required for bonuses for Cashbuild’s “Hall Of Fame”.* Supply Directors with cement sales figures by store and region. Show less * Cashbooks: Reconcile cashbook to relevant bank statement account and print and fax bank statements to stores weekly.* Cash / credit card clearing: Reconcile and balance cash/credit card clearings, identify and resolve unreconciled differences, ensure no items outstanding longer than 30 days, analyse and capture petty cash ensuring correct allocation of VAT.* Feasibility studies: Manage, prepare and review feasibility studies and present to Directors for approval.* Reporting: Monthly and quarterly reports to be distributed to Directors and relevant parties, without errors or omissions, executive P&L summary to be sent to all Divisional Managers ensuring accuracy and value add, board packs to be completed accurately and timeously, prepare and present Divisional Meeting reports as required by Directors, any other adhoc Reports required.* General ledger analysis and reconciliations: Reconciliation File to be completed accurately and timeously, Full Trial Balance analysis to be performed.* Annual Budget: Annual budgets to be completed timeously and accurately, present annual budget to Directors for approval Show less

  • Business Analyst

    Aug 2009 - Dec 2014

  • Finacial Accountant

    Nov 2008 - Aug 2009
• 

  Inteleqt Consulting

  Jan 2015 - Sept 2016

  BI Analyst (QlikView Developer)

  Design, Develop and implement Qlikview solutions to customers. Currently situated at SAB Miller.

• 

  Insight Consulting

  Sept 2016 - Aug 2017

  BI Consultant (QlikView Developer)
• 

  PBT Group

  Aug 2017 - now

  Data Visualisation Engineer (QlikView Developer)