FrontAccounting-2.4.7/C2/Purchase-and-Reports-in-FrontAccounting/English

From Script | Spoken-Tutorial
Jump to: navigation, search
Visual Cue
Narration
Slide 1 :

Title Slide

Welcome to the spoken tutorial on Purchases and Reports in FrontAccounting
Slide 2 :

Learning Objectives

  • Add Suppliers
  • Make a Purchase Order Entry
  • Create Suppliers invoice
  • Generate various reports on the transactions
In this tutorial, we will learn to
  • Add Suppliers
  • Make a Purchase Order Entry
  • Create Suppliers invoice and
  • Generate various reports on the transactions
Slide 3 :

System Requirements

  • Ubuntu Linux OS version 14.04
  • FrontAccounting version 2.3.25
To record this tutorial, I am using
  • Ubuntu Linux OS version 16.04
  • FrontAccounting version 2.4.7
Slide 4 :

Pre -requisites

To practise this tutorial, you must have knowledge of:

  • Higher secondary commerce & accounting
  • Principles of Bookkeeping
To practise this tutorial, you must have knowledge of:
  • Higher secondary commerce and accounting and
  • Principles of Bookkeeping
You should have already
  • Set up an Organisation/Company in FrontAccounting

If not, for relevant FrontAccounting tutorials please visit https://spoken-tutorial.org

And you should have already set up an Organisation/Company in FrontAccounting

If not, for relevant FrontAccounting tutorials please visit this website.

Slide 5:

Start XAMPP service

Start the XAMPP services before you begin working on FrontAccounting interface.
Narration Let us understand the meaning of Purchase.
Slide 6:

What is Purchase?

  • A product or service that has been bought by an individual or business.
  • A business attempting to acquire goods or services to accomplish its goals.
Purchase refers to
  • A product or service that has been bought by an individual or business.
  • A business attempting to acquire goods or services to accomplish its goals.
Narration Now, let us open the FrontAccounting interface.
Click on browser >>localhost/account >> Press Enter Open the browser, type

localhost/account and press Enter.

Point to the page The login page appears.
Enter Username and Password >>

Click>>Login button>>

Type the username as admin and the password.

Then click on the Login button.

Narration

Point and click on the >>Purchases Tab>>

FrontAccounting interface opens.

Click on the Purchases tab.

Narration Let us see the procedure for Purchases in FrontAccounting.
Slide 7:

Purchase Entry

  • Add Suppliers
  • Purchase Order Entry
  • Note from a Supplier
  • Suppliers invoice
The steps to be followed for a Purchase Entry are:
  • Add Suppliers
  • Make a Purchase Order Entry
  • Receivable note from a Supplier
  • Suppliers invoice
Narration But first let us understand the meaning of Supplier.
Slide 8:

Who is Supplier?

A person or business that supplies goods or services.

Supplier is a person or business that supplies goods or services.
Return back to the FrontAccounting interface. Switch back to the FrontAccounting interface.
Click on the Suppliers tab. In the Maintenance panel, click on the Suppliers link.
Highlight with red box
  • Supplier Name – Kumar and Co.
  • Suppliers Short Name – KC
  • suppliers currency – Indian rupees
  • Tax group : Tax
  • Bank name: State Bank of India
  • Credit limit : 100,000
Here, we need to fill in all the necessary information related to a Supplier.

I have filled the required details as shown here.

Click>> Add New Suppliers Details >>

Point to the message A New Supplier has been added.

Scroll down.

Click on Add New Supplier Details button at the bottom of the window.

We can see the confirmation message for the saved entry.

Click>> Update Supplier >> We need to apply these changes for the new Purchase Order Entry.

Scroll down and click on the Update Supplier button at the bottom of the window.

Point to the message bar

Supplier has been updated

The success message shows that we have updated the supplier.
Click to the Back option Scroll down. Click on the Back link at the bottom of the window.
Point to Purchase Order Entry link Let us make a Purchase Order Entry.

It is used to register all Purchase Orders in the system.

Click on the Purchases Order Entry link In the Transactions panel, click on the Purchase Order Entry link.
Point >> Supplier textbox>>

Narration

current credit:0.00

We can see the details with the Supplier name and other related information.

This is because we had already updated the details of the supplier earlier.

Highlight the option of Supplier’s reference with red box.Type the Suppliers reference S001. It is mandatory to give Supplier’s reference.

So, I will type the Supplier’s reference as S001.

Click >> Item Description dropdown menu>> In the Item Description drop-down menu, select Item as Dell laptop.
Click>> Quantity field >>2 In the Quantity field, I will type 2 as the quantity.
Point to >>Required Delivery Date>> Select the Required Delivery Date accordingly.

By default, it will be 10 days after the order date.

I’ll keep the same.

Click>>Price before Tax>> 48,000 Now, in the Price before Tax field, I will type the Price as 48,000.
Click>> Add item button>> To save the entry, click on the Add Item button at the right end of the row.
Point >> Sub-Total and Amount Total Balance >> 107,520 We can see the Amount Total along with the GST.
Click on the Place Order button

Point to the message “Purchase Order has been entered.”

Now, click on the Place Order button at the bottom of the window.

The success message shows that the Purchase Order has been placed.

Narration Now, we need to receive the items for the Purchase Order.
Click on the Received Items on this Purchase Order option. In the window, click on the link Receive Items on this Purchase Order.

We can see the details of the received items for our Purchase Order.

Click on the Process Received Items button. Click on the Process Receive Items button at the bottom of the window.
Point to the message

Purchase Order Delivery has been processed.

