×
Menu
Index

Bill Payment

 
Welcome to AlignBooks. We are happy to have you on board. In this help studio tutorial, we will explore the Vendor Payment preparation options.
 
Before we begin, let us understand about the need of Vendor Payment Entry and the relevance of this particular activity.
 
The basic purpose of Vendor Payment Entry is to account for the payment made to the Vendor and to generate a payment voucher.
 
AlignBooks has made this module more useful for you by providing following additional utilities:
 
·     If you are maintaining and tracking bill wise outstanding of Vendors, you can adjust the bill(s) against which this particular payment is made.
 
·     If you have made any deduction from total amount payable against any bill e.g. cash discount, TDS and Bank Charges, you can adjust the same without the need to pass any additional adjustment vouchers.
 
·     If are making any interest payment towards delay of payment, you can account for this interest without the need to pass any additional adjustment vouchers.
 
·     If there is any Currency fluctuation difference (in case of foreign dealings) the system will automatically calculate, adjust and account for the same without undergoing through any additional adjustment vouchers.
 
 
You can create a Bill Payment under Module in AlignBooks.
 
The key functions of Bill Payment Module are:
·     Creation of a New Bill Payment,
·     Modification of an existing Bill Payment;
·     Deletion of an existing Bill Payment.
 
 

Configuration

AlignBooks provide you the facility to configure your Bill Payment documents with respect to choice of linking with parent document, choice of maintaining multiple series of documents, choice of sending Email and SMS on creation/edit/approval of the document and for Approval System setting etc. Click on button to configure this document. Click here  “How to Configure a Document”,  to know more about this utility. 
 
Once you finish up with the configuration of the document you can start creating the Bill Payment.
 
 
Bill Payment
 
Let’s now understand how to create a new Bill Payment in simple steps
 
You have three ways to prepare a Bill Payment;
·     Enter fresh data for the first time;
·     Open an existing document and use the “Copy” feature of AlignBooks to make the necessary changes. This will save your time and efforts;
·     If you have data in an Excel Format, Import data and make the required changes.
 
 
Let’s learn how to enter the fresh set of data for the first time for creating this sort of document;
 
1

Location / Branch

1. Location / Branch: Under this field, You can select the location, if you are handling Multi Locations. System will ask for this information only if you have configured Multi Locations - "ON” under General Setup and System will fill the default Location if you have configured the Default Location under Data Access Rights. 
If your desired Location does not exist in the menu, you can create a New Location by clicking on  option within the dropdown menu. You can also Edit or Delete a Location from Here. Select a Location to be edited / deleted and then click on . The Location will be opened in Edit mode and you can edit it and save by click on  . You can delete it by click on 
2

Category

2. Category: If you are want to classify your document in different categories, select the applicable category from the drop down menu. For Example if you want to maintain brand wise classification of Invoices you can create brand names in category.
This field is available only if you have configured Document Classification – "ON” in Purchase Setup
You can Add, Edit or Delete a Category by following the process described under Location Tab.
3

Receipt Date

3. Receipt Date: Enter the date which you wish to reflect in the document. By default, the system will take the current date. You can also pick a different date by just clicking on the calendar function.
4

Voucher No

4. Voucher No: System will generate voucher number based on the Voucher Numbering configuration, if you have opted to maintain "auto prefix” and “auto numbering”.
Prefix :  While configuring your document, if you have opted to “maintain manual prefix”, select a prefix from the drop down list. If the required prefix does not exist in the list, you are able to create a new one by clicking on   Icon or  option within the dropdown menu and input a name. This field will not be available if you have opted "Not required".
Number:  While configuring your document, if you have opted to “maintain manual numbering”, enter a document number here.
5

Vendor

5. Vendor: Under this field, Select a Vendor from the drop down list for whom you are preparing payment. 
You can Add, Edit or Delete a Vendor by following the process described under Location Tab.
6

Email

6. Email: System will auto pull the email Id from vendor master. If you wish to change the same, you can do that here.
If you have configured enabled to send Email in Document Configuration and this field is blank then system will not Email to vendor.
7

Cash / Bank Ledger

7. Cash / Bank Ledger : Select the Cash or Bank account where the payment is booked /withdrawn. If the required Cash /Bank GL does not exist in the list, you can create a new one by clicking on   Icon or  option within the dropdown list and input the same.
8

Amount Received

8. Amount Received: Enter the amount paid. If the payment made is in a currency other than your own currency, enter the amount paid in that currency without converting it in your own currency. For example you have paid $1000, you should enter 1000 here.
9

Cheque No

9. Cheque No: Enter the cheque or other instrument number (if applicable). If payment is made through RTGS/NEFT you can enter RTGS/NEFT reference number.
10

