Susan Osthuizen

Download bank to excel – VLOOKUP from Master data for account numbers Import bank from Excel to Business Central Reconciliation and allocations of payments per customer remittance advice

Credit controller - NDE Stainless Steel

(2022-02)

• Download bank to excel – VLOOKUP from Master data for account numbers
• Import bank from Excel to Business Central
• Reconciliation and allocations of payments per customer remittance advice
• Ensuring all queries are attended to & up to date
• Compiling and preparing all credit card transactions for system imports
• Monthly reconciliations of all debtors & general ledger accounts
• Account corrections and Journal entries
• Calculating & processing settlement discounts & ad hoc journals
• Detailed reporting on all credit notes and reasons why via Pivot tables
• Invoicing and issuing customer statements
• Keeping an accurate record of account transactions & all supporting paperwork saved as pdf on the server
• Verification, opening and capturing of new accounts in line with company policy & CGIC
• Weekly reporting on overdue debtors and credit limits, liaising with the sales department
• Weekly review of debtors age analysis & keeping track of credit balances/refunds
• Stock adjustments via Item journals
• Stock take capturing
• Maintaining good relationships with customers and colleagues

Credit controller - TiAuto Investments (Pty) Ltd

(2021-02 - 2022-02)

• Age analysis – 350 customers with a book value of R 16 million
• Receipts of daily bank statement/Bank reconciliation
• Ensure all limits are in place & in line with CGIC - Credit Limit increases & decreases
• Maintain & update all contact details/Credit Applications & Master data on the system
• Opening new accounts
• Preparation of all account receivable journals
• Ensure customers pay within agreed time
• Monitoring age analysis daily and Query resolution in a timely manner

Credit controller & Creditors - Megarom Interactive (Pty) Ltd

(2014-09 - 2020-07)

Full Credit Control function

• Debt collections, telephonically & face to face
• Daily Bank statement - Receipts and deposits
• Identifying unallocated deposits
• Bank balance and bank reconciliation
• Allocations per remittance advises
• Weekly follow up on unpaid invoices
• Informing sales reps of credit balances on accounts
• Reconciliation of each account on excel and following up on outstanding invoices and queries
• Sending out pod's and following up with warehouse regarding claims e.g., short supplies and general customer queries - V lookup and Pivot table
• COD purchases, 15-day accounts, 30-day, 45 days' & 60-day accounts
• Monthly statements, invoices, pods, uploading statements on portals, various layouts per customer requirements etc
• Processing of discounts/rebates/advertising/marketing/price protection claims and journals
• Sales reports and keeping track of price protection/mark down deals not yet deducted off customer remittance
• Insurance claims, from beginning to end
• Missing stock
• Stock damaged in warehouse
• Weekly download and various interim offers to FNB
• Balancing debtor's book from previous closing age analysis to current age analysis balance
• Listing of invoicing done for the week
• Listing of credits done for the week (including reasons for credits)
• Listing of journals done for the week
• Listing of payments received for the week
• Credit applications, credit limits, trade references, creating new accounts. Review of credit applications on a yearly basis and keeping all customers details updated on the system
• Providing accurate monthly cash flow forecasts in respect of the debtor's book
• Processing credit notes, per GRN from warehouse and customer claims
• Processing General ledger journals
• Typing and issuing letters of demand to bad payers
• Negotiating payment plans
• Releasing orders
• Month end reporting

Credit controller - Evolution Cycling (Pty) Ltd

(2013-06 - 2014-08)

Job Description

