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 historyrecords, so that payments can be massively processed using this file.


Info

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

The template contains the following fields:

  • 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:

    Go to
    Ui steps
    sizesmall


    Ui step

    Go to Account Receivables > Receive Payment.

    Select


    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.


    Ui step
    Update

     Download the sample excel file and update it.

    Upload

    Remember that in multilocation companies, the Location code is required.


    Ui step

     Upload it when you are done

    .
    Image Removed

     

    Relevant Articles

    panel

    , by dragging the saved file to the dotted area, or clicking within the dotted area to search and select the file to upload.


    Ui step

     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
    titleRelated Articles

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


    Noteui-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.