Simple Accounting System using C# and MS SQL Server with Source Code

Language

This is a very Simple Accounting System for newbies in C#. This project comprises of Chart of Accounts, Simple transactions, a System for Debit And Credit of customers, and other income or expense transactions. It generates reports which are Profit/Loss Statement, Customer Statements, and cashbook statements. This C# project was developed with SQL Server as the back end and Crystal Report. You will certainly learn a lot from the code behind it.

The system works as the following:

  1. System users must populate first the list of the Customers, Cash/Banks, and Chart of Accounts.
  2. Then Encode the encode/store the customer's transaction and post it as a Debit or Credit.
  3. After that, the Profit/Loss Report will be automatically generated and the other reports will be based on the filter options such as the customer name and date range in the Customer Report Statement.

Features

  • Manage Customer List
  • Manage Cash/Bank List
  • Manage Chart of Accounts
  • Manage Cash/Bank Transactions
  • Generates Reports
    • Profit/Loss Report
    • Customer Statement of Account Report
    • Cash/Bank Statement Report

How to Run

Requirements:

  • Download and Install Microsoft Visual Studio Software.
  • Download and Install Microsoft SQL Server.
  • Download and Install Microsoft SQL Server Management Studio.
  • Download and Install SAP Crystal Reports.

Installation/Setup

  1. Download and Extract the provided source code zip file. (download button is located below)
  2. Locate the MDF and SQL Log File inside the "db" folder in the extracted source code folder. The file are known as "SimpleAccount.mdf" and "SimpleAccount_log.ldf".
  3. Open your MS SQL Server Management Studio and connect to a Server.
  4. Attach the provided MDF file to the server.
  5. Locate the C# Project file in the extracted source code folder. The file is known as "SimpleaccountingSys.csproj".
  6. Open the C# Project file with your MS Visual Studio Software.
  7. Configure the database connection string at the "ConnectionString.cs" file.
  8. Press the "F5" key on the keyboard to run the project.

Demo

That's it! You can now experience/explore the features and functionalities of this Simple Account System Project. I hope this simple C# and MS SQL Server Project Source Code entitled Simple Account System will help you with what you are looking for and for your future projects.

Enjoy :)

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Submitted byFlora kAULI (not verified)on Fri, 09/06/2019 - 13:19

i AM INTEREST TO SEE THE PROGRAM

Kindly send me the simple accounts software source code for learning purpose. Will be thankful to you.
Submitted byArauf (not verified)on Fri, 07/02/2021 - 20:05

I need Sql database tables fields design structure scheme to get some reports like Trial Balace, Balance sheet etc . I have already designs saleMaster , SaleDetail Tables and PurchaseMaster and detail , suplierTable, Customer etc These above working well in Vb.net. How to design tables for accounting purpose. Which more other tables create and fields
Submitted byBen Fuchs (not verified)on Wed, 07/28/2021 - 01:11

Hi, I am not able to attach the data file to my database using SSMS 2018 version See error below. TITLE: Microsoft SQL Server Management Studio ------------------------------ An error occurred when attaching the database(s). Click the hyperlink in the Message column for details. ------------------------------ BUTTONS: OK ------------------------------ Thanks
Submitted byBen Fuchs (not verified)on Wed, 07/28/2021 - 06:59

Hi, See error I am getting. https://www.experts-exchange.com/questions/29221221/Error-installing-C-application.html?anchor=a43320158&notificationFollowed=274005052#a43320158
Submitted bySaukad Ali (not verified)on Thu, 08/31/2023 - 15:12

Why it is not downloading?? Is it running and running and not downloading

Add new comment