UKK Akuntansi 2026 : UD ES PRIMA_ ACCURATE 5_SETUP DATABASE#ukk2026

Summary

This tutorial demonstrates the process of setting up company data and importing financial information into Accurate software version 5. It covers key steps like creating a company profile, configuring financial accounts, mapping data for customers, suppliers, and inventory, and applying payment terms. The video also discusses managing VAT settings and using the average cost method for inventory. By the end, users will have set up the database with essential financial details and be ready to proceed with transactions, providing an essential guide for accounting students to master the software.

Takeaways

• 😀 Ensure that all necessary data (COA, customer, supplier, inventory, and asset data) is prepared in Excel before starting the import process into Ecorate.
• 😀 Create a new company file in Ecorate and save it in the same folder as your Excel data to keep everything organized.
• 😀 Enter company details (name, address, NPWP) and set the fiscal year and transaction cut-off date correctly during the company setup in Ecorate.
• 😀 Import the Chart of Accounts (COA) into Ecorate by mapping account numbers, names, and balances from your Excel file.
• 😀 When importing customer data, ensure correct mapping of customer code, name, address, and payment terms.
• 😀 Similarly, import supplier data by mapping the appropriate fields like supplier code, name, address, and payment terms.
• 😀 Import inventory data into Ecorate, including product codes, descriptions, quantities, and unit prices, and set the inventory costing method to average costing.
• 😀 Ensure correct mapping when importing asset data, and set depreciation method to straight-line for all assets.
• 😀 Configure tax settings properly, noting that VAT is already included in the sales and purchase prices in this scenario, so no separate tax configuration is needed.
• 😀 Complete the month-end closing process for November 2025 by entering the closing date and verifying all reports, like the trial balance, are generated correctly.
• 😀 After the setup is complete, review the opening balances to ensure they match the provided data, confirming everything is ready for transaction processing.

Q & A

What is the main focus of the tutorial in the transcript?

The main focus of the tutorial is setting up an accounting database using Accurate version 5 for a trading company, UD S Prima. The tutorial walks through steps like importing data, configuring company details, and preparing the system for transaction processing.

What is the significance of Accurate version 5 in the tutorial?

Accurate version 5 is the accounting software used in the tutorial to import and manage financial data. The software helps automate processes like bookkeeping and generating financial reports for a trading company.

What types of data are required for the setup process?

The data required for the setup process includes company details (name, address, NPWP, fiscal year), chart of accounts, customer and supplier information, inventory data, and asset details. This data is imported from an Excel file into Accurate version 5.

How does the speaker suggest managing payment terms in Accurate?

The speaker suggests managing payment terms by inputting specific terms such as 'N45' (net 45 days) and '2/10, N30' (a 2% discount if paid within 10 days, net 30). These terms are mapped in the system during the setup.

What are the steps for importing the chart of accounts (COA) into Accurate?

The steps for importing the COA include preparing an Excel file with account data, mapping the account numbers, names, and other fields to the software’s corresponding fields, and then importing the data into Accurate.

What kind of reports are generated after completing the database setup?

After completing the database setup, reports such as the General Ledger and the Balance Sheet are generated to verify the accuracy of the imported data and ensure the system is correctly set up for future transactions.

Why does the speaker emphasize using the 'average' inventory method in the software?

The 'average' inventory method is used in the tutorial because it provides a simple and standardized way to calculate the cost of goods sold (COGS) and maintain accurate inventory valuation without needing to track each unit's cost individually.

How is the depreciation of assets handled in Accurate version 5?

Depreciation of assets is handled by entering asset details such as asset type, purchase date, and useful life. The tutorial uses the 'straight-line' method for depreciation, which spreads the depreciation evenly over the asset’s useful life.

What role do customers and suppliers play in the setup process?

Customers and suppliers play a key role in the setup process by having their data (like names, addresses, and payment terms) imported into Accurate. This allows the system to track accounts receivable and payable for the company.

What should be done after importing all the data into Accurate version 5?

After importing all the data, the next step is to verify the accuracy of the imported information by checking balances, running reports (like the General Ledger and Balance Sheet), and ensuring that everything is set up correctly for future transactions.