r
rafidshidqi

Rafid Shidqi

@rafidshidqi

Excel and Google Sheets Business Automation Specialist

Indonesia
About me
Hi, I'm Rafid, a Finance & Inventory Automation Specialist. I help F&B, hospitality, manufacturing, and small businesses automate finance, inventory, costing, reporting, and dashboards using Excel, Google Sheets, Power Query, VBA, SQL, and Python. I build practical, customized systems that reduce manual work, improve accuracy, and provide better business insights. From financial dashboards and inventory systems to F&B costing and custom business solutions, I turn complex processes into simple, efficient workflows. ... Read more

Skills

r
rafidshidqi
Rafid Shidqi
Offline • 

See my services

Automations
I will build an automated restaurant inventory and costing system

Work experience

JALA_BERIKAT NUSANTARA PERKASA, PT

Staff Accounting

JALA BERIKAT NUSANTARA PERKASA, PT • Full-time

Dec 2024 - Present • 1 yr 10 mos

• Prepare periodic financial statements, including balance sheets and profit & loss reports, to ensure accurate financial information for management. • Perform daily bank reconciliations and ensure all transactions are accurately recorded in the accounting system. • Manage the company’s tax reporting process, including PB1, PB2, VAT, withholding tax slips, and annual/monthly tax returns in compliance with applicable regulations. • Handle finance and accounting functions for the company’s F&B subsidiary, including cost control, cash flow monitoring, and purchasing process support. • Conduct monthly stock opname and variance analysis to minimize potential losses and improve inventory accuracy. • Prepare accounts receivable, accounts payable, and monthly sales reports to support budgeting, operational evaluation, and management decision-making. • Support financial operational control by ensuring transaction documents, payments, and accounting records are properly maintained and well documented.

T_Cargo

Staff Finance & Accounting

T Cargo • Full-time

Dec 2023 - Oct 2024 • 10 mos

• Managed company cash flow, including monitoring all incoming and outgoing operational transactions. • Prepared daily, weekly, and monthly financial and operational reports for management monitoring purposes. • Recorded general journal entries systematically and ensured all financial transactions were properly documented. • Prepared profit and loss reports accurately and on time as part of the company’s financial reporting process. • Handled tax administration and reporting, including withholding tax slips and unified income tax reporting. • Supported the company’s financial control process through transaction monitoring, supporting documentation, and periodic reporting.

Sido_Agung Group

Inventory Control & Branch Operations Supervisor

Sido Agung Group • Full-time

Jan 2019 - Aug 2023 • 4 yrs 7 mos

• Supervised inventory management and branch administrative operations across 5 branches to ensure stock availability, data accuracy, and smooth operational processes. • Conducted monthly stock opname, inventory variance analysis, and follow-up corrective actions to minimize stock discrepancies and improve inventory accuracy. • Prepared planning and budgeting for new branch openings, including operational cost estimates, initial stock requirements, and supporting expenses. • Controlled branch operational costs and monitored budget realization to ensure alignment with the company’s financial plans. • Prepared daily, weekly, monthly, and annual reports to support branch performance monitoring and management evaluation. • Managed petty cash for 5 branches and ensured operational fund usage was properly recorded, controlled, and accountable. • Developed administrative and reporting templates to improve data entry efficiency, stock monitoring, and reporting accuracy. • Maintained organized operational documents and records to support internal audit requirements and management review.