Smart receipts12/28/2022 ![]() SMART RECEIPTS PCIf you now click on the worksheet Tab Form, you will see all of the data is now on the PC Import Template that can be uploaded to the Moneypenny Software. Make sure that you do not copy over Column I. Then open the Excel file PC_Template using Smart Receipts (Production Accountants would have received this previously from Moneypenny) and click on the worksheet tab DATA DUMP and paste the data in cell A4. What you now need to do is copy the cells with the information, so for example in this case copy A2-G2. Open the CSV file that was sent to you and you will see the following: If not, forward these files onto the Production Accountant. If you have been given Account Codes to use with your Petty Cash reports, then you can do the next step. The click the Send button and this will allow you to email these files to yourself or the Production Accountant. SMART RECEIPTS PDFWe need to add one more column to the CSV file, click on the + on the top right hand corner and then Select Comment (as below) and then click done.Ĭlick on Generate and select CSV File (contains the information to import into PC template file) and PDF Report – No Table (a PDF report of all the photos taken of the receipts). Once the columns are in the order required click Done (bottom right hand corner. The columns need to be placed in the following order: What you need to do is edit the order of the columns, this is done by clicking on the icon indicated below and move the item up or down then release. To edit, click on Edit in the bottom right hand corner.Īfter you have clicked Edit the screen will appear as below. This will show you how the CSV is currently setup. Scroll down to you come to the section Customize CSV output and then click on Configure CSV Columns. The following menu will appear, select Settings On the top left hand corner you will see three circles in a row (as indicated below), click on this You will need to customise the CSV report in Settings before you export the CSV file. a refund for a return item) then when you go to enter in the price, to enter a negative sign just click on the button “, –, +” (indicated below) twice for the “-” to appear in the price field.Īt the end of the expense report period, you now need to generate the report and send it to the Production Accountant. ![]() If you need to enter a negative receipt (i.e. A list of all receipts lodged on the expense report will appear. Once details are enter, click the tick button and the record will be saved. Price – how much it cost (including GST where applicable)Ĭategory – this is not use in Moneypenny so can leave as whatever it automatically selectsĬomment – please enter the name of the supplier/store the item(s) was purchased from Name – the item which you purchase as much detail as possible You can now enter in the details of the receipt. Take a photo of the receipt and if you are happy with the results click OK These expense reports could be a weekly or daily report depending on how often you lodged with the Production AccountantĮnter the name for the expense report, the start and end dates and what the currency is and this click the tick button at the top.Ĭlick on the + button and then select Image/Picture When the app is open for the first time, you will see the following message.Ĭlick on the + (plus) button to create a new Expense Report. SMART RECEIPTS INSTALL
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |