Then by clicking on the radio buttons “Use Latest Rates” or “Use Custom Rates”, you can either request the current exchange rate from the currency exchange rate provider or set your own custom exchange rates. First of all, you need to choose the report currency. If you need to generate this report in a specific currency your next step would be to select a Multi-Currency Converter. MULTI-CURRENCY CONVERTER (OPTIONAL FEATURES) And provide the name of the template in Template Name field, for instance, Template Name 1. You can also provide the start cell, for instance, A1. You can also use the cell reference (the icons next to “To” and “From” fields) to set up the custom dates from your google sheet.Ĭhange Pull Settings allows you to perform the following operations: You also have the ability to set up the Static Date Range To and From For your convenience, there are pre-populated values such as This Month, This Quarter, This Year, Last Month, and so on. The report data will be calculated based on the selected Date Range. You have the ability to set up the Dynamic Date Range. There are required and optional attributes for the Actual vs Budget report. G-Accon for Xero provides the ability to set up the Date Range for your data manually or you can refresh your data dynamically. Select the Actual vs Budget option from the drop-down menu. #How to design a template for the report? Then you need to select from the menu Extensions -> G-Accon for QuickBooks -> Standard Accounting Reports -> Actual vs Budget.Įxport Actual vs Budget into Google Sheets ![]() To generate the accounting report from QuickBooks, you need to be logged in to QuickBooks. ![]() ![]() Export Actual vs Budget Report into Google Sheets SECTIONS IN THIS ARTICLE
0 Comments
Leave a Reply. |