--- title: "Import Historical Sales and Entrees for Use in Forecasting" slug: "import-historical-sales-and-entrees-for-use-in-forecasting" description: "Import historical sales and entree data to seed weekly forecasting. Covers permissions, import steps, and correcting failed rows." updated: 2026-02-04T00:23:50Z published: 2026-02-04T00:23:50Z canonical: "docs.restaurant365.com/import-historical-sales-and-entrees-for-use-in-forecasting" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt > Use this file to discover all available pages before exploring further. # Import Historical Sales and Entrees for Use in Forecasting To create [forecasting projection dates](/doc/docs/forecasting#review-projection-dates) for periods before POS polling was enabled for a location, import historical sales and entree data on the [Forecasting page](/doc/docs/weekly-forecasting-forecasting-page). Data is imported using a standardized template, with each row covering a 15-minute interval for a specified date. > Polled data is not affected by historical forecasting imports, and imported historical sales used in forecasting will not appear in the DSS. > [!WARNING] > For forecasting projection dates, imported sales and entree data replaces existing data for the same interval. > > Repolling POS data **does not** change projection dates with imported data. --- ## Security Users with the following permission can import historical sales and entree data: - Sales & Cash → Forecasts → Weekly Forecasting → Import Forecasts These permissions can be added to [custom user roles](https://restaurant365.us.document360.io/doc/docs/custom-user-roles) or [individual users](https://restaurant365.us.document360.io/doc/docs/users-overview-and-security). The [Permission Access report](https://restaurant365.us.document360.io/doc/docs/generating-a-permissions-access-report) can be used to determine which user roles or users already have these permissions assigned. For more information, see [User Setup and Security](/doc/docs/user-setup-security-and-location-access). --- ## **I**mport Historical Sales and Entree Data Follow these steps to import historical sales and entree data for use in forecasting: *Click steps to expand for additional information and images.* ****1)** Navigate to the [Forecasting page](/doc/docs/weekly-forecasting-forecasting-page).** 1. Select **Sales & forecasting** from the left navigation rail. 2. Select **Forecasting.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-D1LSLA0C.png?sv=2026-02-06&spr=https&st=2026-11-10T17%3A10%3A05Z&se=2026-11-10T18%3A10%3A05Z&sr=c&sp=r&sig=IBw9QvukwRi43PZBcZrpqL25CjYv9%2FNisABu291WATQ%3D) ****2)** Open the **three dot menu** at the top of the page, then select **Import historical sales & entrees**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-EOYLUL71.png?sv=2026-02-06&spr=https&st=2026-11-10T17%3A10%3A05Z&se=2026-11-10T18%3A10%3A05Z&sr=c&sp=r&sig=IBw9QvukwRi43PZBcZrpqL25CjYv9%2FNisABu291WATQ%3D) ****3)** On the Import Sales & Entrees Template screen, click **Download Template**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-9H67235D.png?sv=2026-02-06&spr=https&st=2026-11-10T17%3A10%3A05Z&se=2026-11-10T18%3A10%3A05Z&sr=c&sp=r&sig=IBw9QvukwRi43PZBcZrpqL25CjYv9%2FNisABu291WATQ%3D) This will download the template file as a .csv. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-N9X0TOVI.png?sv=2026-02-06&spr=https&st=2026-11-10T17%3A10%3A05Z&se=2026-11-10T18%3A10%3A05Z&sr=c&sp=r&sig=IBw9QvukwRi43PZBcZrpqL25CjYv9%2FNisABu291WATQ%3D) ****4)** Enter **historical sales and entree data for each 15-minute interval** in the downloaded template.** **Template Columns** - **Location ID** - Location name or number, as it appears on the [location record](/doc/docs/legal-entities-location-record). (Required) - **Datetime** - Date and start time of each 15-minute period (00, 15, 30, or 45). (Required) - **Gross Sales** - Gross sales for the 15-minute period. - **Net Sales** - Net sales for the 15-minute period. - **Entree -** Entree count for the 15-minute period. At least one sales total (either gross or net) is required for each interval. Missing intervals will have their gross, net, and entree values imported as 0. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-LZHT00UJ.png?sv=2026-02-06&spr=https&st=2026-11-10T17%3A10%3A05Z&se=2026-11-10T18%3A10%3A05Z&sr=c&sp=r&sig=IBw9QvukwRi43PZBcZrpqL25CjYv9%2FNisABu291WATQ%3D) ****5)** Return to the importer, then click **Browse** to select a file or **drag and drop** the file onto the importer.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-NZVOGTFI.png?sv=2026-02-06&spr=https&st=2026-11-10T17%3A10%3A05Z&se=2026-11-10T18%3A10%3A05Z&sr=c&sp=r&sig=IBw9QvukwRi43PZBcZrpqL25CjYv9%2FNisABu291WATQ%3D) ****6)** Click **Import**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-4XLXN52K.png?sv=2026-02-06&spr=https&st=2026-11-10T17%3A10%3A05Z&se=2026-11-10T18%3A10%3A05Z&sr=c&sp=r&sig=IBw9QvukwRi43PZBcZrpqL25CjYv9%2FNisABu291WATQ%3D) ****7)** If the import is successful, the number of rows successfully imported is displayed.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-8QOTTK78.png?sv=2026-02-06&spr=https&st=2026-11-10T17%3A10%3A05Z&se=2026-11-10T18%3A10%3A05Z&sr=c&sp=r&sig=IBw9QvukwRi43PZBcZrpqL25CjYv9%2FNisABu291WATQ%3D) ### Import Errors When an import includes rows with errors, those rows are skipped and a correction file is generated. The correction file lists each failed row and the reason it failed. Enter corrections directly in the downloaded correction file and upload it again. There is no need to move failed rows into a new import template or remove the ‘Problem’ column. ****8)** Click **Download Correction List**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-AW360IAV.png?sv=2026-02-06&spr=https&st=2026-11-10T17%3A10%3A05Z&se=2026-11-10T18%3A10%3A05Z&sr=c&sp=r&sig=IBw9QvukwRi43PZBcZrpqL25CjYv9%2FNisABu291WATQ%3D) ****9)** Review the **‘Problem’ column** for error reasons, then **correct any issues.**** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-01GM99PE.png?sv=2026-02-06&spr=https&st=2026-11-10T17%3A10%3A05Z&se=2026-11-10T18%3A10%3A05Z&sr=c&sp=r&sig=IBw9QvukwRi43PZBcZrpqL25CjYv9%2FNisABu291WATQ%3D) ****10)** **Re-import** the corrections file. (Repeat steps 5 - 10).** If there are any additional unsuccessful imports, continue repeating the steps until all rows have been corrected and imported. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-AYTGJO6Y.png?sv=2026-02-06&spr=https&st=2026-11-10T17%3A10%3A05Z&se=2026-11-10T18%3A10%3A05Z&sr=c&sp=r&sig=IBw9QvukwRi43PZBcZrpqL25CjYv9%2FNisABu291WATQ%3D) Daily sales summary (DSS) Record generated by daily data sent from the POS that may include sales, labor, menu items, and payment details.