Home » Product » MFA Shop/Bar/Grocery Business Software

MFA Shop/Bar/Grocery Business Software

$25

Configuration sheet:1st sheet on the left dated 1st November 2017 is used to insert all shop items and their respective……

Category:

Description

MFA SHOP/BAR/GROCERY BUSINESS SOFTWARE USER GUIDE 2019

A. SHOP/BAR  CONTROL

i. Configuration sheet:1st sheet on the left dated 1st November 2018 is used to insert all shop items and their respective units of measure and also inserting all opening balances for all stocks available in the shop. It is also used to insert the name of the business/company.

In every date; you are supposed to insert figures for quantity added, quantity sold, discount amount and quantity of units damaged if any on every item.

Buying and selling prices can be copy and paste daily if no changes occur.

ii. Summaries extracted in the shop control system:

  • Daily gross profit analysis.
  • Monthly net profit analysis.
  • Daily and monthly total sales.
  • Gross profit for the month.
  • Output tax for the month.
  • Total cost of stocks received in the shop for the month.
  • Total quantity on every item received in the shop for the whole month.
  • Total quantity on every item sold during the month.
  • Total quantity on every item damaged during the month.

 

iii. Income statement:

This is found in the last sheet but second in the right of the shop control database. In this sheet; you are supposed to insert also the name of your company/business.

iv. Balance sheet:

This is found in the exact last sheet on the right side of the shop control database. In this sheet; you are supposed to insert also the name of your business/company. In all cells with yellow colours; you are supposed to insert correct figures manually from fixed asset register or general ledger.

v. How to extract any date easily in order to post data or read the summary/report:

Right click on the left arrows for sheet movement. Then select the date you want to read and then click the selected date; the sheet for that specific report will retrieve.

B.STORE CONTROL

i. Configuration sheet: 1st sheet dated 1st November 2018 is used to insert all items list and their respective units of measure and also inserting all opening balances for all stocks available in the store .It is also used to insert the name of the business/company.

In every date; you are supposed to insert figures for quantity added, quantity shifted /taken to shop, quantity damaged, goods received note no and goods issue note no. Buying price can be copy and paste daily in case prices don’t change.

ii. Summaries extracted in the store control:

  • Total daily purchases received in the store.
  • Daily cost of opening stock.
  • Cost of stocks shifted/taken to shop.
  • Daily cost of closing stock.
  • Cost of stocks shifted to the shop for the month.
  • Total purchases received in the store for the month.
  • Total input tax for the month.
  • Quantity of stocks added in the store for the whole month.
  • Quantity of stocks shifted/taken to the shop for the whole month.
  • Quantity of stocks damaged for the whole month.
  • Total quantity of stocks received in the store item wise during the whole year.
  • Total quantity of stocks taken to shop item wise for the whole year.
  • Total quantity of stocks damaged item wise for the whole year.
  • Total cost of damaged stocks item wise for the whole year.

C.DEBTORS CONTROL:

  1. Configuration sheet: 1st sheet on the left side dated 15th September 2018 is used to insert names of all debtors and name of business. After that, all data can be posted as shown on respective columns on respective dates of transactions.
  2. Summaries extracted monthly on debtors’ control:
  • Total amount paid by the debtor for the month.
  • Total invoices amount for the month.
  • Balance pending for the month not paid.
  • Cumulative balance outstanding by the end of the month.

D.CREDITORS CONTROL

  1. Configuration sheet: 1st sheet on the left side dated 15thSeptember 2018 is used to insert names of all creditors and name of business. After that; all data for invoices, payments can be posted as shown on the respective columns of transactions and respective dates of transactions.
  2. Summaries extracted monthly on creditors’ control:
  • Total amount paid to the vendor/creditors during the month.
  • Total invoices for the month.
  • Balance pending for the month.
  • Cumulative balance outstanding by the end of the month.

 

E.PAYROLL CONTROL:

  1. Configuration sheet: 1st sheet on the left side named November 2018 is used to insert names of all employees; refer a column with green colour and name of business is inserted on the top area highlighted. After that; all data for basic salary, allowances, and advance paid, shortage, loan repayment and employment benefits can be posted as shown on the respective columns of transactions and respective months for payroll preparation.Net pay will recalculate itself automatically.

 

F.GENERAL COMMENT

  1. In order for the files on this software to link; then they should be opened and minimized as you continue with the task of posting data.
  2. On all cells which require you to post numerical figures; don’t post alphabets.
  3. In case of short cut to look for dates; right click the icons on the left side & then select date.
  4. Do not rename or save any new files within this system folder. Doing so will lead to directories from the source documents/files not to link and provide reports.
  5. You are supposed to save changes after every 45 minutes in order to update your database information.
  6. If you are using a Desktop; you are advised to purchase a UPS in order to keep your system active in case of power breakdown.
  7. If you want to expand columns in order to have a wide view of numbers; then click view, then place a tick on heading; you will obtain a chance to expand a specific column.

COPYRIGHT: MFA SOFTWARE 2019

Comments are closed.