Purpose of Uploading a List of Invoices into Decipher
For use when clients provide a list of invoices and you'd like to create an AR Aging Summary. When clients don't connect their financials directly, they can submit a list of invoices as an attachment which you can process in the Accounts Receivable area so that Decipher can automatically generate an Aging Summary. Follow the Steps below to create an AR Aging Summary from a list of invoices. 

💡 Tip: It helps to have the File Open so you can refer to it during the Upload. Locate and open it then proceed to the steps below.

➡️ Step 1: Navigate to the Accounts Receivable Tab for the desired client.  The location of this tab may vary on your application and it could also be under the Financials category. 

Step 2: Click on AR Aging Report

Step 3: Click Upload. 

​Step 4: Select one of the Choices.
​Documents = Select from one of the documents submitted by the Applicant during the process of applying. The file is stored in Decipher as part of the client's information.
​Upload File = Select a file from your computer.
​Data Entry = Manually enter the information yourself (manual data entry)

Step 5: If you click on Documents, choose the correct file from the files displayed. If not visible select "All Documents" to see the list and select the document with lost of invoices. Click Next.

Step 6: Select/Fill in the Information and click Next.
​Header Row: Type in a "1" usually the default place for Decipher to locate the start of data in a spreadsheet.
​Worksheet Name: Select the correct worksheet. The excel file may have multiple sheets.

Step 7: Match the correct categories in the spreadsheet with the categories on the screen by selecting each. Target is Decipher's category and Source is the title of the category on the spreadsheet. If you have questions, refer to the list of invoices.  

​Step 8:  When done, click Next to Preview the Data before uploading. If something isn't correct click "Previous" to go back and make corrections. If correct, Click Upload.

🎉 Success! The AR Aging Summary will now we displayed. Select various views such as Invoice Date, Due Date, historical time periods, and even view detailed invoices and download them to excel. 😁

💡TIP: Issues with information not uploading correctly? If the file you used to upload is a PDF, check to ensure that all of the numbers are correct and there aren't any extra decimals in the data. Decipher uses optical character recognition to decode image and PDF files and sometimes marks/smudges etc. can be interpreted as dots or decimals and can skew the numbers. You can click into the numbers displayed to ensure there are no incorrect decimals being interpreted and correct them. If you are still having issues, contact our team and please provide the file so we can examine it.