Difference between revisions of "Export Invoices"

From Charitylog Manual
Jump to: navigation, search
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
[[File:helpheader_small.png|right]]
 
[[File:helpheader_small.png|right]]
  
[[File:Menu_exportinv.PNG]]
+
[[File:exp_inv.jpg|400px|alt="the charitylog invoicing menu with button for export invoices."]]
  
 
The export invoice page allows you to export invoice date to e spreadsheet to be imported into your accounts package.  Please note that this does not include any payroll data for the [[Modules|Roster Module]].
 
The export invoice page allows you to export invoice date to e spreadsheet to be imported into your accounts package.  Please note that this does not include any payroll data for the [[Modules|Roster Module]].
Line 7: Line 7:
 
To produce the export complete the following:
 
To produce the export complete the following:
  
[[File:Inv_export.PNG]]
+
[[File:ex_inv1.jpg|700px|alt="a selection of invoice input fields, such as date, invoice number, invoice layout."]]
  
 
* '''From Invoice Number''' - If you are looking for a range of invoices enter the lowest invoice number to include.
 
* '''From Invoice Number''' - If you are looking for a range of invoices enter the lowest invoice number to include.
Line 27: Line 27:
 
Click on the 'Export' button to create the spreadsheet.  If no invoice data has been found you will be displayed the following message:
 
Click on the 'Export' button to create the spreadsheet.  If no invoice data has been found you will be displayed the following message:
  
[[File:INV_noinvoice.PNG]]
+
[[File:ex_inv2.jpg|700px|alt="a message displaying the words: Export Invoices to Accounts System, There are no invoices to export. Have you already exported them? Try again"]]
  
 
Click the 'Try Again' link to adjust your search criteria.
 
Click the 'Try Again' link to adjust your search criteria.

Latest revision as of 16:33, 9 February 2024

Helpheader small.png

"the charitylog invoicing menu with button for export invoices."

The export invoice page allows you to export invoice date to e spreadsheet to be imported into your accounts package. Please note that this does not include any payroll data for the Roster Module.

To produce the export complete the following:

"a selection of invoice input fields, such as date, invoice number, invoice layout."

  • From Invoice Number - If you are looking for a range of invoices enter the lowest invoice number to include.
  • To Invoice Number - If you are looking for a range of invoices enter the highest invoice number to include.
  • Earliest Invoice Date - Enter the date of the earliest invoices to include, this use the invoice date set by the Pre-Invoice list.
  • Project - If you wish to export invoice for specific projects then select them here. Click the first required project then hold down the CTRL key on your keyboard whilst clicking the remaining required projects.
  • Export Layout - Select the export type for the accounts system:
    • Sage Line 50 Sales Ledger
    • Sage Line 50 Invoice Production
    • Sage Line 50 Invoice Projection (With Paid Details)
    • Sage Line 200 Invoice Production
    • Access Accounts
    • Xero Sales Invoices
  • Show Headings? - If your accounts package requires headings then set to yes, normally this is not required.
  • Exported to Accounts? - Choose to include previously exported, not exported or all invoices.
  • Include All Invoices or Unpaid/Paid Only? - Include Paid, unpaid or all.
  • Export File Name - Specify a file name if required.

Click on the 'Export' button to create the spreadsheet. If no invoice data has been found you will be displayed the following message:

"a message displaying the words: Export Invoices to Accounts System, There are no invoices to export. Have you already exported them? Try again"

Click the 'Try Again' link to adjust your search criteria.