The Accountant Advance

Easy to use free and open source web based double entry accounting software with invoicing, stock management, payables and receivables

What is "The Accountant Advance"?

Easy to use free and open source web based double entry accounting software with invoicing, stock management, payables and receivables written in PHP - MySQL

Benifits :

Features

Features :

Quick Start Guide

  1. Download .zip package
  2. Upload it to your server
  3. Extract the package
  4. Open "config.php" in accountadvance/application/config/config.php and change the base_url to your installation url.
    For Example:

    Change the following:

    $config['base_url'] = ' ';

    to:

    $config['base_url'] = 'http://localhost/accountadvance/';
  5. Make sure that the Database is created before creating an account and the database name should be the same, as shown below;

Note: The created database should be empty.

How does it work?

  1. The Whole system is divided in two major parts;
    • Admin Section
    • Accounts Section
  2. The Admin Section is used to add different companies which will also create new database for each Account.
  3. Users are also added using the admin Section and user groups and the group permissions are also under the admin section.
  4. User has to activate an account before he/she can create or edit or update within the Account Section.
  5. The Account Section is then used to work on the account which the user has activated.
  6. The user can add products mantain purchases and sales to produce invoices and purchase orders.
  7. Then user can add entries to mantain ledger and groups and produce reports.
  8. The Account section will not work if no account is active

 

What's in Dashboard

There are two dashboards for "The Accountant Advance" as told before;

Admin Dashboard:

 

Account Dashboard:

Description of a Typical Interface

 

You will see similar type of interface everywhere because our design team tried to make the whole interface easy to learn and remember. So if you know what is where in this interface below, you can explore the rest very easliy.

 

  1. In this area you will find group functionalilities e.g. records like add, edit, import and other options
  2. You will find some pages with data loaded in a nice datagrid. You can filter the shown data by searching keywords.
  3. Data are always loaded with pagiation for better performance of the system. You will find the pagination information here and can manipulate pagination options. ( Same for 5 & 6)
  4. It's called the the "Action Area". If you want to read / edit / delete etc a record in datagrid you have to use the action area.

General Settings

Note:
You can manage currencies, categories, sub-categories, taxes, warehouses, customer groups etc, in the inventory settings on left navigation(Main Navigation).

 

Account Section:

Account Section Update Logo:

Admin Section

Adding Accounts:

  1. Select the Companies link in the main navigation it has 2 sub-links
    • Manage
    • Create
  2. Any company which is once created cannot be edited or deleted.
 
Manage Accounts:

Create Account:

 

Adding Users:

  1. Select the User link in the main navigation it has 2 sub-links
    • Manage
    • Create
    • Permissions
Manage Users:

Create User:

Manage User Groups:

Create User Groups:

Edit Group Permissions:

 

 

Accounts Section

Chart Of Account:

Select the Accounts Link in the main navigation to view the chart of account:

Import And Export:

  1. Import Chart of Account from CSV
  2. Export Chart of Account to XLS
Import from CSV:
  1. Select CSV file to import.
  2. The sample CSV is also downloadable.

Mapping your CSV File:

If the selected file is not the same as the given sample then mapping of fields is required.

Add New Group:
  1. Select the Create New Group Button on the Chart Of Account Page, the following page will appear,
  2. The "Group Code" field is automatically updated according the selection from the "Parent Group" drop-down.
  3. Type in the Group Name and click submit.

Add New Ledger:
  1. Select the Create New Ledger Button on the Chart Of Account Page, the following page will appear,
  2. The "Ledger Code" field is automatically updated according the selection from the "Parent Group" drop-down.
  3. Type in the remaining fields and click submit.

 

Entries:

Click the Entries Link in the main navigation, the following page will appear;

Manage Entries:

View Entry:

Old Form:

Add Entries:
  1. By Clicking, the plus(+) Button in the actions column a new row will be added in the table shown in the page below,
  2. The row can be deleted in the same way by clicking the delete button against each row.

Edit Entry:

Fast-Entry Form:

Add Entries:
  1. By Pressing Tab or Enter key, the cursor will focus on the next field,
  2. If cursor is focused on the narration field and Enter key is pressed, the new entry will be added,
  3. The new entry will also be added, by clicking the (+)button next to narration field,
  4. The row can be deleted by clicking the delete button at the end of each row.

Edit Entry:

Products:

Click the "List Products" link in the main navigation, the following page will appear;

Manage Products:

Items are the things that you pitch to your client. This module has been refreshed and has numerous new alternatives/highlights. There are new menus for every item on List Products page. The symbol menus have been supplanted with the dropdown menus.

  1. Add New Product: To add new product.
  2. Update Prices: To update product prices using CSV file.
  3. Print Barcodes/labels: To print the product barcodes/label of selected products, this will bring you to the print barcode/label page with the item.
  4. Import from CSV: To import products through CSV file.
  5. Sync Quantity: To sync quantity selected product.
  6. Export to Excel: To download selected product as excel file.
  7. Delete Selected Rows: To delete selected product.