Reference Bank

10. Reference Bank : Select the Bank Name (from which payment is made) from the drop down list. If the required Bank does not exist in the list, you can create a new one by clicking on   Icon or  option within the dropdown list and input the same.
11

Dated

11. Dated: Enter the cheque date, if applicable. By default, the system will take the current date. You can also pick a different date by just clicking on the calendar function.
12

Currency

12. Currency: If you are payment made in a foreign currency, select a Currency from the drop down menu.
This field is available only if you have configured Multi Currency : "ON” in General Setup. If your desired currency does not exist in the menu, you can add a new currency by clicking on   Icon or option within the dropdown menu.
13

Conversion Rate

13. Conversion Rate: Under this field, System will automatically get the conversion rate from currency master, if already created by you. If you wish to change the currency conversion rate for this  particular document, you can do the same here.
14

Fluctuations

14. Fluctuations: This represents currency rate difference arising due to timing gap between the Invoice and payment date.
For example – Your base currency is INR and you made an Invoice for $ 41625 on 01/01/2017 and rate of $ on that date was INR 30. So you have booked your bill for INR 12,48,750 i.e. 41625 x 30. Now you received payment on 15/01/2017 and rate of $ vs INR on that date was 31.50 and accordingly bank has credited your account by INR 13,11,187.50. In such circumstances in your books of account you will credit your Vendor by $ 41625 (INR 12,48,750) and balance of INR 62,437.50 will be directly credit to Fluctuations difference account.
 
Once you adjust the payment made towards the bill(s) against which payment is made, the system will automatically pick the rate of conversion of those bills, calculate the fluctuations difference and will account for in default GL set at the time of company configuration.
15

Agent / Broker

15. Agent / Broker: System will auto pull the Agent Name from vendor master. If you wish to change the same, you can do that here. If the required agent does not exist in the menu, you can create a new by clicking on  Icon or  option within the dropdown menu. 
This field is available only if you have configured Agent wise Billing : "ON” in Sales Setup
16

Fill Outstanding Bills Detail

16. Fill Outstanding Bills Detail : When you will click on 16. Fill Outstanding Bills Detail, the system will display all the unadjusted Debit / Credit entries of the selected vendor, for selected Branch (If applicable) and for selected currency (if applicable).
 
Before adjusting the bills, let us understand each columns of display list:
 
17

Bill Detail Grid

You can adjust the amount paid against the bill Number in adjust Now column and cash discount (if applicable).
 
Once the document amount is equal to amount adjusted, next time the document will disappear from the outstanding list and the Outstanding Report generated thereafter will help you in proper payment schedule and effective control.
 
Column Name
Description
Bill No
Here the unadjusted bill/invoice numbers are displayed.
Bill Date
Here the bill/invoice date is displayed.
Debit / Credit
Here the Debit / Credit will display based on the voucher type.
Bill Amount
 
Here Bill/invoice Amount is displayed. If your bill is in foreign currency this column will appear twice i.e. one showing the Bill Amount in base currency and other showing bill amount in foreign currency.
Outstanding
Here the net outstanding amount i.e. Invoice amount less amount
already adjusted earlier against this bill/invoice, is displayed. If your bill is in other than base currency this column will appear twice i.e. one showing the outstanding in base currency and other showing outstanding in foreign currency.
Adjust Now
Here you have to enter the amount to adjust against this Bill/invoice out of the present receipt.
Cash Discount
If you have allowed any cash discount against this document, enter the cash discount amount.
Net Receipt
The system will display the net receipt i.e. Amount less Cash Discount.
Due Date
Here payment due date is displayed
Reference No.
Here document reference number is displayed.
Reference Date.
Here reference document’s date is displayed.
Bill Branch
Here document branch is displayed.
Bill Sub Party
Here Sub Party Name is displayed.
 
18

Remark

18. Remark: You may input here any remark pertaining to the document.
19

Attachment

19. Attachment : You may upload any supporting documents, which can be used for the future reference. For example, you may scan and attach a copy of Inward remittance receipt. You can browse the location to find the document and attach the same.  Click on “X” to remove the attachment.
20

Attribute

20. Attribute: This field is available only if you have selected to use Attributes in Finance Setup and the a GL where attribute is linked is effected by this document. For Example if you have allocated an attribute with GL “Bank Charges” and an amount is going to be debited / credited by creation of this document, the system will ask to select an attribute to be linked with Bank Charges.
21

Total Bill Amount

21. Total Bill Amount: Based on the data filled in the table, system will calculate the total amount adjusted against various Bills / DN / CN / Payments, and will display here
22

Less Cash Discount

