You can export invoices from RSM InTime to your external accounts system.
You can export client invoices, self-bill invoices /wiki/spaces/ds/pages/51875309 and supplier invoices (where the invoices have been matched and accepted in InTime).
Your accounts system export will be configured by the Baker Tilly Revas RSM ESL support team for you.
You need to export invoices in order to close them off within InTime.
How do I export invoices to my accounts system?
- On the menu bar, select Invoicing > Sales/Pay > Search.
- Use the Choose the types of invoices you want to export with the tick boxes below
- Use any additional search criteria to search further filter for the specific invoices that you want to export. For example, you could The usual case is to set the Exported Status to No to display all invoices that have not yet been exported; then click Search.
- From the list, select the invoices that you want to export.
- Click Export.
Depending on which accounts system you are using, clicking Clicking export will initiate a system-to-system export, or enable the export process and provide you to download a CSV file to import into your accounts system.
What accounts systems are supported?
...
- System-to-System export:
- Twinfield (only Baker Tilly's own Twinfield)
- Access Dimensions
- Client Portal Reporting:
- Xero
- CSV download:
- Xero
- Sage 50
- Sage 200
Sage 50
We conform to the Sage CSV file structure (audit Trail Transactions)
Default export configuration is a line per pay element on the invoice. Other configurations are available.
Sample InTime Sage 50 export file - sage50_InTimeSample.csv.
Column | Field | Type | Size | Validation | Precision | Import Type |
A | Transaction Type | text | 2 | BP, BR, CP, CR, JC, JD, PA, PC, PI, SA, SC, SI, VP, VR |
| Standard/Extended |
B | Sales/Purchase/Bank Account Ref | text | 8 | Look up |
| Standard/Extended |
C | Nominal Code | text | 8 | Look up |
| Standard/Extended |
D | Department Number | Int | 3 | 1-999 |
| Standard/Extended |
E | Transaction date | Date | 10 | Date | Xx/xx/xxxx | Standard/Extended |
F | Transaction (invoice) ref | Text | 30 |
|
| Standard/Extended |
G | Transaction detail | Text | 60 |
|
| Standard/Extended |
H | Net Amount | Decimal | 11 |
| 8 digits + 2d.p | Standard/Extended |
I | Tax code | Int | 3 | T0-T99 |
| Standard/Extended |
J | Tax amount | Decimal | 11 |
| 8 digits + 2d.p | Standard/Extended |
K | Exchange rate | Decimal | 11 |
|
| Extended |
L | Extra Ref | Text | 30 |
|
| Extended |
M | Username | text | 32 |
|
| Extended |
Sage 200
- We can develop a Custom Invoice export to match a file specification you supply. (Quote subject to scope)
- System-to-System export:
- NetSuite
- Xero
- Access Dimensions
- Twinfield
- Export using Integration partner:
- Sage Intaact - Vision33