RisingERP - Sales Invoice

Sales Invoice

A Sales Invoice in RERP is a document sent to customers for payment against goods or services provided. It serves as an essential accounting transaction, updating receivables and recording income against a customer account upon submission.

To access the Sales Invoice list in RERP, navigate to: > Home > Accounting > Accounts Receivable > Sales Invoice

Sales Order Flow

Prerequisites Before creating and utilizing a Sales Invoice in RERP, it is recommended to set up the following first:

1. Item
2. Customer

Optional:

1. Sales Order
2. Delivery Note

1. How to create a Sales Invoice

Typically, a Sales Invoice in RERP is generated from a Sales Order or a Delivery Note. The customer's item details are automatically fetched into the Sales Invoice. However, you can also create a Sales Invoice directly, such as a POS invoice.

To automatically fetch details into a Sales Invoice, click on "Get Items from." The details can be fetched from a Sales Order, Delivery Note, or a Quotation.

For manual creation, follow these steps:

1. Go to the Sales Invoice list and click on New.
2. Select the Customer.
3. Set the Payment Due Date.
4. In the Items table, select the Items and set the quantities.
5. Prices will be fetched automatically if Item Price is added; otherwise, add a price in the table.
6. The posting date and time will be set to the current, and you can edit it after ticking the checkbox below Posting Time to make a backdated entry.
7. Save and Submit. New Sales Invoice

2.1 Additional options when creating a Sales Invoice Include Payment (POS):

If this invoice is for retail sales/Point of Sale. Is Return Credit Note: Tick this if the customer has returned the items.

2.2 Statuses

These are the statuses auto-assigned to Sales Invoice in RERP.

1. Draft: A draft is saved but yet to be submitted.
2. Submitted: The invoice is submitted to the system, and the general ledger has been updated.
3. Paid: Customer has made the payment, and a Payment Entry has been submitted.
4. Unpaid: Invoice is generated, but payment is pending within the payment due date.
5. Overdue: Payment is pending beyond the payment due date.
6. Canceled: The Sales Invoice is canceled due to any reason. Once canceled, its impact on Account and Stock is undone.
7. Credit Note Issued: The item is returned by the customer, and a Credit Note is created against this invoice.
8. Return: It is assigned to Credit Note created against the original Sales Invoice. Though you can also create a standalone Credit Note.
9. Unpaid and Discounted: Payment is pending, and any ongoing subscription has been discounted using Invoice Discounting.
10. Overdue and Discounted: Payment is pending beyond the payment due date, and any ongoing subscription has been discounted using Invoice Discounting.

3.Features

3.1 Dates Posting Date:

The date on which the Sales Invoice will affect your books of accounts, i.e., your General Ledger. This will impact all your balances in that accounting period.

Due Date: The date on which the payment is due (if you have sold on credit). The credit limit can be set from the Customer master.

3.2 Accounting Dimensions: Accounting Dimensions allow you to tag transactions based on a specific Territory, Branch, Customer, etc. This helps in viewing accounting statements separately based on the selected dimension(s).

Note: Project and Cost Center are treated as dimensions by default.

3.3 Customer PO Details Customer's Purchase Order: Track the customer's PO No. received, primarily to prevent the creation of duplicate Sales Order or Invoice for the same PO received from the customer. You can do more configuration related to customer's PO No. validation in Selling Settings. Customer's Purchase Order Date: The date on which the customer placed the Purchase Order. Purchase Order Details

3.4 Address and Contact Customer Address: This is the Billing Address of the Customer. Contact Person: If the Customer is a company, the person to be contacted is fetched in this field if set in the Customer form. Territory: A Territory is the region where the Customer belongs to, fetched from the Customer form. The default value is All Territories. Shipping Address: Address where the items will be shipped to. For India, the following details can be recorded for GST purposes. You can capture these details in the Address and Customer master, which would be fetched in the Sales Invoice.

1. Billing Address GSTIN
2. Customer GSTIN
3. Place of Supply
4. Company GSTIN

3.5 Currency: Set the currency in which the Sales Invoice order is to be sent. This can be fetched from the Customer master or preceding transactions like Sales Order.

