Introduction
The Double Entry Accounting System is a powerful, feature-rich accounting solution built on ASP.NET Core, designed for businesses and developers. It follows the double-entry bookkeeping method to ensure accurate financial tracking, making it ideal for companies of all sizes.
With support for multi-company and multi-branch management, industry-specific chart of accounts, and essential financial reports like trial balance, balance sheet, journal ledger, and income statement, this system provides everything needed for efficient accounting.
Developers can benefit from its scalable and customizable architecture, with full source code included, allowing seamless modifications and integrations. Whether you’re managing business finances or building an advanced accounting solution, the Double Entry Accounting System is the perfect choice.
Documentation
The AM-technology documentation is designed to guide you through the project setup process, enabling you to swiftly launch your site.
Installation:
Navigate the process of setting up the project environment.
Technology Stack:
Explore the unified C#, SQL Server, Bootstrap, and Microsoft ASP.NET Core foundation.
Developer Guide:
Tailored for developers, this section provides insights into project development specifics.
Release Notes:
Stay updated on the latest features, enhancements, and bug fixes.
Installation Guide
Quick Start with Pre-installed Option
Embark on your project journey swiftly with our hassle-free pre-installed solution, in collaboration with Windows Hosting. For b
Key Advantages
-
Time-saving: No need to search for hosting providers or choose a plan.
-
Reliable performance: Our preinstalled hosting plan ensures fast and reliable operation of your project.
-
Free trial: WinHost offers a 30-day free hosting trial for pre-installed project environments.
-
Explore Hosting Plans and kickstart your project today.
Installation Process
AM Technology software is a versatile cross-platform solution compatible with both Windows and Linux. Explore two installation options: deploying the project on Microsoft Azure or opting for the pre-installed version for the quickest setup.
Setting Up with IIS (Package without the Source Code)
-
Copy the contents of the extracted project folder to an IIS virtual directory or site root.
-
Access the site using a browser.
Note: For versions 3.90 or below, configure it to run in integrated mode and configure the application pool to run no managed code.
Database Configuration
-
Create a new SQL Server database.
-
Establish SQL username and password.
-
Copy and paste the SQL script provided along with the project.
Modifying Connection String in appsettings.json
-
Open appsettings.json in Notepad.
-
Adjust the connection string with your SQL Server details:
-
Host
-
Database name
-
Username
-
Password
Uploading on Windows/Plesk
-
Utilize an FTP client to upload the project files to your server.
-
Download an FTP client application of your choice.
-
Locate FTP credentials in your hosting control panel.
-
Set up the FTP connection using the obtained credentials.
-
Upload project files to the server.
Database Creation
Before launching the project, create a new database instance in your hosting control panel to store your website data.
Connection String Update in appsettings.json
-
Open appsettings.json in Notepad.
-
Adjust the connection string with your SQL Server details:
-
Host
-
Database name
-
Username
-
Password
System Requirements
Supported Operating Systems
-
Windows 10 Client (1607 or above)
-
Windows 11 (22000 or above)
-
Windows Server 2012 R2 or above
Supported Databases
-
MS SQL Server 2019 or above
Supported Browsers
-
Microsoft Edge
-
Microsoft Internet Explorer 9 and above (IE6 and IE7 were supported in versions prior to 3.60, IE8 was supported in versions prior to 4.10)
-
Mozilla Firefox 2.0 and above
-
Google Chrome 1.x
-
Apple Safari 2.x
Experience the efficiency and flexibility of your project installation with our user-friendly guide. For assistance, refer to our troubleshooting guide or reach out to our support team.
Contact Support
Quick Start Guide – Double Entry Accounting System
Step 1: Download the Software
-
Visit our official website.
-
Click on the Download button to get the installation package.
-
Save the file to your local system.
Step 2: Install on Your Server
-
Extract the downloaded files.
-
Upload the files to your ASP.NET Core-supported hosting server.
-
Configure your SQL Server database and update the connection string in appsettings.json.
-
Run database migrations to set up the necessary tables.
-
Deploy the application and ensure all dependencies are installed.
Step 3: Configure Your Account
-
Log in to the admin panel with default credentials (provided in documentation).
-
Update company details, add users, and set up multi-company & multi-branch settings.
-
Customize the Chart of Accounts based on your business needs.
Step 4: Start Managing Your Finances
-
Journal Ledger: Record transactions and maintain accurate financial records.
-
Trial Balance & Balance Sheet: Get real-time insights into your financial health.
-
Income Statement: Monitor business profitability and track expenses.
-
Multi-Company & Multi-Branch Support: Easily manage multiple businesses from a single dashboard.
Step 5: Explore Advanced Features
-
Customize reports, set user roles, and integrate additional modules.
-
Modify source code if needed – full source code is included!
-
Stay secure with built-in authentication and access control.
Technology Stack:
Backend Technologies:
-
ASP.NET Core: Our software is built on the robust ASP.NET Core framework, which provides a high level of performance, security, and flexibility for web applications.
-
MS SQL Database:
We employ the Microsoft SQL Database, a highly reliable and scalable relational database system, to store and manage your data securely.
-
Entity Framework:
Entity Framework is utilized as an Object-Relational Mapping (ORM) tool to streamline database interactions, enabling efficient data access and management.
-
C# Language:
We have developed the software using the C# programming language, renowned for its efficiency and maintainability in building modern applications.
Frontend Technologies:
-
Bootstrap: Our user interface is designed with Bootstrap, a responsive and mobile-first framework, ensuring a consistent and visually appealing experience across various devices.
-
jQuery: We utilize jQuery to simplify complex client-side scripting and enhance the user experience by enabling dynamic interactions and user interface enhancements.
-
Ajax: Asynchronous JavaScript and XML (Ajax) is employed to enable real-time data retrieval and seamless communication between the frontend and backend, resulting in a more responsive and dynamic application.
Our technology stack represents a well-balanced combination of cutting-edge and established technologies, carefully chosen to ensure the performance, security, and scalability of our software solution. If you have any questions or require further details regarding our technology stack, please feel free to reach out at your convenience.
Developer Guide
Introduction
The Double Entry Accounting System is designed to provide advanced financial management capabilities for modern businesses. This guide details the key features, additional accounting functionalities, and technical architecture of the system.
Key Features
1. Double Entry Accounting
-
Balanced Entries:
The system enforces strict double-entry accounting rules, ensuring that every journal entry has matching debits and credits.
-
Configurable Validation:
-
Disable Double Entry Check: Users can opt to disable the double entry validation in the configuration settings, allowing flexibility in journal entries.
-
Enforced Double Entry: When enabled, the system rigorously verifies that total debits equal total credits for every journal entry, ensuring financial accuracy.
2. Customizable Chart of Accounts
-
Pre-Defined Account Hierarchy:
The system includes a three-level pre-defined account hierarchy based on standard accounting practices:
-
AccountType1 – Main Account Types: Assets, Liabilities, Equity, Income, and Expense.
[
{ "ID": 1, "Name": "Assets", "ShortCode": "AS", "IsActive": true },
{ "ID": 2, "Name": "Liabilities", "ShortCode": "LI", "IsActive": true },
{ "ID": 3, "Name": "Equity", "ShortCode": "EQ", "IsActive": true },
{ "ID": 4, "Name": "Income", "ShortCode": "IC", "IsActive": true },
{ "ID": 5, "Name": "Expense", "ShortCode": "EX", "IsActive": true }
]
-
AccountType2 – Secondary Classifications:
Examples include Current Assets, Fixed Assets, and Non-Current Liabilities.
[
{ "ID": 6, "ParentId": 1, "Name": "Non-Current / Fixed Assets", "ShortCode": "NC", "IsActive": true },
{ "ID": 7, "ParentId": 1, "Name": "Current Assets", "ShortCode": "CA", "IsActive": true },
{ "ID": 8, "ParentId": 2, "Name": "Non-Current Liabilities", "ShortCode": "NCL", "IsActive": true },
{ "ID": 9, "ParentId": 2, "Name": "Current Liabilities", "ShortCode": "CL", "IsActive": true },
{ "ID": 10, "ParentId": 3, "Name": "Equity", "ShortCode": "EQ", "IsActive": true },
{ "ID": 11, "ParentId": 4, "Name": "Income", "ShortCode": "IN", "IsActive": true },
{ "ID": 12, "ParentId": 5, "Name": "Trading Expense", "ShortCode": "TE", "IsActive": true },
{ "ID": 13, "ParentId": 5, "Name": "Operating / Administrative Expenses", "ShortCode": "OAE", "IsActive": true }
]
-
AccountType3 – Detailed Sub-Accounts:
Provides in-depth financial categorization for items such as “Property, plant, and equipment” and “Inventory Assets.”
[
{ "ID": 14, "ParentId": 6, "Name": "Property, plant, and equipment", "ShortCode": "PPE", "IsActive": true, "IsPerson": false },
{ "ID": 15, "ParentId": 6, "Name": "Inventory Assets", "ShortCode": "IA", "IsActive": true, "IsPerson": false },
// … additional sub-account definitions …
{ "ID": 114, "ParentId": 13, "Name": "Others", "ShortCode": "OTH", "IsActive": true, "IsPerson": false }
]
-
Custom Hierarchy Levels:
Users can create a personalized chart of accounts, modifying existing account types and adding new levels as needed.
3. Multi-Entity Management
-
Multiple Companies and Branches:
A single user account can manage multiple companies, each with multiple branches, enabling centralized control with decentralized operations.
-
Accounting Year Management:
The system supports setting an opening balance for each accounting year and accommodates both opening and closing processes.
4. Journal Entries & Reporting
-
Journal Entry Management:
Create, edit, and post double-entry journal entries using an intuitive interface with configurable validation options.
-
Standard Financial Reports:
Generate essential financial reports, including:
- Trial Balance – A snapshot of all ledger balances.
- General Ledger – Detailed transaction records.
- Income Statement – Multiple formats for profit and loss analysis.
- Balance Sheet – Various layout options for reporting financial position.
- Running Head of Accounting Balance – Displays ongoing balances for quick reviews.
5. Extensibility & Future Enhancements
-
Planned Updates Include:
- Receipt and Voucher System – Additional modules for handling receipts and vouchers.
- Taxation – Enhanced support for accurate tax calculations and reporting.
- CRM Integration – Integrated features for managing customer relationships within the system.
Additional Accounting Features
-
Fixed Asset Management:
- Track asset acquisition, depreciation, and disposals.
- Automate depreciation calculations using methods like straight-line and declining balance.
- Generate comprehensive asset-related reports.
-
Budgeting and Forecasting:
- Set budgets and track actual performance against targets.
- Receive variance analysis reports to identify deviations and trends.
- Utilize forecasting tools that leverage historical data for future predictions.
-
Cost Accounting & Job Costing:
- Allocate costs across projects, departments, or products.
- Implement activity-based costing for detailed overhead allocation analysis.
- Track project or job profitability with detailed cost breakdowns.
-
Multi-Currency Support:
- Enable transactions in multiple currencies with real-time exchange rate updates.
- Automate currency conversion and provide consolidated reporting for international operations.
-
Advanced Reporting & Analytics:
- Create customizable dashboards featuring key performance indicators (KPIs) for rapid financial insights.
- Generate flexible reports and visualizations, including charts and graphs with drill-down capabilities.
-
Tax Management:
- Automate tax calculations for various jurisdictions.
- Support tax return preparation and filing.
- Integrate with tax authorities or third-party tax software for real-time compliance.
-
Audit Trail & Compliance:
- Maintain a detailed audit log of all changes to financial data.
- Ensure compliance with local accounting standards (GAAP, IFRS) and regulatory requirements.
- Implement role-based access control to secure sensitive data.
-
Integration Capabilities:
- Provide APIs and built-in integrations with third-party systems (CRM, ERP, banking systems).
- Support seamless data import/export and integration with payment gateways and e-commerce platforms.
-
Mobile Access:
- Offer mobile-responsive interfaces or dedicated mobile apps for on-the-go management.
- Allow users to approve transactions, review reports, and manage journal entries via smartphones or tablets.
-
Workflow Automation:
- Automate routine tasks such as invoice processing, payment reminders, and reconciliation.
- Create custom workflows for transaction approvals and escalations.
- Implement notifications and alerts for critical accounting events.
Technical Overview
Platform & Technologies:
- Backend: .NET Core
- Database: MS SQL Server
- Frontend: AJAX, jQuery, and Bootstrap for a responsive design
Architecture:
- Code First Approach for rapid development
- Modular controller-based design for scalability and maintainability
- Separation of concerns with distinct layers for business logic, data access, and presentation
Code Structure: A detailed diagram is available as a placeholder for your code structure screenshot. Replace this section with the actual screenshot when available.
Release Notes
We continuously enhance and refine our Double Entry Accounting System to ensure optimal performance, security, and user experience.
Improvements:
- Faster Data Processing – Optimized database queries for large financial records.
- Improved System Stability – Reduced downtime and increased response speed.
- Enhanced Financial Reports – More accurate and detailed financial insights.
Bug Fixing:
- Fixed occasional crashes when handling large journal entries.
- Resolved pagination issues in financial reports.
- Improved session management for secure logins.
Improvements:
- Branch-Wise Financial Tracking – Assign journal entries and reports to specific branches.
-UI Enhancements – Cleaner and more intuitive navigation.
Bug Fixing:
- Resolved incorrect financial totals in multi-branch reports.
- Improved performance for large data entries.e display on bookings.
Improvements:
- Opening Balances Support – Set up starting financial figures with ease.
- Improved Accounting Year Management – Organize and archive past records efficiently.
Bug Fixing:
- Fixed UI alignment issues in the supplier management section.
- Improved data validation for financial transactions.
Improvements:
- Enhanced Journal Entry Management – Bulk entry and improved record tracking.
- New Report Filters – Filter reports by branch, date, and account category.
Bug Fixing:
- Resolved ledger inconsistencies for multi-branch companies.
- Improved database query execution for faster reporting.
Improvements:
- Company Switching Feature – Seamless transition between multiple companies.
- System Preferences & Settings Panel – Customize preferences for better usability.
Bug Fixing:
- Fixed incorrect financial report export formatting.
- Improved security for password resets and profile updates.
Improvements:
- Core Features Launched – Journal Entries, Trial Balance, Income Statement, Balance Sheet, Ledger Reports.
- Multi-Company Support – Manage multiple businesses from a single account.
- Dashboard Overview – Quick access to financial data and key metrics.
Bug Fixing:
- Resolved installation and setup issues.
- Fixed incorrect calculations in journal entry balancing.
- UI refinements for a smoother user experience.
User Guide
Get step-by-step guidance on setting up and using the Double Entry Accounting System. Learn how to manage journal entries, generate reports, and streamline your accounting process effortlessly!
Download User Guide