"3" --- single product options
  1. Edit Product: To edit product details.
  2. Promotion: To set product promotion details(if any), this will open a modal with promotion details like start/end date and price.
  3. Set Rack: To set/change product rack (only available if warehouse selected).
  4. Print Barcode/Label: To print the product barcodes/label, this will bring you to the print barcode/label page with the item.
  5. Delete Product: To delete the product.
Add Product:

There are 4 types to choose for the product,

  1. Standard: These are the standard item like telephone, smash, speakers etc.
  2. Combo: These are items that comprise of in excess of 1 item in your stock like PC with Casing, RAM and Speakers as combo items.
  3. Digital: These are the advanced items that can be downloaded just like programming, motion pictures, pdf instructional exercises etc.
  4. Service: This are benefit as checking/fixing expense for the PC. Presently you can allocate the standardized identification symbology, item impose, assess technique and provider (up to 5 with their cost) to every item. You can choose the primary item pictures and different item display pictures. You even can include the current stock for each distribution center. The item points of interest will be shown on view item page and the item subtle elements for receipt will be shown on the receipt under these items.

Product variants:

You can include any number item variations/qualities and these will be followed consequently on buy/deal. There print standardized identification/name page for every item will demonstrate the new scanner tag picture if there are variations accessible for the item. This will assist you with managing the items well uniquely for the individuals who need to track the items characteristic i.e, sizes and shading etc.

Variants are single dimension and if your item has settled variations, at that point you can include the as Red Size 5, Yellow size 6 and so forth. You have to include these once for each product.

Print Barcodes and Labels:

This page has been included with the goal that you can choose any items to print standardized tag/mark as wanted. You can pick any page styles and print with any work area printer.

Quantity Adjustments:

This component will assist you with managing the harm and different issues with your stock.

Stock Counts:

The stock check is the physical confirmation of the amounts and state of things held in a stock or stockroom. Stock consider might be played out a concentrated yearly end of year technique or might be done persistently by methods for a cycle check. A yearly end of year stock tally is ordinarily improved the situation use in an organization's money related explanations. When tally has been finished, you can add change in accordance with refresh your current stock.

Product Units:

You can include item estimating units in framework settings and after that select the base unit while including/altering the items. This element will assist you with managing the amount well, while obtaining and offering in various units.

For precedent, you buy coke as a crate of 12 containers and you offer them as jug. You can include base unit of box/container and afterward include other with transformation. Include the items and select new base unit. You even can choose the default buy and deal units on include/alter item page.

Import product and update price with csv file:

The guidelines are accessible on the pages. The alternative to include (item and variations) amount to the distribution center is accessible on include item page however we prescribe you to not utilize this. Rather you can include all items and their variations with 0 amount at that point add buy to refresh the stock for (items and their variations) to the distribution center.

Sales

Click the "List Sales" link in the main navigation, the following page will appear;

Manage Sales:

Deals (Invoices) to deal with the deals and installments got. Include deal will consequently diminish the item amount from the chosen distribution center. In the event that your item has variations that will be synchronized as well. Rundown deals page have these drop down menus in the activities segment for every deal.

  1. Add New Sales: To add new sale.
  2. Export to Excel: To download selected sale as excel file.
  3. Combine PDF: To combine multiple sale invoices in one PDF.
  4. Delete Selected Rows: To delete selected sales.

  1. Edit Sale: To edit the sale.
  2. View Payments: To view the payments for the sale.
  3. Packing List: To be used for delivery purpose.
  4. Add Delivery: To add the delivery of the sale items.
  5. View Deliveries: To view the Deliveries for the sale.
  6. Download as PDF: To download the sale as pdf.
  7. Delete Sale: To delete the sale.
Add Sale:

Add Sale page has been upgraded. There is just single information field to add the items to arrange list. You can type the item name or code to get the proposal and select the recommendation or simply check the standardized tag with your scanner to add item to the request list. In the event that there is just 1 proposal for your composed characters, at that point it will naturally have added to the request list. In the event that you have filtered the scanner tag with choice, the request thing alternative will consequently set to the checked standardized tag option.

Add item to arrange list and the aggregates will be consequently stick best and base once the request list achieved the number that you have in settings for Product checks to settle for standardized tag input.

Payment terms are the quantity of days before this deal set apart as due. This esteem ought to be a whole number 14 for 14 days' installment term and 30 for multi month etc.

There are 2 deal status

  1. Pending: The deal is included yet the things has not been given over/conveyed to the customer.
  2. Completed: The deal us included and the items has been sent/given over/continue for delivery.

You can have fractional installments for deals. There are 4 installment status

  1. Pending: The installment has not yet received.
  2. Due: The installment term had been come to yet the installment has not yet received.
  3. Partial: Customer has made the incomplete installment and there is balance that still need to pay by customer.
  4. Paid: The installment for the deal has been totally paid.
To edit or delete any payment, please click the view payments link in actions on sales list or in page menu on sale view page.

Purchases:

Click the "List Purchases" link in the main navigation, the following page will appear;

Manage Purchases:

