Accounting analystSan Miguel Corporation

Job Description
Name of Project: Financial Services - Accounting Analyst
Project Details:
Timely and accurate processing of the following:
Accounts Receivable
Collections
RFCMs (Request for Credit Memos)
Cash in Bank and General Ledger
Accounts Payable
Payments to suppliers
Payments to employees
Timely and accurate processing/preparation of the following reports required by the client:
Collection Variance Report
Collection Deviation Report
Aging Report
Status of Floaters
Bank Reconciliation
Exception Report
Responding to queries from suppliers and employees of the client concerning accounts payable.
Responding to queries from Client's (Sales, Logistics, Finance) employees concerning accounts receivable
Performing general administrative and other tasks that maybe assigned from time to time
Tasks, Duties & Responsibilities:
ACCOUNTS PAYABLE
1. INVOICE /DOCUMENT RECEIVING
Ensures completeness and validity of invoices/documents received from the clients by:
Checking completeness of invoices/documents received by referring to the transmittal slip forwarded by the client.
Conducting basic review/audit of invoices/documents as follows:
Checks validity of invoices/documents (original copy/certified true copy, BIR registered for supplier's invoice.
Checks presence of signature of approvers on the invoice/document for non-PO transactions.
Checking presence of required entries on the face of the invoice/document as follows:
GL account and cost center
Internal Order number for CAPEX/promo
Profit center, if required
Assignment for certain GL accounts, if required
GR reference number for PO based transactions
Perform verification of quantity and price and ensures accurate matching of GRIR in SAP for PO based transactions
2. INVOICE /DOCUMENT VALIDATION
Conduct basic validation/audit on invoices/documents (applicable only to transaction requiring only basic/simple validation) as follows:
Check completeness of the required documents by referring to the matrix of required document per transactions type
Checks validity and authenticity of the approver's signature s by referring to the list of authorized approvers per cost center provided by the clients
Checks mathematical accuracy of the supporting documents and computations.
Checks countersignature on alteration of amount of invoice/documents, if any
Checks appropriateness of GL account charging indicated in the invoice/document.
Conduct additional required validation (in addition to the basic validation/audit) for transactions that are more complex in nature (e.g., per diem, FTH, Advertising and Promotions, CAPEX, foreign travel, payment of air fare, etc.)
Checks compliance to existing company guidelines by referring to the matrix of rates and company guidelines provided by the client.
For payments covered by contract, reviews contracts and checks accuracy of amount to be paid by referring to contract details.
Ensures that the additional required documents indicated on the contract are submitted by the supplier/client.
3. INVOICE /DOCUMENT ENCODING
Encodes accounting entries in SAP and ensures accuracy of the following:
vendor's code and name
ATM account number for employees
amount to be paid
gl account and cost center
reference
text and header text
VAT code and VAT details
withholding tax code and base
assignment
internal order or profit center (if applicable)
posting date
baseline date (date of receipt of invoice by the client)
document date (date of document/invoice)
Prints PRM/SAP accounting document.
Updates database monitoring of received invoices/documents indicating SAP documentnumber.
4. PAYMENT PROCESSING
Ensures completeness of posted invoices/documents received for payment processing.
Reviews posted invoices/documents by:
Checking if invoice/document are original
Checking accuracy of vendor name and vendor code
Checking if invoice/document are approved
Matching of ATM per document vs. SAP document (for employees)
Checking if SAP PRM/document are approved by the AP Team Lead
Ensures timely and accurate payment to payees/suppliers regardless of payment mode (e.g., manual check, direct credit to employees accounts, check writer)
5. REPORTING
Preparation of aging reports:
Collection Variance Report - Daily (for each collection)
Collection Deviation Report - Weekly
Monthly Status of Sales Related Floaters
Other reports as required by the Client
Preparation of Bank Reconciliation
Analysis and clearing of Cash GL line items by matching bank statement and SAP balances.
Preparation of unrecorded deposits
Identification of bank reconciling items as follows:
Unrecorded Deposits
Unrecorded Withdrawals
Erroneous Posting
Deposits in Transit and etc.
Preparation of Exception Reports:
Incomplete attachments submitted by Third Party Collectors
Erroneous collections ( e.g. collections intended for Poultry)
Wrong payee name, post-dated checks, mismatched figures and wordings
Devuelto without confirmation
Returned RFCMs by BU
Booked bad orders without confirmation
Promo deductions with short or no Budget
6. PERFORM OTHER TASKS THAT MAY BE ASSIGNED FORM TIME TO TIME
ACCOUNTS RECEIVABLE
1. POSTING OF COLLECTIONS AND ANALYSIS
Receiving and retrieving of documents from SMIS customer's portal, third party collectors and Account Specialists.
Checking of completeness of attachments.
Preparation of upload collection file template.
Posting of collections in SAP.
Clearing of bad orders, devueltos and cancelled invoices.
2. POSTING OF REQUEST FOR CREDIT MEMOS (RFCMs)
Receiving and retrieving of supporting documents (debit memo/service receipt, Promo Activitity Workplan (PAW)/Trade Letter/E-mail confirmation) from SMIS Sales, Finance and Marketing.
Matching of floaters with the Internal Orders created.
Preparation of RFCMs.
Posting of RFCMs in SAP.
3. POSTING OF CASH IN BANK AND GENERAL LEDGER
Receiving and validation of checks from the bank
Checking of completeness and validity of the checks deposited in the night depository.
Downloading of Bank Statements.
Posting of cash deposits in SAP.
4. Perform other tasks that may be assigned from time to time.