CPH+Bookkeeping+AP+AR+Reporting+Process


 * Purchase Process**
 * Set up new inventory or non-inventory items
 * Setup new supplies
 * Create Purchase Order by entering Purchase Order from purchase, with all information of date, currency, exchange rate department, location, item code, quantities, price and ETA
 * Email purchase order to vendors and purchase order enters the receiving queue
 * Send inventory picking slip to the warehouse
 * Enter prepayment with bill credit for the overseas purchase
 * Receive and roll inventories into the stock, whilst receiving the delivery document from the operations
 * Allocate freight cost to inventories
 * o Receive items into various locations with the landed cost allocation method in two ways (by quantity and by value)
 * o Receive items into landed warehouse location, import the freight cost allocation and transfer the items from landed warehouse to the location of CPH Group
 * Bill the purchase orders after receiving the suppliers’ invoices
 * Make payment, follow up prepayment and the remaining payment
 * Scan all the quotes, receipts and invoices to Netsuite
 * Credit Card**
 * Review all the bills has been paid by credit card
 * Allocate credit card expenses which has been paid by credit card and has not been entered into Netsuite to the expense accounts monthly
 * Reconcile credit card statement
 * Pay company credit card by writing Cheques with Netsuite
 * Upload the credit card statement and the expense allocation excel to the Netsuite

**Month-end Process** Generally the following tasks should be done for the month-end close off. Reconcile Bank, Credit Card accounts, and Funds transfer with the bank statement monthly and quarterly: v Monthly reconciliation: v Quarterly reconciliation:
 * Ensure that financial statements produced on a timely and accurate basis, within working days of the end of the report month; financial reporting is responsible for managing the month-end closing process.
 * Check all the transactions posting period to ensure the current month’s transactions are posted to the General Ledge before lock or close the AP, AR and GL transactions with Netsuite
 * Complete all good receipts of the reporting month end
 * Review and post all entries(GL) of the reporting month end
 * Cut off invoices (purchase and sales) processing, customer billing and customer credits, in the Netsuite System for the last day of the month before lodging the TAX
 * Close accounts payable each month before the tax lodgement, by closing posting all monthly entries to the general ledger system, and checking the approval status and payment term
 * Accrued expense month end adjustment journal entries—  adjust the accrued expense with Journal entries after confirm the expense date and the posting period, this assure that the accurate expenses is counted within the reporting period.
 * Reverse accrual for accrued expense (if any), and amortise prepaid insurance to insurance expense account
 * Maintained Fixed Asset register (Depreciation, if any) and review loan repayment for the high purchased cars
 * Allocate fuel expense (UBT products—including Caltex, Shell and BP fuel expense) to the proper fuel expense accounts
 * Perform month-end AR and AP-to-general-ledger reconciliation procedures, document and resolve discrepancies before closing the accounts of the reporting month
 * Account reconciliations
 * Ø CPH Cheque Account
 * Ø CPH old Cheque Account
 * Ø Web Transactions Account
 * Ø Allocate cost to Credit Card Account and reconcile Credit Card expenses
 * Ø Compare all the balances of the bank account reconciliation reports and the Inventory valuation report with the Balance sheet as of the end of the month
 * Ø ING Direct Account
 * Ø Tax Account (ANZ Online Saving Account)
 * Ø ANZ Mortgage Loan Statement
 * Ø ANZ Business Loan Statement
 * Ø USD Holding Account (If there are any transactions)
 * Prepare the following month-end reports:
 * o Prepare BAS/TAX report
 * Ø Prepare BAS report work papers
 * Ø <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Review and maintain the wrong tax code of the current month’s transactions
 * Ø <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Review Payroll report (Gross payment and deductions after TAX) from ADP Pay Line, and allocate the PAYG withholding to the PAYG cost account for the current month
 * Ø <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Separate the cost of overhead wages and the operation warehouse wages from the gross salary’s payment
 * Ø <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Generate BAS report
 * Ø <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Generate GST on purchase detail report
 * Ø <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Generate GST on sales detail report
 * o <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Prepare all the reports and paper works quarterly requested by UBT Accountant Pty Ltd
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Lock or close the accounts and accounting period after the year end or month end (21st of each month) TAX lodgement
 * Review all the opening bills
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Perform variance analysis
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Prepare ad hoc findings with Netsuite and Excel ( e.g. freight and inventory cost allocation)
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Verify BI(Business Intelligence) Extraction and reports(GL) for the ad hoc requests
 * o Purchase Order ETA
 * o Prepayments and purchase orders following up
 * o Debtors Days, and <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Accounts receivable aging by customer
 * o Inventory Valuations by product categories
 * o Item code and descriptions
 * o Convert data format with EXCEL for the ad hoc requests
 * o Custom sales report and other CRM report for the ad hoc requests
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Document the procedures done to close off the processes or accounts at the end of the fiscal period, including the cut-off procedures
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Document "unknown" amounts to investigate
 * Will <span style="font-family: Verdana,sans-serif; font-size: 9pt;">analyse and prepare the report of budget-versus-actual financial results
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Assist in internal and external auditing(financial reports and inventory adjustment)
 * <span style="font-family: Verdana,sans-serif;">List of Month End Management Reporting **


 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Accounts Receivable Detail Aging Report
 * o <span style="font-family: Verdana,sans-serif; font-size: 9pt;">BAS report
 * o <span style="font-family: Verdana,sans-serif; font-size: 9pt;">GST on Purchase detail report
 * o <span style="font-family: Verdana,sans-serif; font-size: 9pt;">GST on Sales detail report
 * o <span style="font-family: Verdana,sans-serif; font-size: 9pt;">PAYG and Payroll report
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Accounts Payable Detailed Aging Report
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Inventory reports including Inventory Valuation and Inventory turnover report
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Profit & Loss report
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Balance Sheet report
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">BAS / TAX report (monthly and Quarterly)
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Sales report, prepayment and payment forecast
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Variance report between actual cash flow result
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Opening bills and prepayment
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Create stock on hand quantities list for checking the physical stock and the stock hand in the system
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Debtors days report weekly
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Monthly financial snapshot report
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Financial ratio analysis with both Netsuite and Excel :
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Gross Profit Margin
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Net Profit Margin
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Debtor days
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Creditor days
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Inventory days
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Working capital days
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Return on Investment (ROI)
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Current Ratio
 * <span style="font-family: Verdana,sans-serif; font-size: 9pt;">Quick Ratio

//__ Ecommerce at CPH Group __// I updated the news and promotion letters sending status with the ERP system, calculated the customer’s credit which was awarded based on their purchases, and created the customers rewards report with the ERP and Excel. <span style="color: #444444; font-family: Verdana,sans-serif; font-size: 10pt;">Monitor, track and report on all email and marketing campaigns in a bid to keep the management abreast of activities. Created customer meeting and call reports with the ERP to the sales manager in order for assisting marketing campaign. Updated the customers and products information and imported high volume data into ERP.

Job description @AR AP Admin