![]() ![]() Don’t forget to mark as ‘No’ for journals which are not required during this reporting period. ![]() The other columns are optional and can be used depending on what information needs to be posted/imported.Ĭhange to ‘Yes’ if you want to post the row details to your accounting software. Mandatory fields must be filled in to successfully push a row to the accounting software - these are also marked with a white star in the template. This template does not allow the use of Memos. To effect this, please select ‘Yes’ under Upload Sheet column and make sure that the respective supporting sheet name is identical to the JOURNAL NUMBER field in the template. You can upload a supporting working as an attachment for each Journal. Since each row is a transaction the total Debit and total Credit amounts need to be equal. Select ‘Delete’ if you wish to delete the journals. In the POST column, select ‘Yes’ if you want to post directly to Quickbooks. Only those marked with a ‘Yes’ will be POSTed. Important notes to be aware of when using this template:Įach row in the template represents a transaction line. Downloading the template from the library.It is recommended to familiarise yourself with the following articles: Scenarios When This Template Could be Used.Learn how to create and edit QuickBooks journals directly from Excel.
0 Comments
Leave a Reply. |