Excel Akuntansi sederhana
Budget: $5,000 – $10,000 USD
I need help turning my raw accounting data into a clean, automated Laporan Laba Rugi in Excel. The focus is strictly on the profit-and-loss statement; balance-sheet or cash-flow work is not required right now, though I may add them later once this first piece is solid.
I already have a house template that I’m comfortable with. Your job is to map the transactions I’ll supply (CSV or XLS format) into that file, build or fix the formulas so totals flow correctly, and leave the sheet formatted for easy monthly updates. If you see ways to streamline the layout—pivot tables, dynamic ranges, or Power Query—I’m open to improvements as long as the look of the final report stays close to my template.
Deliverables
• Completed Excel workbook with my data loaded and an accurate Laporan Laba Rugi
• All formulas unlocked and documented in a short note sheet
• Quick walkthrough (video or screenshots) showing how to refresh the report with new data
I prefer someone comfortable working in Indonesian and familiar with standard Indonesian chart-of-accounts codes, but solid accounting skills in any language plus strong Excel (VLOOKUP/XLOOKUP, SUMIFS, Pivot, Power Query) are what matter most. If you can turn this around quickly and keep everything tidy, let’s get started.
I already have a house template that I’m comfortable with. Your job is to map the transactions I’ll supply (CSV or XLS format) into that file, build or fix the formulas so totals flow correctly, and leave the sheet formatted for easy monthly updates. If you see ways to streamline the layout—pivot tables, dynamic ranges, or Power Query—I’m open to improvements as long as the look of the final report stays close to my template.
Deliverables
• Completed Excel workbook with my data loaded and an accurate Laporan Laba Rugi
• All formulas unlocked and documented in a short note sheet
• Quick walkthrough (video or screenshots) showing how to refresh the report with new data
I prefer someone comfortable working in Indonesian and familiar with standard Indonesian chart-of-accounts codes, but solid accounting skills in any language plus strong Excel (VLOOKUP/XLOOKUP, SUMIFS, Pivot, Power Query) are what matter most. If you can turn this around quickly and keep everything tidy, let’s get started.