Skip to main content

Transactions

This job fetches all transactions made in your bank account from Actual. If you want to get all transactions, you can use fetch account transactions

Add this job

Data

Sample Data

Open in new tab -

Data headers

HeaderDescription
dateDate and time of the transaction
payeeName of the payee
imported_payeeImported name of the payee
amountAmount transacted
notesAdditional notes related to the transaction
subtransactionsSubtransactions associated with the main transaction
accountAccount associated with the transaction
categoryCategory of the transaction
starting_balance_flagFlag indicating if this is a starting balance
clearedIndicates if the transaction is cleared
reconciledIndicates if the transaction is reconciled
is_parentIndicates if the transaction is a parent transaction
is_childIndicates if the transaction is a child transaction
errorError status of the transaction
tombstoneIndicates if the transaction is a tombstone
scheduleSchedule associated with the transaction
sort_orderOrder in which the transaction is sorted
idUnique ID of the transaction
parent_idID of the parent transaction
imported_idImported ID associated with the transaction
transfer_idID of the transfer transaction

Filtration options

This job can restrict the data that is visible in spreadsheets. Use the following parameters to restrict the data.

ParameterOptions
start_dateSelect transactions with billing date on or after start_date. Format - YYYY-MM-DD
end_dateSelect transactions with billing date on or before end_date. Format - YYYY-MM-DD
account_idSelect transactions related to a particular account. Account id is the id of the account from actual.