Sales & Mktg City Ledger Export (Desktop) 🎥

Sales & Mktg City Ledger Export (Desktop) 🎥

Part of any business is marketing their products and/or services they supply to their existing or potential customers. Visual Matrix offers a platform that will allow you to create mailing lists for their existing customer base. There are four primary target areas where data is collected.
In the Sales and Marketing database, a collection of data is provided for the City Ledger. Examples of some available filters are as follows: Account #, (one account or all). You can see the total YTD revenue for a particular company once filters are put in place. The created list can be printed or exported to allow for possible label printing or email transmission.
Path: Sales and Marketing > Marketing > City Ledger

1. The report can be filtered with 14 parameters that we can sort into 5 categories:
- By type of city ledger: account number, member of a CL group, or if the CL is active or not (Status).
- By date: booking and/or arrival day.
- By provenance: zip code, state/province and/or country.
- By revenue: revenue or number of nights overall and/or year to date
- By contact information: if the profile has a fax number and/or an email.

2. Click Process.



3. The screen report will show a limited number of information as followed:
- City Ledger Account Number, Membership Code, and City Ledger Name.
- Contact Name, Telephone, Fax and Email.

4. Click Print to print this result or click Export to get more data. See next.



5. Choose the Format you want for the data export: Comma Delimited (PeachTree), Tab Delimited, XML or IIF (Quickbooks).
6. Enter a name for the file.
7. Click OK.



8. Choose if you want to merge the data by City Ledger or have every reservations for every City Ledger Account.



9. See the attached document for an example of the exported data. It will include the 26 following fields:
- City edger Account Number, Member Code and Account Name.
- Contact Last and First Name, City, State, Zip and Country, Telephone, Fax and Email.
- Number of Nights and Revenue generated for the reservation, if export by reservation.
- Arrival Date and Date the reservation was Made, if export by reservation.
- City Ledger Account Address 1 and 2, Account Active or not, Contact Name Authorized to Book.
- City Ledger Account VM ID.
- If the Account allows Override and Weekend and Weekdays Override Rates.
    • Related Articles

    • Sales & Mktg Company Export (Desktop) 🎥

      ? Watch Video Part of any business is marketing their products and/or services they supply to their existing or potential customers. Visual Matrix offers a platform that will allow you to create mailing lists for their existing customer base. In the ...
    • Sales & Mktg Travel Agent Export (Desktop) 🎥

      ? Watch Video Part of any business is marketing their products and/or services they supply to their existing or potential customers. Visual Matrix offers a platform that will allow you to create mailing lists for their existing customer base. In the ...
    • Sales & Mktg Guest Export (Desktop) 🎥

      ? Watch Video Part of any business is marketing their products and/or services they supply to their existing or potential customers. Visual Matrix offers a platform that will allow you to create mailing lists for their existing customer base. Path: ...
    • Sales & Mktg City Ledger Profile (Desktop) 🎥

      ? Watch Video The City Ledger in Sales and Marketing provides various sections of information for clients that have Direct Billing privileges. Path: Sales and Marketing > City Ledger. The City Ledger profile in Sales & Marketing is divided into 6 ...
    • Sales & Mktg City Ledger Forecast Report (Desktop) 🎥

      ? Watch Video The City Ledger forecast report will display a recap of each City Ledger currently linked to a reservation in the system. Path: Sales & Marketing > Reports > Forecast > City Ledger Generate report 1. Narrow down the report by choosing ...