Wish to select the customer's currency just for the reference of the customer, whereas accounts posting will be done in the Company's base currency only. Maintain a separate receivable account in the customer's currency. The receivable for this invoice should be posted in that currency itself.

3.6 Price List: If you select a Price List, then the item prices will be fetched from that list. Ticking on 'Ignore Pricing Rule' will ignore the Pricing Rules set in Accounts > Pricing Rule.

3.7 The Items table

Update Stock Ticking this checkbox will update the Stock Ledger on submitting the Sales Invoice. If you've created a Delivery Note, the Stock Ledger will be changed. If you're skipping the creation of Delivery Note, tick this checkbox.

Scan Barcode: You can add items in the Items table by scanning their barcodes if you have a barcode scanner.

Grant Commission: Grant a commission to Sales Person and Sales Partner on the net amount of this line item. If disabled, this line item will be ignored in the calculation of commission.

Item Code: The Item Code, name, description, Image, and Manufacturer will be fetched from the Item master.

Discount and Margin: You can apply a discount on individual items percentage-wise or on the total amount of the item.

Rate: The Rate is fetched if set in the Price List, and the total Amount is calculated.

Drop Ship: Drop Shipping is when you make the sales transaction, but the item is delivered by the supplier.

Accounting Details: The Income and Expense accounts can be changed here if you wish to. If this item is an asset, it can be linked here. This is useful when you're selling an asset.

Deferred Revenue: If the income for this item will be billed over the coming months in parts, then tick on 'Enable Deferred Revenue'.

Item Weight: The Item Weight details per unit and Weight UOM are fetched if set in the Item master.

Stock Details: The following details will be fetched from the Item master:

1. Warehouse: The Warehouse from where the stock will be sent.
2. Available Qty at Warehouse: The quantity available in the selected Warehouse.
3. Batch No and Serial No: If your Item is serialized or batched, you will have to enter Serial Number and Batch in the Items table. You are allowed to enter multiple Serial Numbers in one row (each on a separate line), and you must enter the same number of Serial Numbers as the quantity.

Item Tax Template: You can set an Item Tax Template to apply a specific Tax amount to this particular item.

References: If this Sales Invoice was created from a Sales Order/Delivery Note, it'll be referred to here. Also, the Delivered Quantity will be shown.

Page Break: will create a page break just before this item when printing.

3.8 Timesheet:

If you want to bill employees working on projects on an hourly basis (contract-based), they can fill out Timesheets which consist of their billing rate. When you make a new Sales Invoice, select the Project for which the billing is to be made, and the corresponding Timesheet entries for that Project will be fetched.

If your company's employees are working at a location and it needs to be billed, you can create an invoice based on the Timesheet.

SI Timesheet

3.9 Taxes and Charges:

The Taxes and Charges will be fetched from the Sales Order or Delivery Note.

The total taxes and charges will be displayed below the table.

Make sure to mark all your taxes in the Taxes and Charges table correctly for an accurate valuation.

Shipping Rule: A Shipping Rule helps set the cost of shipping an item. The cost will usually increase with the distance of shipping.

3.10 Loyalty Points Redemption

If the Customer is enrolled in a Loyalty Program, they can choose to redeem it.

3.11 Additional Discount

Any additional discounts to the whole Invoice can be set in this section. This discount could be based on the Grand Total, i.e., post-tax/charges or Net total, i.e., pre-tax/charges. The additional discount can be applied as a percentage or an amount.

Additional Discount in Sales Invoice

3.12 Advance Payment For high-value items, the seller can request an advance payment before processing the order. The Get Advances Received button opens a popup from where you can fetch the orders where the advance payment was made.

3.13 Payment Terms The payment for an invoice may be made in parts depending on your understanding with the Supplier. This is fetched if set in the Sales Order.

3.14 Write Off:

Write off happens when the Customer pays an amount less than the invoice amount. This may be a small difference like 0.50. Over several orders, this might add up to a big number. For accounting accuracy, this difference amount is 'written off'.

3.15 Terms and Conditions: There may be certain terms and conditions on the Item you're selling; these can be applied here. Read Terms and Condition documentation to know how to add them.

3.16 Transporter Information If you outsource transporting items to their delivery location, the transporter details can be added. This is not the same as drop shipping.

