User:Csloo/Main Structure: Difference between revisions

From eStream Software
Line 59: Line 59:
=====Special Account Type=====
=====Special Account Type=====
<br />
<br />
Fixed Asset
1. Fixed Asset
Accumulated Deprn Account
* Accumulated Deprn Account
Purpose : To differentiate the fixed asset cost and accumulated depreciation in Balance Sheet report , especially select Balance Sheet format as ‘This Year – 3 column’.
Purpose : To differentiate the fixed asset cost and accumulated depreciation in Balance Sheet report , especially select Balance Sheet format as ‘This Year – 3 column’.


Current Asset
<br />
Bank Account
 
2. Current Asset
* Bank Account
Purpose : Enable to create Bank Reconciliation and input single entry in Cash Book Entry, Customer Payment and Supplier Payment.
Purpose : Enable to create Bank Reconciliation and input single entry in Cash Book Entry, Customer Payment and Supplier Payment.


Cash Account
* Cash Account
Purpose : Enable to create Bank Reconciliation (if you need to reconcile the cash balance) and input single entry in Cash Book Entry, Customer Payment and Supplier Payment.
Purpose : Enable to create Bank Reconciliation (if you need to reconcile the cash balance) and input single entry in Cash Book Entry, Customer Payment and Supplier Payment.


Customer Control Account
* Customer Control Account
Purpose : To set this account to Maintain Customer and input single entry by selecting the customer in Sales invoice, Cash Sales, DN, CN, Customer Payment, etc, but not allowed in journal entry.
Purpose : To set this account to Maintain Customer and input single entry by selecting the customer in Sales invoice, Cash Sales, DN, CN, Customer Payment, etc, but not allowed in journal entry.


Balance Stock Account
* Balance Stock Account
Purpose : To capture the Balance Sheet stock account in Maintain Stock Value.
Purpose : To capture the Balance Sheet stock account in Maintain Stock Value.
<br />
3. Current Liabilities
* Bank Account
�Purpose : Enable to do Bank Reconciliation and input single entry in Cash Book Entry, Customer Payment and Supplier Payment.
* Supplier Control Account
�Purpose : Enable to set this account to Maintain Supplier and input single entry by selecting the supplier in Purchase invoice, Cash Purchase, DN, CN, Supplier Payment, etc, but not allowed in journal entry.
4. Cost of Goods Sold
* Opening Stock�
Purpose : To capture the P&L opening stock account in Maintain Stock Value.
* Closing Stock
�Purpose : To capture the P&L closing stock account in Maintain Stock Value.
* Manufacturing Control Account
�Purpose : To differentiate part of the COGS account categorized into the manufacturing accounts.


====Cash Book Entry====
====Cash Book Entry====

Revision as of 09:29, 1 June 2012

SQL Financial Accounting

SQL Business Suite is designed to support applications that deliver business-critical functionality to large deployment of network environment. It is build and optimized for mission-specific application.

At the core SQL Business Suite lies a robust Client-Server architecture that allows it to deliver significant advantages in flexibility, reliability, performance and stability. Self-tuning features include cost-based query optimization and dynamic re-balancing of reports structures enhance performance and provides a wide range of business reports.

More important, SQL Business Suite is an open period solution that enables you to collect more data over a wider time frame for better decision-base analysis.

-eStream Software Updated 22 July 2010


Overview

Features

Standard Function & Button

Main Modules

GL

  • Recording all the General Ledger double entry and bank transactions.
  • Maintain your detailed budget data in order to compare with your actual results.
  • Review / print the financial year end reports, e.g. Profit and Loss Statement, Balance Sheet, etc.


Maintain Account

Menu: GL | Maintain Account...

GL-Maintain Acc.jpg

  • Mainly to structure your Chart of Account for Balance Sheet and Profit & Loss Account.
  • You able to set multiple levels to your Chart of Accounts tree, eg. level 1, 2, 3,...... See the above screenshot (Vertical lines represent levels)


