Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview


Excerpt

The system has the option to upload an excel file that contains payment records, so that payments can be massively processed using this file.


Info

You will be able to download a template where the information required will need to be added prior to uploading the file.

The template contains the following columns:

  • Invoice #
  • Customer code
  • Payment Method
  • Date Paid
  • Discount
  • Amount Paid
  • Reference Number
  • Notes

    Download here an example of the file.


    Instructions

    Follow the steps below:

    Ui steps
    size
    Go to
    small


    Ui step

    Go to Account Receivables > Receive Payment.


    Ui step

    Click on the  "Receive Payment From Excel File" link.

    Image Removed


    Ui step
    This

     This will then take you to the screen where you download/upload the template.

    Download


    Ui step

     Download the sample excel file and update it. Remember that in multilocation companies, the Location code is required.


    Ui step
    Upload

     Upload it when you are done, by dragging the saved file to the dotted area, or clicking within the dotted area to search and select the file to upload.

    Image Removed


    Ui step
    The

     The company's accounting user that uploaded the file, will receive an email with the results of this upload. Successful and error messages will be provided within the email. 

    Image Added



    Panel
     
    title
    Relevant note
    Related Articles
    Panel

    Filter by label (Content by label)
    showLabelsfalse
    max10
    showSpacefalse
    cqllabel in ( "accounts-receivables" , "payments" )
    labelsaccounts-receivables, payments


    Ui text box
    sizemedium

    (lightbulb)Roles enabled to perform this action: Accounts Receivables,  Admin, Cashier.


    Info
    titleInformation

    Admins and Accounting have access to payment pages.

     



    We've encountered an issue exporting this macro. Please try exporting this page again later.