Learn Ragic
How can we help?
Full Site Search

Integrated Accounting Template with PSI: Accounting and Financial Reports Made Easy

ade Easy

Are you already using Ragic to manage PSI but can’t get around to doing the same for your finances? Have you tried to build it yourself but ran into a wall? Well worry no more! The integrated Accounting Template is finally online! This article will take you through setting up and using the accounting template step by step!

Before You Begin: Installing the Accounting (Integrate with PSI) Template

For those of you who have not installed the Accounting (Integrate with PSI) template, you can find it in the Accounting category on the Install Template page. Click GET to install. After downloading, Ragic will automatically create a tab with the template. The Accounting (Integrate with PSI) is free as long as you don’t change the design, so don’t worry.

First, a simple explanation of how the Accounting (Integrate with PSI) relates to the PSI template (Sales Order Management, Inventory Management, and Purchasing). The Accounting (Integrate with PSI) template is divided into three major parts:

1. Basic information, which includes "Employee Payroll" and "Asset Management" sheets in the figure below. We recommend that you compile the latest data and import it into the database.

2. Bills and Invoices, which include "Product Invoice", "Other Invoice", "Material Bill", and "Other Bill" sheets. Of the above, "Product Invoice" and "Material Bill" sheets can be created through convert record action button from the "Delivery Note" sheet under the "Sales Order Management" tab, and the "PO Receipt" sheet under the "Purchasing" tab, respectively.

3. Accounting: which includes "Journal Entry" sheet and accounting reports.

The following description is based on the above division. If you find that your company doesn’t require such a complex tool to manage, you can also think about using the Accounting Lite template.

Entering Basic Information

To better manage information such as assets and employee payroll, the first step is entering the existing information into the system. We'll walk you through in a minute. If you already have a complete list, you can also consider directly importing data from your files.

Employee Payroll Management

Different companies have different ways of calculating payroll items such as salary bonuses, overtime pay, and labor/medical insurance, and there's no universal formula available that works in every situation. Therefore, the "Employee Payroll" sheet only records the amount paid in subtable.

To facilitate management and report generation in the future, we recommend filling in the "Payment Date" field in the YYYY/MM format, e.g. 2018/07 for 07/2018. (The payroll information entered here still needs to be entered in the “Journal Entry” sheet manually.)

Asset Management

Aside from regular product/service transactions, does your company purchase assets and need to record depreciation? If so, you can record such information in the "Asset Management" sheet and update it at regular intervals.

In the future, when you need to look up the value of a specific asset, you'll have it all in one place! (The depreciation information entered here still needs to be entered in the "Journal Entry" sheet manually.)

Invoices and Bills

After entering the basic information, the second part is about bills and invoices.

Invoice

Invoices in the integrated template can be subdivided into “Product Invoice” and “Other Invoice”.

Product Invoice

The source of a “Product Invoices” entry is a “Delivery Note” entry in the “Sales Order Management” template. In other words, these are invoices generated from selling products. Select any “Delivery Note” entry and click on the “Create Product Invoice” convert record action button in the bottom right corner.

Once that’s done, the system will automatically generate an "Product Invoice" entry based on the information in the "Delivery Note" entry.

Other Invoice

The other type of invoice is not generated from selling products, but rather from offering special services or selling equipment. These are not invoices generated in the regular sales process, so they are collected in the “Other Invoice” sheet.

In this sheet, click on the +New button on the top left to create a new entry. When editing the record, you can select an existing customer from the “Accounts” in the “Sales Order Management” template, then enter the details relating to the sale.

Payment Management in Invoice

Scroll down to the bottom of both "Invoice" sheets to see the payment information fields.

When payment has been received from the customer, you can directly record information such as the payment date and by whom it is received. Cash, check, or wire transfer are available as options for payment type. The system will display different fields depending on the type of payment method you have selected.

If you want to find invoices with outstanding payments, you can use the “Overdue Invoice” report in the "Report" tab to locate it.

Bill

Bills in the integrated template can be subdivided into "Material Bill" and "Other Bill".

Material Bill