22. Less Cash Discount : Based on the data filled in the table, system will calculate the total cash discount allowed in various documents, and will display here.
23

Less TDS Deducted

23. Less TDS Deducted : If you want to deduct TDS out of this payment, Enter the relevant details in TDS section at the right bottom of this document, the system will take the TDS amount from there and will adjust and display here
24

Add Delay Interest

24. Add Delay Interest: If interest is paid due to delay in payment or any other charges is paid, Enter the amount here.
25

Net Amount

25. Net Amount: After making addition / deletion as above, the net amount will be displayed here.
26

On Account

26. On Account: This represents difference between amount actually received and Net amount adjusted as above.
27

Total Payment

27. Total Payment: This represents total amount receivable after all adjustments.
28

Less Bank Charges

28. Less Bank Charges: To make this payment, if you incur any bank charges and wish to recover the same from the party, enter the amount here.
29

Net Bank Impact

29. Net Bank Impact: This represents the actual outflow in the Bank after deducting Bank Charges. The on account payment will appear in the windows of unadjusted payments against the Vendor Payment number and can be adjusted at later stage.All the adjustments made above i.e. cash discount, TDS Deducted, Interest paid, Bank Charges and fluctuation gain/loss shall be posted directly in respective default ledgers as defined by you at the time of Company Setup.The system will not accept the over adjustment of Bills i.e. negative on account.
 
 

TDS Section :

This section will be available if the TDS Applicable : "ON" in Finance Setup. This section will be available if the TDS Applicable : "ON" in Vendor Master.
 
30

TDS Section

30. TDS Section: System will trace and fill the TDS section from the vendor master. You can make changes during this stage as well.
31

TDS Ledger

31. TDS Ledger : System will fill the Default ledger for TDS Payable which is mentioned in Default Ledger in Finance Setup. You can make changes during this stage as well.
32

Gross Amount

32. Gross Amount : If you want to deduct the TDS on this payment, Enter the gross amount on which the TDS Amount will be calculated.
33

TDS Section Rate

33. TDS Section Rate : System will trace and fill the Rate % of the TDS section selected.
34

TDS Amount

34. TDS Amount : System will calculate the TDS Amount automatically i.e. with the multiplication of Gross Amount x Rate %. and transfer the TDS amount in TDS Decucted field above.
35

Save Voucher

35. Save Voucher : Click on the button to save the document prepared by you.
36

Print Voucher

36. Print Voucher : Click on this button to save voucher and Print the document prepared by you. Click here  “Print Utility”, to know more about this utility.
 
 
You have completed creation of New Bill Payment Voucher. 
 
37

Clear Detail

37. Clear Detail : Before clicking this option make sure that the data entered is no more required by you; the moment you click on this option the system will erase all the data and give you an empty screen to enter fresh data.
38

Mail / SMS

38. Mail / SMS : Click on this Button, If you want to send a Email (with Attachment). Click on  beside Mail and click on Email Link (Email with Link included for Document Print) or click SMS.
39

Schedule Document

39. Schedule Document : If you want to create a schedule for this document, click on . Click here  “Schedule a Document”,  to know more about this utility.
40

Document History

40. Document History : Click here to know the History of the Document for date and time of creation / modification / delete / cancel / restore. This button will be active only when document is open an existing document and when Manage Document History : “ON” in General Setup.
41

Import Voucher (Excel File)

41. Import Voucher (Excel File) : Click on this button to Import Data and select a file from which Data is to be imported. Click here “Import Utility”, to know more about this utility.
42

Open Document

42. Open Document : Click here to open an existing Bill Payment Voucher. Click here  “Open a Document”,  to know more about this utility.
43

Delete Document

43. Delete Document : If you wish to delete any existing Bill Payment Voucher, open an existing voucher and specify the reason for delete in "Edit Remark" field then Click on this button to delete the Voucher.
44

Copy Document

44. Copy Document : Click here to copy the values from an existing Bill Payment Voucher. Click here “Copy from a Document”,  to know more about this utility.
45

Cancel Document

45. Cancel Document : If you wish to cancel any existing Bill Payment Voucher, open an existing voucher and specify the reason for cancel in "Edit Remark" field then Click here   to Cancel the Voucher. when you cancel a document then document status will update as "Cancel" and All financial / stock impact (whichever applicable) will reverse for this voucher.
46

Restore Document

46. Restore Document : If you wish to restore any existing Bill Payment Voucher, open an existing voucher and specify the reason for restore in "Edit Remark" field then Click here to Restore the Voucher. when you Restore a document then document status will update as "Open" and All financial/stock impact (whichever applicable) will be restored for this voucher.
 
 
We hope you enjoyed this tutorial. Please give us a call for further help.  Happy Aligning!