Create New GL Account

GL-New GL Acc.jpg

Field Name Properties
GL Code
  • Field type : Alphanumerical
  • Length : 10
  • Not spacing is allowed in any coding.
Description
  • Field type : Alphanumerical
  • Length : Unlimited (Not recommended to store too long because you may have difficulties to view the full description in the report.)
  • Spacing is allowed.
2nd Description
  • Field type : Alphanumerical
  • Length : Unlimited (Not recommended to store too long because you may have difficulties to view the full description in the report.)
  • Spacing is allowed


Special Account Type


1. Fixed Asset

  • Accumulated Deprn Account

Purpose : To differentiate the fixed asset cost and accumulated depreciation in Balance Sheet report , especially select Balance Sheet format as ‘This Year – 3 column’.


2. Current Asset

  • Bank Account

Purpose : Enable to create Bank Reconciliation and input single entry in Cash Book Entry, Customer Payment and Supplier Payment.

  • Cash Account

Purpose : Enable to create Bank Reconciliation (if you need to reconcile the cash balance) and input single entry in Cash Book Entry, Customer Payment and Supplier Payment.

  • Customer Control Account

Purpose : To set this account to Maintain Customer and input single entry by selecting the customer in Sales invoice, Cash Sales, DN, CN, Customer Payment, etc, but not allowed in journal entry.

  • Balance Stock Account

Purpose : To capture the Balance Sheet stock account in Maintain Stock Value.


3. Current Liabilities

  • Bank Account

�Purpose : Enable to do Bank Reconciliation and input single entry in Cash Book Entry, Customer Payment and Supplier Payment.

  • Supplier Control Account

�Purpose : Enable to set this account to Maintain Supplier and input single entry by selecting the supplier in Purchase invoice, Cash Purchase, DN, CN, Supplier Payment, etc, but not allowed in journal entry.

4. Cost of Goods Sold

  • Opening Stock�

Purpose : To capture the P&L opening stock account in Maintain Stock Value.

  • Closing Stock

�Purpose : To capture the P&L closing stock account in Maintain Stock Value.

  • Manufacturing Control Account

�Purpose : To differentiate part of the COGS account categorized into the manufacturing accounts.

Cash Book Entry

Journal Entry

Foreign Bank Adjustment

Maintain Opening Balance

Bank Reconciliation

Maintain Stock Value

Maintain Budget

Reports

Print G/L Document Listing
Print Journal of Transaction Listing
Print Transaction Summary Listing
Print Ledger Report
Print Trial Balance
Print Receipt & Payment Report
Print Profit & Loss Statement
Print Balance Sheet Statement

Customer

Maintain Customer

Customer Invoice

Customer Payment

Customer Debit Note

Customer Credit Note

Customer Refund

Customer Contra

Reports

Print Customer Document Listing
Print Customer Balance Report
Print Customer Due Document
Print Customer Aging Report
Print Customer Statement
Print Customer Post Dated Cheque Listing
Print Customer Analysis By Document
Print Customer Sales and Collection Analysis

Supplier

Maintain Supplier

Supplier Invoice

Supplier Payment

Supplier Debit Note

Supplier Credit Note

Supplier Refund

Supplier Contra

Reports

Print Supplier Document Listing
Print Supplier Balance Report
Print Supplier Due Document
Print Supplier Aging Report
Print Supplier Statement
Print Supplier Post Dated Cheque Listing
Print Supplier Analysis By Document
Print Supplier Purchase and Payment Analysis

Sales

Quotation

Sales Order

Delivery Order

Invoice

Cash Sales

Debit Note

Credit Note

Sales Cancelled Note

Reports

Print Sales Document Listing
Print Outstanding Sales Document Listing
Print Sales Picking Listing
Print Sales Price History
Print Profit & Loss by Document=
Print Sales Analysis by Document
Print Yearly Sales Analysis

Purchase

Inventory

Production