Transporter: The Supplier who will transport the item to your Customer. The transporter feature should be enabled in the Supplier master to select the Supplier here. Driver: You can add a Driver here who will drive the mode of transport. The details are usually fetched from the Delivery Note.

Delivery Note Transport

The following details can be recorded:

1. Distance in km
2. Mode of Transport whether road, air, rail, or ship. For India, GST:
3. GST Transporter ID
4. Transport Receipt No
5. Vehicle No The GST Vehicle Type can be changed
6. The Transport Receipt Date and Driver Name will be fetched.

3.17 Printing Settings

Letterhead:You can print your Sales Invoice on your Company's letterhead.

'Group same items' will group the same items added multiple times in the Items table. This can be seen when you print.

Print Headings Sales Invoice headings can also be changed when printing the document. You can do this by selecting a Print Heading. To create new Print Headings go to: Home > Settings > Printing > Print Heading.

There are additional checkboxes for printing the Sales Invoice without the amount; this might be useful when the item is of high value. You can also group the same items in one row when printing.

3.18 VAT Details

The following details can be set for VAT:

1. VAT Category
2. Invoice Copy
3. Reverse Charge
4. E-commerce VATIN
5. Print Heading

3.19 More Information

The following Sales details can be recorded:

1. Campaign: If this invoice is a part of an ongoing sales Campaign, it can be linked.
2. Source: A Lead Source can be tagged here to know the source of sales.

3.20 Accounting Details Debit To:

The account against which receivable will be booked for this Customer.

Is Opening Entry: If this is an opening entry to affect your accounts, select 'Yes'. i.e. if you're migrating from another ERP to RERP mid-year, you might want to use an Opening Entry to update account balances in RERP.

Remarks: Any additional remarks about the Sales Invoice can be added here. Accounting Details

3.21 Commission If the sale took place via one of your Sales Partners, you can add their commission details here. This is usually fetched from the Sales Order/Delivery Note.

3.22 Sales Team Sales Persons: RERP allows you to add multiple Sales Persons who may have worked on this deal. This is also fetched from the Sales Order/Delivery Note.

3.23 Automatically Fetching Item Batch Numbers If you are selling an Item from a Batch, RERP will automatically fetch a batch number for you if "Update Stock" is checked. The batch number will be fetched on a First Expiring First Out (FEFO) basis. This is a variant of First In First Out (FIFO) that gives the highest priority to the soonest-to-expire items.

Note that if the first batch in the queue cannot satisfy the order on the invoice, the next batch in the queue that can satisfy the order will be selected. If no batch can satisfy the order, RERP will cancel its attempt to automatically fetch a suitable batch number.

3.24 Point of Sale (POS) Invoices

Imagine a scenario where a retail transaction is taking place, such as in a retail shop. For instance, if you enable the POS checkbox, your Point of Sale (POS) Profile data is automatically retrieved into the Sales Invoice, streamlining the payment process.

Moreover, by selecting the "Update Stock" option, the stock is automatically updated without the necessity of creating a Delivery Note.

3.25 After Submission Upon submitting a Sales Invoice, the following documents can be generated:

1. Journal Entry
2. Payment Entry
3. Payment Request
4. Invoice Discounting
5. Delivery Note
6. Sales Invoice Submit

4. Accounting Impact:

 All sales must be recorded against an "Income Account," which corresponds to an account in the "Income" section of your Chart of Accounts. It is advisable to categorize your income by type (e.g., product income, service income). The Income Account needs to be specified for each row in the Items table.

Tip: To set default Income Accounts for Items, you can configure this in the Item or Item Group settings.

Another affected account is the Customer's account, automatically determined from the "Debit To" field in the heading section.

You can also specify the Cost Centers where your income should be allocated. Cost Centers provide insights into the profitability of different business lines or products. Additionally, you can set a default Cost Center in the Item master.

Accounting entries (GL Entry) for a typical double entry "Sale": When recording a sale (accrual):

1. Debit: Customer (grand total)
2. Credit: Income (net total, minus taxes for each Item)
3. Credit: Taxes (liabilities to be paid to the government)

SI Ledger

To review entries in your Sales Invoice after submission, click on "View Ledger."