|
DOCUMENTATION / ENTRY ADVANCED FUNCTIONS
|
|
See documentation related to creating a new entry to create a new "Receipt" and follow the steps below for cash application:
1- Select the customer from the customer drop down box or click on the "Find customer" button to find the customer 2- Select the cash account from the cash drop down box 3- Enter the receipt amount A list of unpaid or partially paid invoices will be populated in the grid on the right part of the screen. Do the following to apply cash on invoices: 1- in the "Amt Received" column enter the amount related to each invoice. if the whole invoice amount should be entered you can either check the box in the first column of that row or double click on the row of that invoice 2- To let ETAR automatically apply cash on the invoices based on their transaction date order, click on the "Auto Apply" button in the panel on the right side of the grid. With Auto Apply the cash will be applied to all existing unpaid invoices at the time of the entry as long as the receipt amount is greater than the total of these invoices. 3- If you would like to start over and reset all amounts entered, click on the "Reset" button in the panel on the right side of the grid Notes: - "Total Applied" is the total of cash entered in the "Amt Received" column (either manually or automatically) - "Total Unapplied" is the difference between the "Receipt" amount and the "Total Applied" |
|
Upload an Entry
|
In the "Journal Entry" or "Guided Entry" forms click on the "New" button then follow the instructions below:
- Click on the "U. File" button in the dark gray toolbar - The "EntryUpload" file will be populated with all GL accounts - Enter the GL account names in column A of the "EntryUpload" tab, or select the account name by clicking on the down arrow that appears when you click on any cell in this column - Do not enter the account IDs as they will be populated automatically with the included formula - Enter all debit amounts in the "Dr" column and all credit amounts in the "Cr" column. Don't enter an amount in both columns in the same row. Use one row for each amount type - Enter the line description if needed - Enter the Tax amount in column F only if you are uploading the file to "Guided Entry" form. "Dr" and "Tax" amounts should be entered in the same row in the respective columns - Do not enter any amount in column "Total". The formula will calculate the total - Save the file in a location on your computer - Go back to the entry in ETAR and click on the "Upload" button - A screen will pop-up where you can browse and select the file you saved earlier - The entry will be uploaded to the grid(s) - Validate the entry after entering any other details like transaction date, description, etc.. - After successfully validating the entry click on the "Save" button to save the entry Note: Please do not change the structure of the "EntryUpload" tab or delete any columns or rows or enter any value in all cells highlighted with the beige color |
|
Upload a Credit Card Statement
|
In the "Guided Entry" form, on the dark gray toolbar click on the "New" button and then click on the "Credit Card" button . In the Credit Card Upload form do the followings:
- Click on "U.File" to open and download the upload file (only if your credit card statement is not in the same format as the upload file) - Copy the Posted Date, Payee and Amount data from your credit card statement into the upload file (you can skip this step if your credit card statement is in the same exact format and column order as the upload the file in which case you can go directly to the next step) - Save the upload file (or the credit card statement) on your computer in either excel or csv format - Click on the "Upload" button and locate the upload file and click open - Your credit card transaction will be populated in the top grid, start assigning Expenses accounts to payees by selecting either the GL account name or number from the drop down boxes on the right of the top grid. You can assign the expense to a payee only once even if there are other multiple transactions from the same payee in the same statement - Click on the "Apply" button to apply the same selected expense account applied to a Payee to other transactions from the same Payee - Click the "Save" button to save your Payee to Expense mapping so the next time you upload a new credit card statement you don't need to assign the same Payee to Expense again - You can change the amount or you can deselect some transactions that you want to exclude from the entry by clicking the check box on that transaction in the first column - Click the "Ok" button and the Credit Card Upload form will close and the Guided Entry will be populated with the relevant expense accounts to the uploaded statement |
|