Accounting Analyst - Inventory

Job Summary

The Inventory Controller Assistant assesses the completeness, correctness, and accuracy of all approved inventory documents prior to setup and upload, ensuring precise handling of alterations, price adjustments, promo analyses, and financing assignments. They thoroughly verify inventory unit modifications and house construction requests to ensure flawless implementation. Additionally, the Inventory Controller delivers critical support and expertise to the Project Group, driving seamless operations and optimal inventory management.

Duties and Responsibilities

New Project Uploading and Alteration - Evaluate inventory requests, documentation, and system setups in FREBAS in accordance with company policies, ensuring the submission and approval of all relevant documents as per established standards. 

• Review, validate, and verify all submitted documents against the Pricing Template, ensuring that the resulting TLP meets or exceeds the approved financials before submission to the CFO for approval.
• Review and validate the FREBAS setup, ensuring that all submitted documents are accurate and approved before uploading the new project and any project alterations into the system.
• Provide the other charges template to PG if applicable and verify the accuracy of the codes and amounts before uploading them into FREBAS.
• Review and analyze the approved promo before creating and assigning financing scheme and reservation fee.
• Email the Project Group In-Charge to request a review of the computation for the generated price list.
• Endorse the price list to the CIDC Head/Inventory Manager for publication once it has been confirmed by the Project In-Charge.
• Email the findings and any necessary documents to proceed with the request and attach them to the Sapphire ticket.  
• Email all relevant departments once the uploading process is complete.

Price Increase Review and Uploading – Ensure that tranche price increases are implemented regularly and that the implemented increases do not exceed the established threshold.

• Review the generated inventory units and confirm that the pricing template in use is the updated version. Ensure that the new base price is based on the approved pricing plan.
• Initiate the tranche increase if the number of units sold or schedule is met to ensure that the price is aligns with competitive market prices.
• Secure CIDC Head or CFO approval if there is a request for price deferment.
• Review and validate the additional cost with necessary gross profit (GP) margins to be added to the house model that will be part of the Total List Price for projects without threshold. Secure approval from CIDC Head or CFO especially if the request amount is without the GP.
• Review and validate the additional cost with necessary gross profit (GP) margins to be added to the Total Contract Price for projects with threshold. Secure approval from CIDC Head or CFO especially if the request amount is without the GP.
• Provide the other charges template to PG if applicable and verify the accuracy of the codes and amounts before uploading them into FREBAS.
• Ensure that the price increase set up in FREBAS is accurate and PG is notified to give them enough time to cascade to Seller.
• Endorse all recommended price increase review to Inventory Lead before submitting to CIDC Head/CFO approval. 

Promo Set Up and Extension – Evaluate and analyze the approved promo to ensure the correct financing scheme and reservation fee are accurately applied.

• Verify whether the requested scheme already exists before creating a new financing scheme.
• Endorse the selected financing scheme and promo code for Inventory Lead review before setting up in FREBAS.
• Set up the correct promo code to the projects with approved promo and enroll the corresponding inventory units. Ensure the correct financing scheme and reservation fee are assigned and generate the price list.
• Ensure that promos are correctly extended to qualified projects, buildings, or phases.
• Email the Project Group In-Charge to request a review of the computation for the generated price list.
• Endorse the price list to the CIDC Head/Inventory Manager for publication once it has been confirmed by the Project In-Charge.
• Email all relevant departments once the promo set up/ extension is completed. 

Inventory Unit Modification Update – Evaluate and analyze the requested inventory units for update of status, product type, product sub-type, physical conditions, and business owners in FREBAS.

• Review and analyze the approved inventory unit update requests for modifications in FREBAS.
• Properly input enclosure remarks in the Sapphire ticket for returns to the requester and endorse the qualified units for modification to the Inventory Manager/CIDC Head before implementing changes in FREBAS.
• Email the findings and any necessary documents to proceed with the request and attach them to the Sapphire ticket.
• Send reminder emails to all requestors on the return tickets and initiate cancellation for tickets that have been inactive for more than one month.
• Endorse the processed ticket to the Inventory Lead for evaluation before closing the ticket.
• Review and validate requested Advance Selling of the inventories, ensuring the correct Total List Price and any applicable additional cost is included. Obtain approval from the Inventory Manager or CIDC Head, email the approval to the requestor and attach it to the Sapphire ticket.
• Regularly review the inventory statuses, fin scheme mode concept and physical conditions then send a reminder to Project Group to facilitate inventory updates through creating sapphire ticket to concern department. 

Job Order Request – Prepare a JO request to CTI for the Inventory Unit Information requests, as migration or partial implementation of the system enhancement cannot be completed through the front end.

• Analyze the request to determine if CTI assistance is needed to facilitate the updating of inventory unit information.
• Prepare a Sapphire ticket to CTI and attach all necessary documents to support the request.
• Review and evaluate the request once the JO to CTI is completed. 

Facility Enhancement Testing – Facilitate the testing of the system enhancement in the FREBAS simulation by covering various scenarios to prevent errors during system implementation.

• Facilitate testing in accordance with the approved concept paper, ensuring that it covers various test data and scenarios before the deployment of new or enhanced facilities.
• Submit the test results to your Immediate Head for review and endorsement to the CIDC Head. 

Additional Responsibilities– This includes minimal requests, but each is an important process that requires thorough evaluation, accuracy, and validation.

·       Prepare the METADATA thoroughly, scan it, and sent it to Corporate Admin. Ensure the completeness of the scanned METADATA before returning it to the Project Group.

·       Prepare the daily productivity report accurately and record it to the MIS for validation by the Immediate Head.

·       Review the appraised value of the house and lot whenever there is a new request to update the amount, as required for Government finance contracts.

·       Provide Metadata document request to the requestor.

May need to assist another team within the department during peak work periods if necessary.

Technical Competencies and Skills

• Person with integrity. • Intermediate knowledge on MS Office applications (MS Excel, Word and Powerpoint) • High analytical and problem-solving skills, both on numerical and logical situations. • Good written and oral communication skills

Education, Trainings and Licenses Required

• Bachelor’s Degree on Accounting and Business related courses, MS Excel Training