The source of a "Material Bill" entry is a “PO Receipt” entry from the “Purchasing” template. These are bills generated when purchasing products or materials. Select any “PO Receipt” entry in the “Purchasing” template and click on the “Create Material Bill” convert record action button in the bottom right corner.

Once that’s done, the system will automatically generate a "Material Bill" entry based on the information in the "PO Receipt" entry.

Other Bill

The other type of bill is not generated from purchasing products or material, but rather from expenses arising from special services such as cleaning fees or equipment repair fees. These are not bills generated in the regular purchasing process, so they are collected in the “Other Bill”.

In this sheet, click on the +New button on the top left to create a new entry. When editing the record, you can select an existing customer from the “Vendors” sheet in the “Purchasing” template, then enter the details relating to the purchase.

Payment Management for Bills

The payment management process for bills is very similar to that for invoices. In the lower part of both "Bill" sheets, there's also a section for managing payment information.

When you have confirmed payment for the bill, you can directly record information such as the payment date and by whom it is processed. Cash, check, or wire transfer are available as options for the payment type. The system will display different fields depending on the type of payment method you have selected.

If you want to find bills with outstanding payments, you can use the “Overdue Bill” report in the "Report" tab to locate it.

Accounting

Accounting Title

Currently, the most commonly used accounting titles are provided in default.

If you don't need all of these titles when creating a "Journal Entry", you can uncheck the "Enabled?" field, and it will no longer show up when you are writing your journal entry. That's time saved from sifting through titles! Conversely, if there are titles that you use that aren't listed, you can also add them manually.

Please note that when you manually add a new accounting title, you need to select the first, second, and third grade codes according to the system default since it affects the generation of accounting reports later on. You should only set the fourth grade titles on your own. Please add the fourth grade titles according to the following format.

xxxx-Account Titles

For example: “1111-Cash on hand”.

Frequently Used Journal

You can create entries for common journal entries here, with appropriate credit or debit titles. Then, you'll be able to select from these entries when creating invoices or bills. For example:

Journal Entry

If the company has the need for creating financial statements, it can be composed by completing records in the "Journal Entry" sheet of the template. The template provides two ways of creating journal entries:

Method 1: Manually log in the journal entry

First, select the appropriate accounting title and type in the debit or credit amount.

Then, select "Product Invoice", "Other Invoice", "Material Bill", "Other Bill", or upload associated documents. You only have to fill one field for each row in the subtable! Note that the popup window only lists the bills or invoices without a voucher number. If the bill or invoice you are looking for has already been referenced in other vouchers, you have to click the Clear Filter button on the top to find the documents that have already been referenced.

Method 2: Create via "Create Journal Entry" action button

In any entries of the invoices or bills, you can fill in the "Journal Name" field and click on the "Create Journal Entry" button to create a journal entry":

If you don’t have the button mentioned above on your sheet, please refer to this article.

Voucher Details and Document Details

These two sheets were generated for data linking purposes. To avoid overwriting by accident, everything here is set to read-only by default! If you need to add or remove data, please update them from the "Journal Entry" sheet. If you don't want users other than SYSAdmin to see these two sheets, you can turn off the access rights for all user groups for the two sheets, just don't delete them!

Upgrade to Professional to Create a System Tailored for You

Approval Flow

If any sheets need to be reviewed by a manager before the process can continue, you can consider adding an approval flow.

Complex Payroll Calculations? Not a Problem!

If your organization has a rather complex way of calculating payroll, we recommend using new sheet from subtable to create a new sheet from "Employee Payroll" sheet. You can perform the detailed calculations for the compensation in the new sheet, then display the final result in "Employee Payroll" sheet to keep it clean, concise, and free of clutter.

Never Miss a Payment with Reminders

If you're worried about missing bill deadlines, you can consider setting a reminder for the due date. Once you have the reminder set up, the system will automatically E-mail you a notification according to your setting.

Reordering Sheets to Suit Your Needs

You can rearrange your sheets' order in sheet manager.

Top of Page

    Start Ragic for Free

    Sign up with Google