You can add owner charges and expenses manually by adding transactions via Accounting reports, in a reservation, or in the posting journal.
If you would like to import expenses or owner charges in bulk, you can provide a CSV file with the following columns and data. Please contact us with the completed CSV file attached.
Template to bulk import owner charges into posting journal
Important:
Rows that have invalid or missing data will fail during upload.
Download the template here.
Template columns explained
- name (name)
- category (see list of supported categories below)
- description - max length 255 characters
- amount (in account currency)
- Must be as a numeric value with no commas or special characters.
- For example: enter 1000, not "1,000".
- Must be as a numeric value with no commas or special characters.
- recognitionDate (in year-month-day format)
- ownerId
- listingId*
- revenueShare*: If revenue share is not defined, the default split will be 100% attributed to the PMC.
- shareSplit -floating point number that represents the percentage. Do not enter a percentage amount. For example:
- 0.5 means that the share is 50% between PMC and Owner
- 0.1 means that the share is 10% Owner and 90% PMC
- 0 means that the charge is covered 100% by PMC
- vendorId
- shareSplit -floating point number that represents the percentage. Do not enter a percentage amount. For example:
* = optional fields, all others are required
Supported categories
advertising
cleaning
damage_waiver
electricity
furniture_appliances
gas
internet
lock_automation
management
mortgage
pest_control
pool_cleaning
property_taxes
repairs_maintenance
supplies_purchases
other_misc
taxes_paid
telephone
television
trash
water_septic
guest_cleaning
owner_cleaning
channel_commission
payment_charge
pet_fee
startup_fee
fotoshoot
vat
insurance
monitoring_surveillance
garden_maintenance
jacuzzi_maintenance
sauna_maintenance
photoshoot
bank_fees
sta_licensing
security
laundry
gardening
guest_compensation
home_improvement
other_expenses
other_income
other_services_ops_assistants
painting
plumbing
refund
refund_security_deposit
rubbish_removal_service
set_up_fee
strata_rates
security_deposit
Template to bulk import expenses into posting journal
Important:
Rows that have invalid or missing data will fail during upload.
Download the template here.
Template columns explained
- name (expense name)
- category (see list of supported categories below)
- description - max length 255 characters
- amount (in account currency)
- Must be as a numeric value with no commas or special characters.
- For example: enter 1000, not "1,000".
- Must be as a numeric value with no commas or special characters.
- recognitionDate (in year-month-day format)
- vendorId
- expenseShare*: If expense share is not defined, the default split will be 100% attributed to the PMC.
- shareSplit -floating point number that represents the percentage. Do not enter a percentage. For example:
- 0.5 means that the share is 50% between PMC and Owner
- 0.1 means that the share is 10% Owner and 90% PMC
- 0 means that the charge is covered 100% by PMC
- ownerId
- listingId
- shareSplit -floating point number that represents the percentage. Do not enter a percentage. For example:
* = optional fields, all others are required
Supported categories
advertising
cleaning
damage_waiver
electricity
furniture_appliances
gas
internet
lock_automation
management
mortgage
pest_control
pool_cleaning
property_taxes
repairs_maintenance
supplies_purchases
other_misc
taxes_paid
telephone
television
trash
water_septic
guest_cleaning
owner_cleaning
channel_commission
payment_charge
pet_fee
startup_fee
fotoshoot
vat
insurance
monitoring_surveillance
garden_maintenance
jacuzzi_maintenance
sauna_maintenance
photoshoot
bank_fees
sta_licensing
security
laundry
gardening
guest_compensation
home_improvement
other_expenses
other_income
other_services_ops_assistants
painting
plumbing
refund
refund_security_deposit
rubbish_removal_service
set_up_fee
strata_rates
security_deposit
Find listing IDs
Your listing IDs can be found by adding a column in the properties report.
Step by step:
- Sign in to your Guesty account.
- In the top navigation bar, click the mode selector and select Operations mode.
- Click Properties.
- Select the desired filter.
- At the top right, click Columns and enter "listing" in the search bar.
- Toggle on Listing ID.
- Click Save as new custom report.
- Type a name for the custom report and click Save.
Find owner IDs
Owner IDs can be found by downloading an owner report csv file from the Owners page.
Step by step:
- Sign in to your Guesty account.
- In the top navigation bar, click the mode selector and select Operations mode.
- Click Owners.
- Narrow down the data for your file as needed by searching for a specific owner or by properties.
- At the top right, click
. - In the downloaded file, find the relevant owner ID in the first column. Example:
67cb6290e3e16c1ef21a330f
