EDIT
I forgot to change the invoiceDate type to 'date' in the previously posted query; here is the correction:
let
Source = Json.Document(File.Contents("C:\Users\MasonMitchell\OneDrive - E3IT.tech\Downloads\QBSE_Invoices (1).json")),
AsTable = Table.FromRecords(Source),
#"Removed Columns" = Table.RemoveColumns(AsTable,{"dateCreated", "dateUpdated"}),
#"Changed Type" = Table.TransformColumnTypes(#"Removed Columns",{{"amount", Currency.Type}}),
#"Removed Columns1" = Table.RemoveColumns(#"Changed Type",{"message", "allowOnlineCreditCardPayment", "allowOnlineACHPayment", "businessNumber", "logoSource", "paymentDetails", "salesTaxType", "rememberPaymentDetails", "v4LocalId", "events", "invoiceSender", "salesTaxItems"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Removed Columns1",{{"dueDate", type date}, {"invoiceDate", type date}})
in
#"Changed Type1"
