Manual Upload - S
The Manual Upload Data (S) sheet enables you to manually enter data related to input and output transactions and populates that data into the respective sheets. This is a standard sheet in the pack and can be located in the navigator panel under
Source Data
.By default, Manual Upload - S contains three where manual data can be entered. The fields you can enter are:
- Description (free text)
- Tax Code description (drop-down menu of AP and AR transaction types)
- Date (free text)
- Amount Net (free text)
- Amount Tax (free text)
- Adjustment (check box)
- Irrecoverable percentage override (free text)
- Number of items (free text)
To insert additional rows in the Manual Upload Sheet (S), select the insert icon in the toolbar and select
Insert Row
.Data Flow
If the source sheet already exists in the file, enter the adjustment and move to the next row to insert adjustment details in the row. However, if the source sheet does not exist, insert the sheet and then enter the adjustment in the Manual Upload Sheet. The entries are then pushed to the respective sub-sheets (I, N, and O).
Audit Trail
- Last User Updated: Displays the last user to update a transaction.
- Last Date Updated (UTC): Displays the last time and date (in Coordinated Universal Time) that a transaction was updated.
Typically, the information these audit trails display relates to when the Amount Net for the transaction was last updated. However, for Reverse Charge – Output Only transactions the information these audit trails display relates to when the Amount Tax or Output Tax for the transaction was last updated.
In this example, the
Last User Updated
is an Administrator and the Last Date Updated (UTC)
is 10/09/2018 on the Manual Upload Data sheet.
Related Content
-
Adjustments
Format:
Article,
1 min read