My client, a retail entity, has a vacancy for an experienced Bookkeeper withhigh profficiency in Pastel and Excel. Creditors Printing out Drop shipment, warehouse and Coca Cola statements from the Sigma server. Collating payment amounts due to Spar Head Office on Excel and submitting worksheet to management. Capture invoices in purchases journal per GRV batch, balance journal total back to each batch's daily transaction summary. File direct creditor' and drop shipment creditor' invoices in the “To Pay” files. Weekly basis: Match invoices to drop shipment statements and file. Match claims to credit notes on drop shipment statements, process and file. Record drop shipment amounts owed per statement, print and file. Process DC warehouse invoices and credit notes (with matched claims) and file. Reconcile amounts owed per statements back to detailed ledger in Pastel. Query in variances with Spar. Monthly basis: Match direct suppliers' invoices to their statements, record amounts owed on Excel and submit for payment (7 day terms or 27 day terms) to management. File all paperwork returned. Debtors Gathering cash-up batches per day, per company. Printing supporting documentation – consolidated cash-up reports, end of day sales and instant money statements. Populating Excel spreadsheet with data from these sources of information in order to: Verify cash-up per cashier against their stated ‘overs/unders' interrogating any variations detected with management expected income as per offline credit cards processed, instant money, lotto tickets, blue label tickets purchased against source documents. expected income as per tender types – cash, credit cards, Cellbux, Intellimali, accounts capturing End of Day sales per department. Preparing spreadsheets that will facilitate month-end journal processing Bank Print bank statements for each day Update the cash deposits banked with an Excel worksheet showing the breakdown of cash for services provided versus actual store sales Balance the credit card deposits into the bank back to the expected credit card deposits as per each cash-up worksheet per day. Balance the instant money deposits and withdrawals into and out of the bank back to the Instant Money schedule that has been updated and reconciled with the cash-up worksheet per day. Verify the Intellimali and Cellbux deposits into the bank from each service providers' web-based dashboards and the cash-up worksheet per day. Verify the amount debited from the bank statement for services provided i.e. tickets and airtime are as per the expected amounts as indicated on the cash-up worksheets per day. Send estimated draws off the bank account to management each day. Updating of cashflow reports daily General Ledger Post purchases made to the store on account in the Debtors journal. Post end of day sales to the Sales journal. Post creditor's invoices to the Purchases journal. Post general journals at month-end to expense in-house accounts to relevant departments. Post salary journal each month. Process inter-company invoices and post appropriate journals to allocate amounts owed accordingly. VAT Print out required reports per company Reconcile VAT output back to VAT on Sales as per cash-up worksheets per month. Update VAT Excel worksheet to include Input and Output amounts as per VAT report. Add adjusted amounts required as per the VAT control account general ledger. Submit VAT report for processing and payment. Minimum of Matric with vast experience - ideally a tertirary qualification would be ideal Previous experience gained in a retail, FMCG environment would be beneficial Offering R20 000pm negoatiable
Apply Now