Purchases (Inventories) to refresh the supply of your items. Including buy will consequently build the item amount in the chosen distribution center. Rundown buys page have these drop down menus in the activities section.

  1. Add Purchase: To add new purchase.
  2. Export to Excel: To download selected purchase as excel file.
  3. Combine PDF: To combine multiple purchase invoices in one PDF.
  4. Delete Selected Rows: To delete selected purchases.

  1. Edit Purchase: To edit the purchase.
  2. View Payments: To view the payments for the purchase.
  3. Download as PDF: To download the purchase as pdf.
  4. Print Barcodes/labels of purchases.
  5. Delete purchase: To delete the purchase.
Add Purchase:

Add Purchase There is just single info field to add the items to arrange list. You can type the item name or code to get the proposal and the select the recommendation or simply filter the standardized identification with your scanner tag scanner to add item to the request list. On the off chance that there is just 1 proposal for your composed characters, at that point it will naturally have added to the request list.

Add item to arrange list and the aggregates will be consequently stick best and base once the request list achieved the number that you have in settings for Product checks to settle for standardized identification input.

People:

Suppliers:

Suppliers are the sellers/providing organizations, the organizations you purchase your stock/things from.

Company, Name (Contact Person), Email, Phone, Address and City input fields are required. You can include additional data about the client as there are 6 custom fields and the select box before every custom field is to show this data on buys. On the off chance that the provider isn't organization, you can skirt the organization document with dash image (- ) so framework will think about it as person.

The contributions for provider in different modules (buys and items) are not any more select/drop down however ajax calls, you can type in hunt field to get the recommendations and select any proposal accessible in database for provider. You can include provider by tapping the Add Supplier menu under People from any page. The interface is relatively same as billers and clients, simple to use.

Billers:

Billers are the offering organizations (you or your organizations/associations), you can offer/quote/receipt your clients with any biller, implies you can have various organizations/associations and can appoint any of these to your staff so the majority of their deal will be under alloted charging company.

Only clients with proprietor assemble rights can include billers. Logo, Company, Name (Contact Person), Email, Phone, Address and City input fields are required.

This module is easy to utilize and deal with the biller. The interface is very straightforward. The logos can be transferred by visiting the change logo under settings and once transferred you have to alter the biller to set the new logo.

Customers:

Customers are the customers of your organizations/associations. They buy the things that you/your organizations/associations offer. This module has been refreshed and now you can include client bunches in settings i.e, Normal Customer, Regular Customer, Resellers, Distributors and so on and dole out rate decrement/augmentation to the cost contingent upon their group.

Company, Name (Contact Person), Email, Phone, Address and City input fields are required. You can include additional data about the client as there are 6 custom fields and the select box before every custom field is to show this data on solicitations/quotations.

If the client isn't organization, you can skirt the organization document with dash image (- ) so framework will think about it as person.

The contributions for client in different modules are not any more select/drop down yet ajax calls, you can type in inquiry recorded to get the proposals and select any recommendation accessible in database for clients. You can include client by tapping the Add Customer menu under People from any page. The interface is very simple to understand.

Customer Groups: The rate in the client bunches are the expansion/subtraction in the item cost for that gathering. On the off chance that you have set 10 rate for client gathering, at that point every client of the gathering will have (10%) higher cost consequently ascertained on deals. On the off chance that you set it to - 10 percent, at that point the items cost will be (10%) lower than typical price.

Price Groups: The value gathering can be doled out to client and afterward every one of the deals will utilize that value amass for the client. This element will enable you to set the diverse costs for customers.

Please be educated that the client aggregate rate will be connected to the costs from value assemble as well. Implies that whatever client cost is the client aggregate rate will be connected at the end.

Search:

By Clicking, the Search Link in the Main navigation the following page will appear

  1. It is an easy to use search with different filters as shown below.

Reports:

Balance Sheet:

Profit and Loss:

Trial Balance:

Ledger Statement:

By Clicking, the Ledger Statement Sub-link in the Main navigation the following page will appear

After Submit:

Legder Entries:

By Clicking, the Ledger Entries Sub-link in the Main navigation the following page will appear

After Submit:

Account Settings:

Carry Forwarding:

By Clicking on the Carry forward sub-link under the account settings link in the main navigation the following page will appers,

Account Carry Forward will carry all the data within an account to a newly created account of the company.

Email Settings:

Printer Settings:

Entry Types:

By Clicking on the Entry Types sub-link under the account settings link in the main navigation the following page will appers,

These are the types of entries which the user adds under the entries link in the main navigation.

Add new Entry Type:

Edit Existing Entry Types:

Tags:

By Clicking on the Tags sub-link under the account settings link in the main navigation the following page will appers,

These are the tags of entries which the user adds to entries when adding new entries.

Add new Tags:

Lock Account:

By Clicking on the Lock Account sub-link under the account settings link in the main navigation the following page will appers,

Support

Thank you so much for purchasing this application.If you have any question that are beyond the scope of this help file, please feel free to check our support instructions:

Source and Credits

Thanks so much to