User:Csloo/Main Structure

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

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...

• 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

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

At different standard Account Type (level 1), there is a separate set of special type : -

Account Type	Special Type	Purpose
Fixed Asset	Accumulated Deprn Account	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	Bank Account	Enable to create Bank Reconciliation and input single entry in Cash Book Entry, Customer Payment and Supplier Payment.
Current Asset	Cash Account	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.
Current Asset	Customer Control Account	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.
Current Asset	Balance Stock Account	To capture the Balance Sheet stock account in Maintain Stock Value.
Current Liabilities	Bank Account	Enable to do Bank Reconciliation and input single entry in Cash Book Entry, Customer Payment and Supplier Payment.
Current Liabilities	Supplier Control Account	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.
Cost of Goods Sold	Opening Stock	To capture the P&L opening stock account in Maintain Stock Value.
Cost of Goods Sold	Closing Stock	To capture the P&L closing stock account in Maintain Stock Value.
Cost of Goods Sold	Manufacturing Control Account	To differentiate part of the COGS account categorized into the manufacturing accounts.