• Debt collections telephonically & face to face
• Daily Bank statement – receipts, identifying unallocated payments
• Reconciling each debtor account
• Keeping track of consignment stock
• Sending out monthly statements
• Uploading chain store statements on customer portal e.g., Shoprite
• Managing credit applications – obtaining approval from Credit Guarantee CGIC, comparing credit limit request to purchase history & opening new accounts
• Managing COD purchases
• Monthly cash flow forecast
• General customer assistance, sending out invoices/Pod, resolving account queries, etc
• Managing petty cash & reconciling to month end cash up
• Running daily sales reports via BIC on pastel
• Assisting with costing sheets and processing GRV's for imports
• Processing of discounts, rebates & advertising allowance (reviewing sales figures against Massmart claims)
• Weekly download – reconciling debtor's books
• Balancing debtor's book from previous closing age analysis to current age analysis balance
• Listing of invoicing done for the week (store breakdowns)
• Listing of credits done for the week (including reasons for credit)
• Listing of discounts passed & correct % passed
• Listing of journals & reasons for journal
• Listing of payments received
• Checking and authorizing credits
• Managing the returns cage at the warehouse – ensuring all returns are in a resalable condition, passing credits for returns & insuring cage is clean
• Investigating chain store claims, and short payments on remittance advises - Passing GL credits for stock items not accounted for after stock take
• Investigating price differences & passing relevant credits for incorrect prices
• Running of monthly sales figures from BIS on pastel
• Sending out the breakdown of sales – each chain store & independent dealers. (V lookup to identify stock items, brands & codes)
• Running of sales figures per rep & working out commissions based on % earned per stock item
• Issuing a dispatch report of orders gone to different stores
• Typing and issuing letters of demand to bad payers
• Negotiating payment plans
• Preparing legal documents for hand over/liquidation (acknowledgment of debt, credit applications, surety ship, pods & debtors' recons)

Credit Controller - Canon Business center South Africa (Pty) Ltd

(2011-11 - 2013-05)

Job description

• Debt collections telephonically and face to face
• Cash, EFT & Cheque receipts
• Loading of debit orders for head office and 2x franchises
• Debtor's allocations
• Invoicing/Credit notes/pro forma
• Debtor's reconciliations
• Debtor's journals
• Monthly cash flow forecast
• Managing staff purchases
• Arcon (reconciliation of incorrect receipts, journals, credit notes, invoices and other entries to debtors book)
• Running of monthly statements
• Debtors aging reports exported to excel
• Handling and maintaining of all franchise and debtors accounts
• Customer refunds
• Tracing of unallocated deposits/receipts
• Processing credit applications, ITC checks and customer aprovals in line with credit limit

Credit Controller & PA to MD and HR - Upper Edge Products (Pty) Ltd

(2008-08 - 2011-10)

Job description

• Debt collections, telephonically & face to face
• Debtor's reconciliations
• Account allocations
• Customer discounts allowed/disallowed
• Controlling purchases – customers over credit limit
• Debtors journals
• Monthly/weekly debtor's reports for 2x branches and head office
• Legal hand overs, following up with attorneys & compiling a monthly schedule with progress feedback
• ITC Checks, customer references, tracing of customers
• Debtors statements
• Invoicing and credit notes
• Sales reports exported to excel
• Costing sheets (imports)
• Import agents clearing instructions
• Screening of MD calls
• Scheduling flights, accommodation, and vehicle hire
• Drafting of all company doc's (memo's, HR, Price lists & general company letters)
• Special pricing & quotes to customers, compiling all doc's, price lists and samples for new presentations
• Preparations of recommended opening stock orders for new customer stores
• Handling and maintaining all stock barcodes
• Payments for easy pay accounts (Telkom, W&L, fines etc)
• Staff overtime preparations
• Company vehicle registration & Licence discs, petrol cards, insurance claims & monitoring vehicles via Skytrax
• Phone upgrades & new contracts
• General Admin & assistance to customers, reps and sales team
• Typing and issuing letters of demand to bad payers
• Negotiating payment plans
• Preparing legal documents for hand over/liquidation (acknowledgment of debt, credit applications, surety ship, pods & debtors' recons)

Creditors - Essilor SA

(2006-11 - 2008-07)

Job description

• Reconciliations of creditors accounts to their statements
• Preparations for payments
• Processing creditors invoices
• Processing credit notes
• Matching delivery notes to order numbers & invoicing
• Sending out remittance advises
• Keeping reconciling items to a minimal
• Purchasing of dispatch, logistics, warehouse and general office stationary
• Creditor queries

Sales Consultant - Pro Active home loan solutions

(2004-01 - 2006-10)

Job description

• Debt consolidation
• Bond origination
• Telesales
• Policies
• Vehicle finance

Matric - The Woods Wateridge (2003)