ASF-Instructions 

Dashboard:

This module presents financial performance indicators.

KPIs based on sales performance.

Cash flow metrics.

Recovery period for accounts receivable and customers.

Performance and trend in balance sheet, income, and cost account performance.

Data segmentation and dynamic charts based on the PowerPivot data model.

A master dashboard that enables management decision-making based on processed balances containing vital company information.

EF:

This module presents the company's financial statements, as well as general and detailed reports by subaccount.

Financial tables generated based on information from the accounting database:

Balance Sheet

Income Statement

Cash Flow Report

Report by accounting account and subaccount

VAT Creditable vs. VAT Payable Report (found in the dashboard module)

The Trial Balance Report is available in the MasterQLPA module.

Item:

This module provides a data entry to feed the system with the newly acquired inventory.

It is recommended that you also enter data in the same manner based on the purchase invoice for merchandise or materials in the "Accounting" module.

This way, the merchandise account will be reconciled.

Inventory:

This module presents all inventory acquired by the organization and all purchasing-related information from the "Item" module.

It then sends this information to the "Invoice" module, providing conditional measurements for product codes and quantity availability.

It also reports on the cumulative units sold and the final balance, automatically calculated with each sale on an invoice in the system.

This final balance is automatically recalculated for the new invoice issued, thus maintaining strict control over the company's inventory stock and availability.

This module also sends information to the "Invoice" module related to the main product code.

Unidad:

This module presents information on accumulated invoices recorded in terms of units sold.

The same data used to determine the final balance of products sold, reflected in the inventory module.

Factura:

This module presents the invoice, which includes relevant data from the inventory modules. Calculated fields are also established.

Once the billing order is entered, the data is automatically sent to the "Journal" accounting module.

Contabilizar:

This module records the company's operations and accounting entries.

It is the central module where all transactions converge, ready to be recorded once the accounting entry is completed.

The transactions are then finally sent to the accounting database, where all the company's accounting operations are accumulated.

Diario:

In this module, all accounting transactions converge and accumulate.

They come from the "Invoice" module and also the "Post" module.

The main accounting source for generating financial tables using OLAp cubes.

MaserQLAP:

The module processes, classifies, organizes, and extracts information using the data model and OLAp cubes.

It is recommended not to alter any components or calculated fields to ensure the proper functioning of the accounting system.

COA:

Proposed accounting catalog, which can be adjusted according to the company's needs.

It is recommended that the update be carried out by a financial advisor and staff from the FAS system consulting firm. Contact: helmx3@gmail.com

As well as any adjustments or systemic accounting configurations of the system itself.

Procedure for entries in the accounting system

1) Record the transaction in column "A" starting with cell "A7"

2) Select the accounting account corresponding to the accounting transaction from the drop-down list. Transactions must be recorded in subaccounts comprised of 8 characters

3) You can optionally choose to manually record the transactions or apply the automatic entry for VAT (the following entry illustrates the use of the automatic entry)

4) Enter the corresponding date of the accounting transaction in cell "A5"; there is also a date form where you can also select the date

5) Enter the corresponding "Debit and Credit" amounts for the accounting transactions in columns "C and D"; the amounts must be correct

Remember, when recording amounts, the system only accepts up to 2 decimal places.

6) Enter the accounting transaction concept and name in columns "C3 and C4," as well as invoice number information in column "K."

7) Click the automatic record accounting entry button located in column "G."

8) The "Post" button is also used to update all accounting information in the financial tables.

8) If the accounting information is consistent and correct, the entry is sent to the "Journal" accounting base.

Entry for a purchase of supplies [includes automatic VAT entry]

Automatic tax entry for a purchase of company goods

Note: For the automatic tax calculation to work, complete the following:

1) Column "A" Source Account

2) Columns "C and D" Enter the "Credit and Debit" amounts corresponding to the accounting accounts, as shown in the example

3) Column "E" Destination Account:

Copy the value from cell "A8" (only the account number) and paste it into the destination account "E7"

With the automatic entry, you will assign this reference to the corresponding tax account in "E9"

4) Column "F" Enter the VAT tax rate

5) Column "G" Enter: Alternative tax reference text, for example "Advance VAT paid 15%" or other reference text.

6) The system automatically executes the tax entry and assigns the corresponding values ​​in:

D9 Automatic VAT Amount

E9 Destination Account

F9 Tax Rate

G9 Tax Entry Reference Text

H9 Taxable Base Amount

I9 Reference Account for the "Third Party" Field

J9 Amount in the "Net Invoice" Field

Posting a Sale from the Invoice Module

Please complete the fields in the invoice module:

1) Name, concept, date

2) Enter the invoice number in cell "J5." The invoice also has two options: "Cash" and "Credit." These can be selected from the drop-down list in "J6." Do not combine cash and credit; create separate invoices.

3) Select the items to be invoiced from the drop-down lists in column "B."

4) Enter the quantity of products to be invoiced in column "E." If they are in stock, they will be processed. Otherwise, they will be notified as "Not Available."

5) The discount rates and VAT will be automatically entered as appropriate.

6) Once all of the above is completed, click the "Post" button. The invoice will be posted to the "Journal" accounting base.