We can see a message, “Purchase Order delivery has been processed.”
Highlight the options with the red box-
  • View this Delivery
  • View the GL Journal Entries for this Delivery
  • Entry purchase invoice for this receival
  • Select different purchase order for receiving items against
  • Back
Below that, we can see some more options.

You may explore these options on your own later.

Narration After this, we need to receive a Purchase invoice.
Click on the Entry purchase invoice for this receival So, click on Entry purchase invoice for this receival link.

Here, we can see the details to enter Supplier invoice.

Type S001 as Supplier’s reference. Type S001 as the Supplier’s reference.

It will give an error if you don’t give the supplier reference.

Click on the Add button

107,520

Click on the Add button at the right end of the row.

Scroll down.

We can see the details for the invoice with the GST.

Click on the Enter Invoice button. Click on the Enter Invoice button at the bottom of the window.
Point to the message Supplier invoice has been processed We can see a message that we have successfully processed the Supplier invoice.
Narration Next, we need to pay the Supplier against the invoice made.
Click Entry supplier payment for this invoice. Click on Entry supplier payment for this invoice link.
Point to Supplier Payment Entry. Narration We see the Supplier Invoice details showing that we need to pay the Supplier.
Narration

Point to the bank balance

Also, there has to be some Bank Balance to pay the Supplier.
Type ‘Being payment made to the supplier - S001’ In the Memo field, type ‘Being payment made to the supplier - S001’
Click on the Enter Payment button. Then click on the Enter Payment button at the bottom of the window.
Point to the message

Payment has been successfully entered.”

The confirmation message shows that we have successfully made the Payment.
Highlight the options with the red box-
  • Print This Remittance
  • Email This Remittance
  • View the GL Journal Entries for this Payment
  • Enter Another supplier payment
  • Enter Other Payment
  • Enter
  • Back
Below that, we can see some more options.

You may explore these options on your own later.

Click on the View the GL journal Entries for this Payment. Next, click on View the GL journal Entries for this Payment link.

Click on the close link at the bottom of the window.

Slide 9:

Assignment

  • Add a new Supplier for Purchases, using suppliers option
  • Make a new Purchase Order Entry
  • Make a Supplier payment for this invoice
  • Refer to the Assignment link of this tutorial for details
As an assignment, do the following:
  • Add a new Supplier for Purchases, using Suppliers option
  • Make a new Purchase Order Entry
  • Make a Supplier payment for this invoice
  • Refer to the Assignment link of this tutorial for details
Narration

Bank balance : 2,23,627

So far, in our company, we made few transactions related to Sales and Purchases.

Now let us see various reports related to these transactions.

Click on Banking and General Ledger

Inquiries and Reports>>click on Banking Reports

Click on Banking and General Ledger tab.

Under Inquiries and Reports panel, click on Banking Reports link.

Click on Bank statement Click on Bank statement link on the right panel.
Point to Bank Accounts In the right panel, keep the Bank Accounts field as Current account.
Point to start date and end date Select the Start Date and End Date for the transactions to see the report.
Click on the Display:Bank statement Click on the Display:Bank statement button at the top right corner.

We can see a consolidated Bank statement report.

Close the window. Close this window.
Click on Sales tab. Next, click on Sales tab.
Inquiries and Reports panel>> click on Customer and Sales Reports. In the Inquiries and Reports panel, click on Customer and Sales Reports link.
Report Classes>> click on General ledger link. In the next window, under Report Classes, click on General Ledger link.
Right panel >> click on List of journal entries Then click on List of Journal Entries link on the right panel.
Point to the Start date and End Date Select the Start Date and End Date for the transactions to see the report.
Click on Display:List of journal entries Click on the Display:List of journal entries button at the top right corner.

We can see all Journal Entries that are entered in the company.

Close the window. Let’s close this window.
In Report classes, click on General Ledger link. Under Report classes, click on General Ledger link.
Right panel>> click on Trial Balance link In the right panel, click on Trial Balance link.
Point to the Start date and End Date Select the Start Date and End Date for the transactions to see the report.
Click on Display:Trial balance Click on Display:Trial balance button at the top right.

We can see the corresponding report.

This is based on the list of all the General Ledger accounts.

Close the window. Close the window.
In Report classes, click on General Ledger Under Report classes, click on General Ledger link.
Click on Balance sheet Click on Balance Sheet link on the right panel.
Point to the Start date and End Date Select the Start Date and End Date for the transactions to see the report.
Click on Display: Balance sheet Click on Display: Balance sheet button at the top right.

We can see the corresponding report of Assets and Liabilities

Close the window. Close the window.
In Report classes, click on customer link. Under Report classes, click on Customer link.

Here we can see Price listing, customer detail listing, Customer trial balance.

Explore these reports on your own.

narration This brings us to the end of this tutorial.

Let us summarize.

Slide 10

summary

In this tutorial, we have learnt to
  • Add Suppliers
  • Make a Purchase Order Entry
  • Create Suppliers invoice
  • Generate various reports on the transactions
Slide 11

Acknowledgement

  • The video at the following link summarises the Spoken Tutorial project.
  • Please download and watch it
Slide 12

About workshops

  • The Spoken Tutorial Project Team conducts workshops and gives certificates.
  • For more details, please write to us.
Slide 13

Forum for specific questions:

Please post your timed queries in this forum.
Slide 14

Acknowledgement

The Spoken Tutorial Project is funded by NMEICT, MHRD Government of India.

The script and video has been contributed by Spoken Tutorial team.

This is Arvind pillai signing off. Thanks for joining.

Contributors and Content Editors

Nancyvarkey, Nirmala Venkat