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.
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;
 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.
You can Add, Edit or Delete a Category by following the process described under Location Tab.
|
|
 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.
|
|
 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.
|
|
 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.
|
|
 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.
|
|
 Cash / Bank Ledger
|
|
 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.
|
|
 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.
|
|
 Reference Bank
|
|
 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.
|
|
 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.
|
|
 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.
|
|
 Agent / Broker
|
|
 Fill Outstanding Bills Detail
 : When you will click on , 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:
 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.
|
|
|
 Remark
 : You may input here any remark pertaining to the document.
|
|
 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.
|
|
 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.
|
|
 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
|
|
 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.
|
|
 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
|
|
 Add Delay Interest
 : If interest is paid due to delay in payment or any other charges is paid, Enter the amount here.
|
|
 Net Amount
 : After making addition / deletion as above, the net amount will be displayed here.
|
|
 On Account
 : This represents difference between amount actually received and Net amount adjusted as above.
|
|
 Total Payment
 : This represents total amount receivable after all adjustments.
|
|
 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.
|
|
 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
 : System will trace and fill the TDS section from the vendor master. You can make changes during this stage as well.
|
|
 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.
|
|
 Gross Amount
 : If you want to deduct the TDS on this payment, Enter the gross amount on which the TDS Amount will be calculated.
|
|
 TDS Section Rate
 : System will trace and fill the Rate % of the TDS section selected.
|
|
 TDS Amount
 : S ystem 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.
|
|
 Save Voucher
 : Click on the button to save the document prepared by you.
|
|
 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.
 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.
|
|
 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.
|
|
 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.
|
|
 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.
|
|
 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.
|
|
 Open Document
 : Click here to open an existing Bill Payment Voucher. Click here “Open a Document”, to know more about this utility.
|
|
 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.
|
|
 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.
|
|
 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.
|
|
 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!